Posts

Showing posts from June, 2010

NAV 2009 Issues in Role Tailored Client

Image
Role tailored client issue




Changing stored procedure to 64 bit in NAV 2009

Did install Dynamics NAV 2009 on windows 2008 64 bit / Windows 7 65 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 NAV\60\Database\xp_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 \\vedfssrv01\DynamicsNAV2009\W1\DVD\Sql_esp\x64\ xp_ndo_x64.dll to C:\Program Files (x86)\Microsoft Dynamics NAV\60\Database

3. Rename existing xp_ndo.dll to xp_ndo_x32.dll

4. Rename xp_ndo_x64.dll to xp_ndo.d…

Code blocks are not allowed in this file

Whenever you encounter this error, when having Server Side Script in your custom ASPX Page stored in your Pages Library, you just need to add this line in your site's web.config.

Do not forget to replace the VirtualPath to point to the folder or library which has those pages.






<PageParserPaths>



<PageParserPath VirtualPath="/sites/TestSites/page/*" CompilationMode="Always" AllowServerSideScript="true" />


</PageParserPaths>