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?