April 14, 2003 at 4:41 pm
I keep getting the below error in query analyzer. when doing a query to a linked server, this started after upgrading to sp2.
-------------------------------------------
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'SQLOLEDB'.
________________________________________-_-
any ideas? thanks
April 14, 2003 at 4:56 pm
April 15, 2003 at 6:03 am
Thanks much for the tip I'll try it later today.
RB
April 15, 2003 at 1:38 pm
I reregistered sqloledb, now am getting a new error with queries to link servers (selects only)
---------------------------------------------
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
_____________________________________________
any clues? thanks
April 15, 2003 at 2:54 pm
Which version of SQL Server you are running? If it is 7.0, check KB http://support.microsoft.com/default.aspx?scid=kb;en-us;196292
April 15, 2003 at 5:01 pm
thaks to all for your help, afnter I deleted all the linked servers, then recreated them.
THEN rebooted the server, the problem was fixed. Thanks again for all your help
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply