Extended stored procs on 64 bit MSSQL 2008

• Girish Bhat

  Ten Centuries

  Points: 1323

  More actions

  August 31, 2010 at 4:07 am

  #226344

  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?

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  August 31, 2010 at 11:51 pm

  #1214729

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

• Girish Bhat

  Ten Centuries

  Points: 1323

  More actions

  September 1, 2010 at 12:10 am

  #1214737

  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.

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  January 20, 2011 at 5:55 am

  #1275831

  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.

  ---------------------------------------------------------------------