Creating an Extended Stored Procedure

  • I have created a .dll (extended stored procedure) using VB6. I ran sp_addextendedproc and got a "completed successfully." However, when I try to execute the xp i get the following message.

    "Cannot load the DLL xp_distance.dll, or one

    of the DLLs it references. Reason: 193(error not found)."

    Anyone have ideas as to where I am going wrong. Thanks.

  • I didnt realize you could create an extended proc in pure VB, thought it had to be C?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • C++ is required it has a specifc type of entry point that allows communication to take place. It is not a COM dll like VB. I have not tried but in theory thou you could make a VB xp DLL if you could convert the C++ stuff to VB and hook the right APIs but as I said I haven't tried, nor have I seen done. If you don't have C++, I do freelance work and could build it for you, just email me. Depending on how much work it involves I may charge a small fee but if fairly easy I would be glad to help.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • Thanks guys. I thought this might be the problem as it slipped my mind that VB creates com dll's. Thanks for the offer, but its time I got into C++ a little and what I want to do is not that big of a deal.

    Thanks again

    C++ is required it has a specifc type of entry point that allows communication to take place. It is not a COM dll like VB. I have not tried but in theory thou you could make a VB xp DLL if you could convert the C++ stuff to VB and hook the right APIs but as I said I haven't tried, nor have I seen done. If you don't have C++, I do freelance work and could build it for you, just email me. Depending on how much work it involves I may charge a small fee but if fairly easy I would be glad to help.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

    [/quote]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply