How to convert Extended stored procedures from 32-bit to 64-bit compatible

Hi Team,

We have an requirement where we need to use a 32 bit dll developed in C++ in the  64-bit environment (Windows server 2008 and SQL Server 2005 64-bit). This 32bit dll is being loaded in SQL Server instance memory with the help of an extended stored procedure, as per existing functionality.

While executing the extended procedure in above mentioned 64-bit environment, we got the error – ‘Could not load dll’. The dll we are trying to load in 64 bit environment in turn uses another 32 bit dll which is a third party dll with no source code available.

We have tried recompiling the 32 bit dll into 64 bit but received following linker errors:

 <image missing>

If anyone have faced or come across similar challenge then please suggest the approach taken. Any inputs/suggestions to recompile the dll into 64 bit will really help us to take this forward.

Regards,

Ankur Kumar