August 28, 2003 at 11:23 am
I get the error:
Error -2147199232 [Microsoft][ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler: Process 97 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
In the statement below:
Dim oSQLServer As SQLDMO.SQLServer2
Set oSQLServer = New SQLDMO.SQLServer2
oSQLServer.Connect "Server", "Userid", "Password"
Dim oDatabase As SQLDMO.Database2
Set oDatabase = oSQLServer.Databases("MyDB")
I have Microsoft Management Console 1.2, Version 5.0 (Build service Pack 4)
September 1, 2003 at 8:12 am
I dont think its your MMC version. Which line causes it to break? Nothing wrong with your code, I'd guess something junked up in the dmo libraries. One fix might (!) be to reinstall SQL and or the latest service pack on the machine you're using for testing. Probably worth testing your code from another machine first to rule that out. If it works on another machine, then the issue is on the server. You could try the reinstall (use caution) or reapply the last service pack. Probably should take a look at the dump file created. May also be worth a call to MS support.
Andy
September 10, 2003 at 10:25 am
Take a look at this kb article
http://support.microsoft.com/default.aspx?scid=kb;en-us;327424
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply