August 31, 2010 at 4:07 am
We need to develop some extended stored procedures for 64-bit SQL Server 2008. We have written the DLL in Visual C++ but when we try to register it with the database, we see the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xp_test.dll, or one of the DLLs it references.
Reason: 193(failed to retrieve text for this error. Reason: 15105).(42000,17750) Procedure(xp_test)
Can anyone please tell me if you have come across such an issue and how it was successfully resolved?
August 31, 2010 at 11:51 pm
I would recommend writing CLR stored procedure instead of extended stored procedure.
September 1, 2010 at 12:10 am
Unfortunately, that is not an option in our case. We are aware that extended stored procs are a deprecated feature. Yet due to certain constraints this is the course of action we are left to pursue.
January 20, 2011 at 5:55 am
Did you get a resolution to this?
We have hit the same issue during an upgrade from SQL2000 to SQL2008 on xps used to extract data out of a foxpro database.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply