Extended Stored Procedure error(urgent)

tech_nav

Hi,

I created an extended stored procedure namely xp_ndo_enumusergroups as described in the IC pdf. My SQL server was running smoothly and i was able to login with windows authentication successfully until one day i started getting error about the same extended stored procedure when i tried to login with windows authentication.

The error is::

The following SQL Server error or errors occurred:

17751,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find the function xp_ndo_enumusergroups in the library C:\xp_ndo.dll. Reason: 127(The specified procedure could not be found.).

SQL:
INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}


That xp_ndo.dll exists in the specified path. Still getting this error. I deletd that procedure and created again but same error.. Should i restart the server after creating the procedure??

kriki

If you want urgent support, then buy a support ticket with Microsoft.
Putting urgent in your message is not the right way to get a response in this forum.
Please see Forum Rule(s) #3.2: Forum Rules.


[Topic moved from 'Navision e-Commerce' forum to 'SQL General' forum]