Changing stored procedure to 64 bit in NAV 2009

Posted by on Monday, September 7, 2009 · Leave a Comment 

Did install Dynamics NAV 2009 on windows 2008 64 bit. When trying to connect to the database in classic client I got this 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](?,?)}

The reason for this error is that the installed xp_ndo.dll is 32 bit and not 64 bit. My solution was simple to replace xp_ndo.dll with the 64 bit version.
1. Stop SQL server
2. Copy \vedfssrv01DynamicsNAV2009W1DVDSql_espx64 xp_ndo_x64.dll to C:Program Files (x86)Microsoft Dynamics NAV60Database
3. Rename existing xp_ndo.dll to xp_ndo_x32.dll
4. Rename xp_ndo_x64.dll to xp_ndo.dll
5. Start SQL server

0.00 avg. rating (0% score) - 0 votes

Filed under Dynamics NAV · Tagged with ,

About Peter Wibeck

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

CAPTCHA

*