Problem in Installation

(0) Share

Report

Posted on by NavTech

2,390

I installed new navision on new server and getting following error while creating new DB.

Microsoft 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

I have the same question (0)

All responses (14)

Answers (3)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

do you have the proper xp_ndo.dll files in that path?

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

Yes I did as mentioned here .

blogs.msdn.com/.../basic-sql-creating-extended-stored-procedure-xp-ndo-dll.aspx

I have created two extended stored procedures as mentioned

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

Actually my OS is 64 bit . Is it because of that

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

I directly restored the backup Demo database backup to sql 2008r2 but when i try to open it in classic it say

The database ' Test ' on server ' TestSQL ' can not be opened with this version of Microsoft Dynamics NAV Classic. The database has already been converted to a newer version of the program .

You must have Microsoft Dynamics NAV Classic upgrade to the latest version in order to open the database.

---------------------------

OK

----------------------

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

No, but did you try to use proper 64 bit xp_ndo.dll

Please re check again

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

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

---------------------------

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

I am getting this error message now

Microsoft Dynamics NAV Server ' due to the following error no connection between the change listener and SQL Server are prepared: Login failed for user ' NAVSQL \ LVE NAVKAT $'

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi NavTech,

Do you use Role Tailored Client? Do you assign ' NAVSQL \ LVE NAVKAT $ ' as account to start Microsoft Dynamics NAV Server?

Was this reply helpful? Yes No