You’re offline. This is a read only version of the page.
2,382
I installed new navision on new server and getting following error while creating new DB.
Share
ReportMicrosoft Dynamics NAV Classic
---------------------------
The following SQL Server error occurred:
17750 , " 42000 " , [ Microsoft] [ODBC SQL Server Driver ] [ SQL Server] The C: \ Program Files \ Microsoft SQL Server \ MSSQL10_50.MSSQLSERVER \ MSSQL \ Binn \ xp_ndo.dll DLL or a DLL to which they points could not be loaded. Reason: 193 (% 1 is not a valid Win32 application. ) .
SQL:
INSERT INTO [ # $ ndo $ groups ] { CALL [master ] .. [ xp_ndo_enumusergroups ] ( ?,?) }
I have tried this solution.
http://saurav-nav.blogspot.nl/2011/06/extended-stored-procedure-xpndodll.html
but didn't help.
*This post is locked for comments
There is a Windows Service for NAV. You can set the account on the Logon properties page of that service.
Hi NavTech,
Do you use Role Tailored Client? Do you assign ' NAVSQL \ LVE NAVKAT $ ' as account to start Microsoft Dynamics NAV Server?
Refer this blog and create accordinly : http://navguides.blogspot.com/2013/07/nav-issue-sql-server-xpndodll.html
http://saurav-nav.blogspot.com/2011/06/extended-stored-procedure-xpndodll.html
Now same problem when I open RTC I get same error
---------------------------
Microsoft Dynamics NAV
---------------------------
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(%1 ist keine zulässige Win32-Anwendung.).
SQL:
INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}
---------------------------
OK
---------------------------
You are using wrong client to open the database.
Please check which NAV version is used for Test database and which build like rollup erc
No, but did you try to use proper 64 bit xp_ndo.dll
Please re check again
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (