unhandled exception 'System.Data.SqlClient.SqlException'

jinfor

I opened the SQLCompareCodeSnippets in Visual Studio .NET 2003 (Visual Basic project) and tried to run it (with the WidgetProduction and WidgetStaging databases already built) and I get the following error:

An unhandled exception of type 'System.Data.SqlClient.Sqlexception' occurred in system.data.dll. Additional Information: System Error

Any ideas?

Brian Donahue

Hello,

This isn't incredibly revealing. Can you check the application and system event logs for more information about the error please?

jinfor

The code is running on a Windows 2000 server, if that is of any help. The line that is throwing the error is:

db1.Register(New ConnectionProperties(".", "WidgetStaging"), Options.Default)

Thanks.

Brian Donahue

Maybe you'd get more information if you wrapped db1.Register() in a try/catch block, catch the SqlException and write the SqlException.Message to the console.

try{
db1.Register(New ConnectionProperties(".","widgetStaging", Options.Default);
}
catch (SqlException e) {
Console.WriteLine("SQL Error "+ e.State.ToString()+": "+e.Message);
}

jinfor

That worked and I am able to run the code.

Thank you.

Brian Donahue

Great! I'm glad for that!