Problems with SQL Compare

Brian DonahueBrian Donahue Posts: 6,590 New member
edited April 20, 2004 6:05AM in SQL Compare Previous Versions
Hi Ruvan,

I think this is the same problem as one we've run into last week. I will
email a patch to you that should fix the problem.

Regards,

Brian Donahue
Red Gate Technical Support


"Ruvan Fernando" <[email protected][REMOVE-THIS]NETPEOPLE.DK> wrote in message
news:[email protected]
> Hi Redgate
>
> As I mentioned in a previous post I am developing a deploy tool.
> Using some databases works fine, but now I have started to use the ToolKit
> on production databases and suddenly the comparison operation can't
> complete.
>
> I tried to do it using the SQL Compare GUI tool (version 3.1.5.191) and
the
> error also occurs. BUT! What's really strange is that the SQL Compare tool
> works on the problematic databases from another machine - but not my
Deploy
> application, that still gets the same error as shown below.
>
>
>
> at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16 category,
> EventLogEntryType type, String[] strings, Byte[] rawData)
> at System.Diagnostics.EventLog.WriteEntry(String message,
> EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type, Int32 eventID, Int16 category)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type, Int32 eventID)
> at System.Diagnostics.EventLog.WriteEntry(String source, String
message,
> EventLogEntryType type)
> at RedGate.SQLCompare.Engine.Database.GetDependencies(String sql,
Boolean
> quotedIdentifiers, Boolean throwExceptions)
> at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
> connectionProperties, Options options)
> at Deployer.DatabaseCompare.CompareDatabases() in
> c:videployerdbcompare.cs:line 52
> at Deployer.DeployProject.CompareDataBases() in
> c:videployerdeployproject.cs:line 135
> at Deployer.Form1.StartCompare_Click(Object sender, EventArgs e) in
> c:videployerform1.cs:line 603
>
> The error both the GUI displays and the ToolKit returns is: "The parameter
> is incorrect" right after examining "comments" objects.
>
> I have attached a screenshot also.
>
>
>
> Both machines that run SQL Compare and my Deploy tool runs on Windows
Server
> 2003 (the one that works is however a Standard, mine is a Enterprise).
> Databases are SQL Server 2000 running on Windows 2000 machines.
>
>
> Any ideas?
>
> Best regards,
>
> Ruvan Fernando
> System Developer
> NetPeople A/S
> Denmark
>
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Scott,

    The patch is on the way!

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <[email protected]> wrote in message
    news:[email protected]
    > Brian, I think we are having the same problem. After installing 3.1.5.191
    > SQL Compare, we are receiving the "The parameter is incorrect" message
    box.
    > I had to get some compares done, so I uninstalled Red-Gate and installed
    the
    > previous version to finish my tasks. This morning I re-installed the
    > 3.1.5.191 update, and now the process just hangs without receiving any
    > error. ?? I was trying to reproduce the error before I submitted the
    > problem. It seems that it (3.1.5.191) works on a small percent of our
    > databases, but not all like before. It does seem like the unicode/ansi
    > problem has been resolved in 3.1.5.191.
    >
    > Scott Tucholka
    > AQS
    >
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:#[email protected]
    > > Hi Ruvan,
    > >
    > > I think this is the same problem as one we've run into last week. I
    > will
    > > email a patch to you that should fix the problem.
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > >
    > > "Ruvan Fernando" <[email protected][REMOVE-THIS]NETPEOPLE.DK> wrote in message
    > > news:[email protected]
    > > > Hi Redgate
    > > >
    > > > As I mentioned in a previous post I am developing a deploy tool.
    > > > Using some databases works fine, but now I have started to use the
    > ToolKit
    > > > on production databases and suddenly the comparison operation can't
    > > > complete.
    > > >
    > > > I tried to do it using the SQL Compare GUI tool (version 3.1.5.191)
    and
    > > the
    > > > error also occurs. BUT! What's really strange is that the SQL Compare
    > tool
    > > > works on the problematic databases from another machine - but not my
    > > Deploy
    > > > application, that still gets the same error as shown below.
    > > >
    > > >
    > > >
    > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    category,
    > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type, Int32 eventID)
    > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > message,
    > > > EventLogEntryType type)
    > > > at RedGate.SQLCompare.Engine.Database.GetDependencies(String sql,
    > > Boolean
    > > > quotedIdentifiers, Boolean throwExceptions)
    > > > at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > connectionProperties, Options options)
    > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > c:videployerdbcompare.cs:line 52
    > > > at Deployer.DeployProject.CompareDataBases() in
    > > > c:videployerdeployproject.cs:line 135
    > > > at Deployer.Form1.StartCompare_Click(Object sender, EventArgs e) in
    > > > c:videployerform1.cs:line 603
    > > >
    > > > The error both the GUI displays and the ToolKit returns is: "The
    > parameter
    > > > is incorrect" right after examining "comments" objects.
    > > >
    > > > I have attached a screenshot also.
    > > >
    > > >
    > > >
    > > > Both machines that run SQL Compare and my Deploy tool runs on Windows
    > > Server
    > > > 2003 (the one that works is however a Standard, mine is a Enterprise).
    > > > Databases are SQL Server 2000 running on Windows 2000 machines.
    > > >
    > > >
    > > > Any ideas?
    > > >
    > > > Best regards,
    > > >
    > > > Ruvan Fernando
    > > > System Developer
    > > > NetPeople A/S
    > > > Denmark
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    edited September 16, 2004 9:00AM
    Hi Scott,

    It must be a problem in the dependency parsing code. I've had an email
    just today from someone with the same problem, where the application event
    logs fill up with 'couldn't parse' errors from SQL Compare.

    I am waiting for some information from the other customer, and when we
    find out what's wrong, I'll let you know.

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <[email protected]> wrote in message
    news:[email protected]
    > After I installed the patch (3.1.6.200), I retried a compare. I received a
    > message like "Log File is Full" (Cannot recreate to get the exact syntax).
    > Then I tried again, and it just locked up. I then rebooted my workstation
    > and retried and it locked up again on the 'Reading Comments' step (screen
    > shot). Please let me know if you need any additional information.
    >
    > Scott.
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > Hi Scott,
    > >
    > > The patch is on the way!
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Scott Tucholka" <[email protected]> wrote in message
    > > news:[email protected]
    > > > Brian, I think we are having the same problem. After installing
    > 3.1.5.191
    > > > SQL Compare, we are receiving the "The parameter is incorrect"
    message
    > > box.
    > > > I had to get some compares done, so I uninstalled Red-Gate and
    installed
    > > the
    > > > previous version to finish my tasks. This morning I re-installed the
    > > > 3.1.5.191 update, and now the process just hangs without receiving any
    > > > error. ?? I was trying to reproduce the error before I submitted the
    > > > problem. It seems that it (3.1.5.191) works on a small percent of our
    > > > databases, but not all like before. It does seem like the unicode/ansi
    > > > problem has been resolved in 3.1.5.191.
    > > >
    > > > Scott Tucholka
    > > > AQS
    > > >
    > > >
    > > > "Brian Donahue (Red Gate)" <[email protected]> wrote in
    message
    > > > news:#[email protected]
    > > > > Hi Ruvan,
    > > > >
    > > > > I think this is the same problem as one we've run into last
    week.
    > I
    > > > will
    > > > > email a patch to you that should fix the problem.
    > > > >
    > > > > Regards,
    > > > >
    > > > > Brian Donahue
    > > > > Red Gate Technical Support
    > > > >
    > > > >
    > > > > "Ruvan Fernando" <[email protected][REMOVE-THIS]NETPEOPLE.DK> wrote in message
    > > > > news:[email protected]
    > > > > > Hi Redgate
    > > > > >
    > > > > > As I mentioned in a previous post I am developing a deploy tool.
    > > > > > Using some databases works fine, but now I have started to use the
    > > > ToolKit
    > > > > > on production databases and suddenly the comparison operation
    can't
    > > > > > complete.
    > > > > >
    > > > > > I tried to do it using the SQL Compare GUI tool (version
    3.1.5.191)
    > > and
    > > > > the
    > > > > > error also occurs. BUT! What's really strange is that the SQL
    > Compare
    > > > tool
    > > > > > works on the problematic databases from another machine - but not
    my
    > > > > Deploy
    > > > > > application, that still gets the same error as shown below.
    > > > > >
    > > > > >
    > > > > >
    > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    > > category,
    > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > rawData)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > rawData)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type, Int32 eventID)
    > > > > > at System.Diagnostics.EventLog.WriteEntry(String source, String
    > > > > message,
    > > > > > EventLogEntryType type)
    > > > > > at RedGate.SQLCompare.Engine.Database.GetDependencies(String
    sql,
    > > > > Boolean
    > > > > > quotedIdentifiers, Boolean throwExceptions)
    > > > > > at
    > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > > > connectionProperties, Options options)
    > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > > > c:videployerdbcompare.cs:line 52
    > > > > > at Deployer.DeployProject.CompareDataBases() in
    > > > > > c:videployerdeployproject.cs:line 135
    > > > > > at Deployer.Form1.StartCompare_Click(Object sender, EventArgs
    e)
    > in
    > > > > > c:videployerform1.cs:line 603
    > > > > >
    > > > > > The error both the GUI displays and the ToolKit returns is: "The
    > > > parameter
    > > > > > is incorrect" right after examining "comments" objects.
    > > > > >
    > > > > > I have attached a screenshot also.
    > > > > >
    > > > > >
    > > > > >
    > > > > > Both machines that run SQL Compare and my Deploy tool runs on
    > Windows
    > > > > Server
    > > > > > 2003 (the one that works is however a Standard, mine is a
    > Enterprise).
    > > > > > Databases are SQL Server 2000 running on Windows 2000 machines.
    > > > > >
    > > > > >
    > > > > > Any ideas?
    > > > > >
    > > > > > Best regards,
    > > > > >
    > > > > > Ruvan Fernando
    > > > > > System Developer
    > > > > > NetPeople A/S
    > > > > > Denmark
    > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >
    >
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    edited September 16, 2004 9:01AM
    Hi Scott,

    It doesn't seem to be the numbering on its' own that causes a problem,
    because I can create any number of SPs using numbering and SQl Compare works
    okay with them...

    Is it possible for you to email your stored procedures to
    [email protected]?

    Thanks!

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <[email protected]> wrote in message
    news:tFIcxR%[email protected]
    > Hi Brian,
    >
    > I cleaned out the application event log and retried the compare and I
    think
    > I found the problem. We have a couple of large stored procedures that use
    > the ; number feature. Example: CREATE PROC [ EDURE ] [ owner. ]
    > procedure_name [ ; number ] <<. We get an error for each one that we
    have.
    > Before I ran the compare again, I increased my application event log to
    > handle 1024 instead of 512 and I think that allowed the compare to finish.
    > There is also a problem when scripting the number feature that it should
    > drop the procedure before it creates all the joined procedures.
    > Couldn't parse the following [first 16k follows]. Please contact
    > [email protected].
    >
    >
    /*==========================================================================
    > =======================
    >
    > ** NAME: dbo.AQSsp_OOS_Create_Reapply;1
    >
    >
    >
    > Hopes this helps in debugging,
    > Scott.
    >
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > Hi Scott,
    > >
    > > It must be a problem in the dependency parsing code. I've had an
    email
    > > just today from someone with the same problem, where the application
    event
    > > logs fill up with 'couldn't parse' errors from SQL Compare.
    > >
    > > I am waiting for some information from the other customer, and when
    we
    > > find out what's wrong, I'll let you know.
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Scott Tucholka" <[email protected]> wrote in message
    > > news:[email protected]r53...
    > > > After I installed the patch (3.1.6.200), I retried a compare. I
    received
    > a
    > > > message like "Log File is Full" (Cannot recreate to get the exact
    > syntax).
    > > > Then I tried again, and it just locked up. I then rebooted my
    > workstation
    > > > and retried and it locked up again on the 'Reading Comments' step
    > (screen
    > > > shot). Please let me know if you need any additional information.
    > > >
    > > > Scott.
    > > >
    > > > "Brian Donahue (Red Gate)" <[email protected]> wrote in
    message
    > > > news:[email protected]
    > > > > Hi Scott,
    > > > >
    > > > > The patch is on the way!
    > > > >
    > > > > Brian Donahue
    > > > > Red Gate Technical Support
    > > > >
    > > > > "Scott Tucholka" <[email protected]> wrote in message
    > > > > news:[email protected]
    > > > > > Brian, I think we are having the same problem. After installing
    > > > 3.1.5.191
    > > > > > SQL Compare, we are receiving the "The parameter is incorrect"
    > > message
    > > > > box.
    > > > > > I had to get some compares done, so I uninstalled Red-Gate and
    > > installed
    > > > > the
    > > > > > previous version to finish my tasks. This morning I re-installed
    the
    > > > > > 3.1.5.191 update, and now the process just hangs without receiving
    > any
    > > > > > error. ?? I was trying to reproduce the error before I submitted
    the
    > > > > > problem. It seems that it (3.1.5.191) works on a small percent of
    > our
    > > > > > databases, but not all like before. It does seem like the
    > unicode/ansi
    > > > > > problem has been resolved in 3.1.5.191.
    > > > > >
    > > > > > Scott Tucholka
    > > > > > AQS
    > > > > >
    > > > > >
    > > > > > "Brian Donahue (Red Gate)" <[email protected]> wrote in
    > > message
    > > > > > news:#[email protected]
    > > > > > > Hi Ruvan,
    > > > > > >
    > > > > > > I think this is the same problem as one we've run into last
    > > week.
    > > > I
    > > > > > will
    > > > > > > email a patch to you that should fix the problem.
    > > > > > >
    > > > > > > Regards,
    > > > > > >
    > > > > > > Brian Donahue
    > > > > > > Red Gate Technical Support
    > > > > > >
    > > > > > >
    > > > > > > "Ruvan Fernando" <[email protected][REMOVE-THIS]NETPEOPLE.DK> wrote in
    message
    > > > > > > news:[email protected]
    > > > > > > > Hi Redgate
    > > > > > > >
    > > > > > > > As I mentioned in a previous post I am developing a deploy
    tool.
    > > > > > > > Using some databases works fine, but now I have started to use
    > the
    > > > > > ToolKit
    > > > > > > > on production databases and suddenly the comparison operation
    > > can't
    > > > > > > > complete.
    > > > > > > >
    > > > > > > > I tried to do it using the SQL Compare GUI tool (version
    > > 3.1.5.191)
    > > > > and
    > > > > > > the
    > > > > > > > error also occurs. BUT! What's really strange is that the SQL
    > > > Compare
    > > > > > tool
    > > > > > > > works on the problematic databases from another machine - but
    > not
    > > my
    > > > > > > Deploy
    > > > > > > > application, that still gets the same error as shown below.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    > > > > category,
    > > > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type)
    > > > > > > > at
    RedGate.SQLCompare.Engine.Database.GetDependencies(String
    > > sql,
    > > > > > > Boolean
    > > > > > > > quotedIdentifiers, Boolean throwExceptions)
    > > > > > > > at
    > > > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > > > > > connectionProperties, Options options)
    > > > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > > > > > c:videployerdbcompare.cs:line 52
    > > > > > > > at Deployer.DeployProject.CompareDataBases() in
    > > > > > > > c:videployerdeployproject.cs:line 135
    > > > > > > > at Deployer.Form1.StartCompare_Click(Object sender,
    EventArgs
    > > e)
    > > > in
    > > > > > > > c:videployerform1.cs:line 603
    > > > > > > >
    > > > > > > > The error both the GUI displays and the ToolKit returns is:
    "The
    > > > > > parameter
    > > > > > > > is incorrect" right after examining "comments" objects.
    > > > > > > >
    > > > > > > > I have attached a screenshot also.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > Both machines that run SQL Compare and my Deploy tool runs on
    > > > Windows
    > > > > > > Server
    > > > > > > > 2003 (the one that works is however a Standard, mine is a
    > > > Enterprise).
    > > > > > > > Databases are SQL Server 2000 running on Windows 2000
    machines.
    > > > > > > >
    > > > > > > >
    > > > > > > > Any ideas?
    > > > > > > >
    > > > > > > > Best regards,
    > > > > > > >
    > > > > > > > Ruvan Fernando
    > > > > > > > System Developer
    > > > > > > > NetPeople A/S
    > > > > > > > Denmark
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Scott,

    Have you tried re-installing SQL Compare 1.51 without the patch that I
    sent you? This had cleared the problem for another customer. We think this
    might have something to do with one of Microsoft's security updates,
    although we haven't had the problem here.

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Scott Tucholka" <[email protected]> wrote in message
    news:tFIcxR%[email protected]
    > Hi Brian,
    >
    > I cleaned out the application event log and retried the compare and I
    think
    > I found the problem. We have a couple of large stored procedures that use
    > the ; number feature. Example: CREATE PROC [ EDURE ] [ owner. ]
    > procedure_name [ ; number ] <<. We get an error for each one that we
    have.
    > Before I ran the compare again, I increased my application event log to
    > handle 1024 instead of 512 and I think that allowed the compare to finish.
    > There is also a problem when scripting the number feature that it should
    > drop the procedure before it creates all the joined procedures.
    > Couldn't parse the following [first 16k follows]. Please contact
    > [email protected].
    >
    >
    /*==========================================================================
    > =======================
    >
    > ** NAME: dbo.AQSsp_OOS_Create_Reapply;1
    >
    >
    >
    > Hopes this helps in debugging,
    > Scott.
    >
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > Hi Scott,
    > >
    > > It must be a problem in the dependency parsing code. I've had an
    email
    > > just today from someone with the same problem, where the application
    event
    > > logs fill up with 'couldn't parse' errors from SQL Compare.
    > >
    > > I am waiting for some information from the other customer, and when
    we
    > > find out what's wrong, I'll let you know.
    > >
    > > Regards,
    > >
    > > Brian Donahue
    > > Red Gate Technical Support
    > >
    > > "Scott Tucholka" <[email protected]> wrote in message
    > > news:[email protected]
    > > > After I installed the patch (3.1.6.200), I retried a compare. I
    received
    > a
    > > > message like "Log File is Full" (Cannot recreate to get the exact
    > syntax).
    > > > Then I tried again, and it just locked up. I then rebooted my
    > workstation
    > > > and retried and it locked up again on the 'Reading Comments' step
    > (screen
    > > > shot). Please let me know if you need any additional information.
    > > >
    > > > Scott.
    > > >
    > > > "Brian Donahue (Red Gate)" <[email protected]> wrote in
    message
    > > > news:[email protected]
    > > > > Hi Scott,
    > > > >
    > > > > The patch is on the way!
    > > > >
    > > > > Brian Donahue
    > > > > Red Gate Technical Support
    > > > >
    > > > > "Scott Tucholka" <[email protected]> wrote in message
    > > > > news:[email protected]
    > > > > > Brian, I think we are having the same problem. After installing
    > > > 3.1.5.191
    > > > > > SQL Compare, we are receiving the "The parameter is incorrect"
    > > message
    > > > > box.
    > > > > > I had to get some compares done, so I uninstalled Red-Gate and
    > > installed
    > > > > the
    > > > > > previous version to finish my tasks. This morning I re-installed
    the
    > > > > > 3.1.5.191 update, and now the process just hangs without receiving
    > any
    > > > > > error. ?? I was trying to reproduce the error before I submitted
    the
    > > > > > problem. It seems that it (3.1.5.191) works on a small percent of
    > our
    > > > > > databases, but not all like before. It does seem like the
    > unicode/ansi
    > > > > > problem has been resolved in 3.1.5.191.
    > > > > >
    > > > > > Scott Tucholka
    > > > > > AQS
    > > > > >
    > > > > >
    > > > > > "Brian Donahue (Red Gate)" <[email protected]> wrote in
    > > message
    > > > > > news:#[email protected]
    > > > > > > Hi Ruvan,
    > > > > > >
    > > > > > > I think this is the same problem as one we've run into last
    > > week.
    > > > I
    > > > > > will
    > > > > > > email a patch to you that should fix the problem.
    > > > > > >
    > > > > > > Regards,
    > > > > > >
    > > > > > > Brian Donahue
    > > > > > > Red Gate Technical Support
    > > > > > >
    > > > > > >
    > > > > > > "Ruvan Fernando" <[email protected][REMOVE-THIS]NETPEOPLE.DK> wrote in
    message
    > > > > > > news:[email protected]
    > > > > > > > Hi Redgate
    > > > > > > >
    > > > > > > > As I mentioned in a previous post I am developing a deploy
    tool.
    > > > > > > > Using some databases works fine, but now I have started to use
    > the
    > > > > > ToolKit
    > > > > > > > on production databases and suddenly the comparison operation
    > > can't
    > > > > > > > complete.
    > > > > > > >
    > > > > > > > I tried to do it using the SQL Compare GUI tool (version
    > > 3.1.5.191)
    > > > > and
    > > > > > > the
    > > > > > > > error also occurs. BUT! What's really strange is that the SQL
    > > > Compare
    > > > > > tool
    > > > > > > > works on the problematic databases from another machine - but
    > not
    > > my
    > > > > > > Deploy
    > > > > > > > application, that still gets the same error as shown below.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > at System.Diagnostics.EventLog.WriteEvent(Int32 eventID, Int16
    > > > > category,
    > > > > > > > EventLogEntryType type, String[] strings, Byte[] rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category, Byte[]
    > > > rawData)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID, Int16 category)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type, Int32 eventID)
    > > > > > > > at System.Diagnostics.EventLog.WriteEntry(String source,
    > String
    > > > > > > message,
    > > > > > > > EventLogEntryType type)
    > > > > > > > at
    RedGate.SQLCompare.Engine.Database.GetDependencies(String
    > > sql,
    > > > > > > Boolean
    > > > > > > > quotedIdentifiers, Boolean throwExceptions)
    > > > > > > > at
    > > > RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties
    > > > > > > > connectionProperties, Options options)
    > > > > > > > at Deployer.DatabaseCompare.CompareDatabases() in
    > > > > > > > c:videployerdbcompare.cs:line 52
    > > > > > > > at Deployer.DeployProject.CompareDataBases() in
    > > > > > > > c:videployerdeployproject.cs:line 135
    > > > > > > > at Deployer.Form1.StartCompare_Click(Object sender,
    EventArgs
    > > e)
    > > > in
    > > > > > > > c:videployerform1.cs:line 603
    > > > > > > >
    > > > > > > > The error both the GUI displays and the ToolKit returns is:
    "The
    > > > > > parameter
    > > > > > > > is incorrect" right after examining "comments" objects.
    > > > > > > >
    > > > > > > > I have attached a screenshot also.
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > Both machines that run SQL Compare and my Deploy tool runs on
    > > > Windows
    > > > > > > Server
    > > > > > > > 2003 (the one that works is however a Standard, mine is a
    > > > Enterprise).
    > > > > > > > Databases are SQL Server 2000 running on Windows 2000
    machines.
    > > > > > > >
    > > > > > > >
    > > > > > > > Any ideas?
    > > > > > > >
    > > > > > > > Best regards,
    > > > > > > >
    > > > > > > > Ruvan Fernando
    > > > > > > > System Developer
    > > > > > > > NetPeople A/S
    > > > > > > > Denmark
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > >
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.