Extended stored procs on 64 bit MSSQL 2008

  • 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?

  • I would recommend writing CLR stored procedure instead of extended stored procedure.

  • 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.

  • 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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply