February 8, 2008 at 10:16 am
I created an extended procedure in the following format
sp_addextendedproc xp_add , 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll'
When i was try to execute it, getting the following error
Cannot find the function xp_add in the library C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll. Reason: 127(The specified procedure could not be found.).
please help me out
February 8, 2008 at 6:13 pm
Is that file path on the server... or on your desktop box?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 8, 2008 at 8:33 pm
its in my specified folder
February 10, 2008 at 8:01 am
susheereddy (2/8/2008)
its in my specified folder
The server needs to be able to "see" and "read" your "specified folder". That's why I was asking what its physical location was.
Good luck.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2008 at 12:04 pm
this is where is stored my dll file
C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll
thanks for ur reply
February 10, 2008 at 12:57 pm
I know... you said that before...
WHICH MACHINE is that on! Is it on the SQL Server or on your DESKTOP computer?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 10, 2008 at 1:29 pm
I mean i have installed a developer edition in my computer and thats path is in C folder
i am learning sql i don't have any real time experience
February 10, 2008 at 3:45 pm
Ok... understood...
Run the following query from SSMS and let's make sure that the "server" (your Developer's Edition) can see the file...
EXEC master..xp_fileexist 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll'
--Jeff Moden
Change is inevitable... Change for the better is not.
February 11, 2008 at 10:40 am
Thank u man
i have executed the command which u said and it shows that the file is existed.
I have no problem in creating an extended procedure and only problem i am getting is while executing it.
I don't why i am getting this error.
Cannot find the function xp_add1 in the library C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll. Reason: 127(The specified procedure could not be found.).
February 11, 2008 at 4:08 pm
Could it be that simple? Your original post said you added an extended sp called "xp_add" yet in your latest post you say you are using "xp_add1". Do notice the extra character there...
I'm running out of ideas here...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 11, 2008 at 5:37 pm
since xp_add is already there i have created one more xp_add1 with all your suggestions but still i am getting the same error
thanks for ur support
February 11, 2008 at 5:53 pm
When you created the new xp's, did you make sure that you created them in the Master database?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply