Extended StoredProc causing error.

[MikeL04]

Hello all,

I am having some difficulty getting a extended stored proc to work on SQL2000 on a 2000 box. I wrote an extended proc that uses tcp/ip to send specified data to a specified ip and port. I wrote it in c++7 (.net) and installed it on MSDE sql2000 on my xp box and it runs perfect. Then I try copying my dll to the binn folder on a win2000 box, installed the .net redist and service pack 2, register the proc/dll in query analyzer successfully but when I run it now I get the error:

ODBC: Msg 0, Level 16, State 1
Cannot load the DLL XPROC_Swipe_Notifier.DLL, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

I am confused now. It runs on sql2000 MSDE on my xp box but not on my sql2000 MSDE on my 2000 box. Since I wrote it in c++7 I installed the framework redist but still no go.

Any ideas?

Thanks,

Mike

 

[cheyney]

I had a similar problem with an ex. stored procedure of mine and this is what some cat at codeproject.com told me to do:

"I suggest opening the DLL with the "Dependency Walker" (depends.exe) from the Windows 2000 Support Tools. The support tools are available on the Windows 2000 CD-ROM. Open the DLL and look at the middle pane in the window, you shouldn't see anything missing."

worked for me...

cheyney

 

[NullTerminator]

another quicky is to set a mapping for the extension .dll to use regsvr32.exe as the application to open the dl.l

Double Clicking the XPROC_Swipe_Notifier.DLL in explorer will try to load it and it will point out the first missing dll it finds. If there are many missing dependencies, it will take several tries. in that case Depends.exe may be more helpful.

\0

 

[MikeL04]

Thanks for the replys guys. I didn't know there was a dependency checker, that would have been helpful. I was about to try the regsvr32 method but first thought I would trry and install the whole .Net SDK eventhough there is no way that would have anything to do with it. What trying that did tell me though was that I was on MDAC 2.6 on the 2000 box whereas I was at 2.7 on the xp box. I downloaded the 2.7 upgrade for the 2000 box and that seems to have done the trick.

Next time I am definatly doing the depends.exe first.

Thanks again.

Mike