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.


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).
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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s