I have a (C++) 64-bit Extended Stored Procedure (XP) installed on 64-bit 2005 SQL Server on a 64-bit Windows XP machine. I can call its functions and it runs fine.
However, I have a user who is unable to call the same XP on the same version of SQL Server on his 64-bit Windows 2008 Server machine.
Checking the Event Viewer, he sees an event id 17750, saying that the dll is not a valid Win32 application.
Thinking that maybe my user has his facts incorrect, I've had him try the 32-bit version of the same DLL, and I get a similar error saying the dll is not a valid x64 application (do I need a 48-bit dll?!?)
As far as I can tell the only differences are: him using Windows 2008 Server, and the possibility that he has an incorrect dependent DLL (I had him install the 64-bit VC redist to be sure).
Any ideas on how I can further troubleshoot this?