🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: bit.databases.mssql-l
Article #2072

Re: Extended Stored Procedure

#2072
From: ODONNELL
Date: Thu, 04 May 1995 00:00
18 lines
1594 bytes
I have not done this with an xp but it sounds like a problem I had with a VB
call to a DLL.  Can you put the whole path to the DLL in the xp?  It may be
that your different versions were not running from the same "default"
directory.  Good luck.

Jon

> I'm having some trouble with SQL Server, maybe you can help, here's the
> problem :  I'm trying to build an 'extended stored procedure' ( extended
> stored procedures are a way to let SQL code call a function inside a DLL
> ).  I follow all of the instructions in the SQL Server manuals for
> building and installing the extended stored procedure.  Everything works
> fine when I test my procedure on a SQL 6.0 installation.  When I try to
> test my extended stored procedure in a SQL 4.2 installation I get the
> error:  Cannot find the DLL 'xp.dll' ( where xp.dll is the name of my DLL
> ).  I am creating the extended stored procedure DLL from the sample code
> supplied with SQL Server and I am using MS Visual C++ 2.0.
> MS Knowledge base article #Q108163 did not help.
Technical Details
Message-ID: <01HQ3KBRZOKY8WWYKT@edinboro.edu>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,e0e601880ff2a2c,start
X-Google-Attributes: gidf6611,public
From: ODONNELL@EDINBORO.EDU
Subject: Re: Extended Stored Procedure
Date: 1995/05/04
Message-ID: <01HQ3KBRZOKY8WWYKT@edinboro.edu>
X-Deja-AN: 102044660
sender: Microsoft SQL Server Discussion List
comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
content-type: TEXT/PLAIN; CHARSET=US-ASCII
x-vms-to: IN%"MSSQL-L%DUKEFSB.BITNET@VTBIT.CC.VT.EDU"
x-vms-cc: ODONNELL
mime-version: 1.0
newsgroups: bit.databases.mssql-l