New xp_ndo.dll solving problems

Hello all,

I have new info for you - new xp_ndo.dll for SP2 is solving problems with MS SQL 2005. After that update, it seems that all critical problems with SQL 2005 are solved and can be used by customers. There is just minor problem with transaction log max size, which is read in KB but set in MB (the column has MB in caption, but what Navision read from SQL is in KB, if you want to set the max size, you need to enter size in MB...).

I wish you luck in using MS SQL 2005 and many satisfied customers...
Published Tue, May 23 2006 11:46 by kine
Filed under:

Comments

# re: New xp_ndo.dll solving problems

Hi Kine,

what problems are solved with this fix?
We have many problems with locking, performance and - terrible - data-imports. If a non Admin-User starts an import, there are no data in the table after run. If an (sql)admin do this, the table is filled after run the import. It's impossible? No. :-)
With sql-server 2000 we had no problems with these things.

Greetings from germany
Joerg

Monday, June 12, 2006 9:44 AM by Joerg

# re: New xp_ndo.dll solving problems

1) This is solving technical issues like READPERMISSION command not working...
2) Sources of locking and performance problems are not optimized HW, indexes, bad C/AL code. Not Navision Client (Navision client can just optimize some parameters, but if HW, indexes or C/AL code is poor, Navision client will not be better if optimized...) - see Mibuso for optimalizating the Navision keys and code for better performance
3) Imports - if Dataport is runned from designer, the transaction is not commited. You need to run it directly or add Commit into OnPostDataItem. See Mibuso...
4) If you are able to reproduce the problem on MS SQL 2005 and not on MS SQL 2000 with same data and objects, create Service incident and send the detailed description to Microsoft, they will try to find solution for you or will inform you about actual progress on known issue...

Monday, June 12, 2006 10:07 AM by kine

# re: New xp_ndo.dll solving problems

Where are you getting the new XP_NDO.DLL?  I can't seem to find it.  The one I have is data January 12, 2006.  I am having the Alter Database Max Size issue.

Wednesday, June 28, 2006 1:45 PM by Todd Scott

# re: New xp_ndo.dll solving problems

I just know about XP_NDO.DLL which is part of the SP2 Install CD. The Alter Database issue is partially solved with SP2 with update 1 (see my previous articles), still there is problem with size units (KB vs. MB) - but this is not preventing you from setting correct size (but you need to change the size to correct units).

Thursday, June 29, 2006 12:52 AM by kine

# re: New xp_ndo.dll solving problems

A customer wants to replace the old xp_ndo.dll on SQL 2005 but says they can find it in 8 different folders. Where should we put it?

Friday, August 04, 2006 1:07 PM by Skeeve

# re: New xp_ndo.dll solving problems

If all folders are subfolders of MS SQL 2005 main folder, good will be delete all, and copy the new dll just into binn folder.

Friday, August 04, 2006 1:22 PM by kine