xp_ndo.dll Error – Extended Stored Procedure

 

Hello All,

Below Screenshot is a very common issue which we often face if anyhow there’s a change in the bit of the Operating System.

Error-

The following SQL server error or errors occurred:
17750,“42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL C:Program Files (x86)Microsoft Dynamics NAV60Databasexp_ndo.dll, or one of the DLLs it references. Reason: 193(failed to retrieve text for this error. Reason: 15100).
SQL:
INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}
 
Reason – Installed xp_ndo.dll is 32 bit and not 64 bit.
Simply replace xp_ndo.dll with the 64 bit version.
 
How to Do –
  • Stop SQL server.
  • Copy xp_ndo_x64.dll from installation DVD  to C:Program Files (x86)Microsoft Dynamics NAV60Database.
  • Rename existing xp_ndo.dll to xp_ndo_x32.dll.
  • Rename xp_ndo_x64.dll to xp_ndo.dll.
  • Start SQL server.
 Enjoy.
Advertisements