July 10, 2007 at 7:56 am
Hi There
I'm having problems installing a external stored procedure that I created in Visual C++. I've created the .ddl and put it in the correct directory.
I've run the following commands to install it
sp_addextendedproc xp_regex, "D:\garth\ExternalStoredProcedures\Tecas\xp_regex.dll"
I then exec the procedure and get the following:
execute master..xp_regex
ODBC: Msg 0, Level 16, State 1
Cannot load the DLL \\tedevsql02\garth\ExternalStoredProcedures\Tecas, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
The .dll is definately in that directory. I'm not sure what I'm doing wrong. Any tips?
Thanks
SynAck
July 10, 2007 at 8:11 am
When you add the path, you use D: when the error is \\tedevsql02.
is D: relative to that server?
How about security? Can SQL See that path?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
July 10, 2007 at 8:11 am
You can't place the dll's in any user folders they ust reside in SQL defined folder to take effect. read about creating extended procedure' in sql server.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 10, 2007 at 8:17 am
Sorry, I must have copied something after making a change but not commiting it.
The .dll has been moved to the "C:\Program Files\Microsoft SQL Server\Mssql\Binn" directory as it says in the help files.
sp_dropextendedproc xp_regex
GO
sp_addextendedproc xp_regex, "xp_regex.dll"
GO
============
ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xp_regex.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Same problem...
July 11, 2007 at 1:56 am
Try using the EM to add the ESP instead of query analyzer. Also is this dll registered in the server?
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply