Error while synchronizing the sql using the toolkit

mchenna

When I try to synchronize the sql between 2 databases, I get an error saying that an unhandled exception occured in microsoft.visualbasic.dll. Argument 'Prompt' cannot be converted to type 'String'.
I used VS.Net to create the comapre and sync application and tried to execute from there.
Any ideas why this happened?
Thanks in advance.

Brian Donahue

Hi,

Would it be possible for you to send your code to support@red-gate.com? I haven't seen that error before and am curious what's happening.

Brian Donahue

Hi,

Can you debug this and find the line of code that's throwing the exception?

I can see one possibility: the Try/Catch block wants to catch a SqlException and display a msgbox. I think this needs to print Exception.Message rather than Exception because that is not a string object.

Brian Donahue

Hi,

At what point in your code does this happen?

Brian Donahue

Hi,

Usually, that error happens because you're trying to run some code over a linked server. Possible?