Extended Stored Procedure creation error

4 Nov 2005 6:59 PM

nick

I've created an extended SP on my local machine (Win XP/ VS.Net 2003 / VC++).
It works fine when I tested on my local PC after I copied the created dll
file to binn directory and ran sp_addextendedproc.

I copied it to a Win 2000 Server/MS SQL's binn directory and
sp_addextendedproc completed successfully. However, it gives the following
error when I execute the stored procedure:

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

Is the dll rely on some other dlls? or should I use Visual C++ 6.0?

4 Nov 2005 8:07 PM

nick

I found the solution myself, I just copied the following two files to the
binn folder:

DLL Name: MSVCP70.dll
DLL Name: MSVCR70.dll

Or should I copy them to Winnt\system32?

Show quote

"nick" wrote:

> I've created an extended SP on my local machine (Win XP/ VS.Net 2003 / VC++).
> It works fine when I tested on my local PC after I copied the created dll
> file to binn directory and ran sp_addextendedproc.
>
> I copied it to a Win 2000 Server/MS SQL's binn directory and
> sp_addextendedproc completed successfully. However, it gives the following
> error when I execute the stored procedure:
>
> ODBC: Msg 0, Level 16, State 1
> Cannot load the DLL "uxp_calc_sw_v1.dll", or one of the DLLs it references.
> Reason: 126(The specified module could not be found.).
>
> Is the dll rely on some other dlls? or should I use Visual C++ 6.0?
>
>
>

4 Nov 2005 11:13 PM

Erland Sommarskog

nick (n***@discussions.microsoft.com) writes:

> I found the solution myself, I just copied the following two files to the
> binn folder:
>
> DLL Name: MSVCP70.dll
> DLL Name: MSVCR70.dll
>
> Or should I copy them to Winnt\system32?

There is some guidelines on this in MSDN Library. I had reason to
investigate the story about the Visual C DLL:s myself a while back. My
impressions is that the recommendation is that you should should distribute
the DLL:s with your code, and place in them together with your application.
Thus, you did put them into the right place.

If you want an answer from people who really understand this, you should
ask in a C++ newsgroup.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp