Published by

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: Session table overflow error when starting Navision

Solution: do not use Per database option for license file. This "Per database" functionality start this session check. If you disable Per database license in DB settings, all works correctly.

Sunday, July 23, 2006 11:54 PM 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

# Microsoft Dynamics NAV 4.x and Windows Vista

Microsoft Dynamics NAV 4.x and Windows Vista

Wednesday, September 27, 2006 4:28 AM by STEFANO DEMILIANI

# re: NAV 4.00 SP2 - not suitable for MS SQL 2005

Kine,

Has the issue of SP2 on SQL 2005 been resolved yet?

Martin

Tuesday, November 28, 2006 1:13 PM by Martin Kolar

# re: NAV 4.00 SP2 - not suitable for MS SQL 2005

Yes, as you can see in the article http://msmvps.com/blogs/kine/archive/2006/05/17/100361.aspx the main problem was solved in Rollup 1 for SP2, and of course by SP3. But there are still some issues with Max Size of DB files. But this can be solved by entering correct values. Since Rollup 1 for SP2, you can use the 4.00 with MS SQL 2005 without problems.

Wednesday, November 29, 2006 12:34 AM by kine

# re: Navision Employee portal and reports with local characters

You talk about reports in Nav Employee Portal, but how do you show reports in EP ? There's no such thing as a Report Web Part ? I found some info on how you could run a report via a link action, but then you're limited to only a few reports and is you want more, then you need to change some codeunit. What's the easiest way to show any report that exists in my Navision DB onto my Employee Portal ?

Tuesday, December 05, 2006 7:01 AM by someone

# re: Navision Employee portal and reports with local characters

1) I used the standard one, which is on the Sales order part.

2) You can use all reports, but yes, just some are supported by default. There is no way how to do that in generally. NAV needs to know, on which table is the report based to be able to call it with correct record variable. This is part of codeunit 6828, where you need to tell NAV that report xy is based on Item table, xz on SalesHeader table etc. If you need another table based report. But this is just easy modification by copy&paste and modify for your base table...

Tuesday, December 05, 2006 7:13 AM by kine

# re: SP2 Critical update 3 and Windows Vista™

I installed Vista and 40SP3. The stx file issue is still present.

Saturday, December 09, 2006 8:13 PM by Tom

# re: Convergence 2006 EMEA Presentation of NAV 5.0 for download

Are there any 5.0 screenshots available ?

Friday, December 29, 2006 3:48 AM by H D Bolak

# re: MBS Navision with MS SQL Option and Vista™ RC1

Brilliant!!!!!!!!!!!!!!!!!

Wednesday, January 03, 2007 9:55 AM by Bruno Santos

# re: MBS Navision with MS SQL Option and Vista™ RC1

Really works great!!!

Thank you!

Thursday, January 04, 2007 10:53 AM by Alexism

# re: NAV 5.0 Preview - Part 0

I would be very grateful if you give some view about options of talking to navision from applications written in visual studio... i'm interested in any interfaces (web services?) navision provide...

Thanks...

Friday, January 12, 2007 4:40 AM by VP

# re: NAV 5.0 Preview - Part 0

There is no change in this area between NAV 5.0 and previous versions. These new possibilities will be in the version 5.1, but this is not available yet. In version 5.0 you have still old C/Side client with dataports and XMLPorts and possibility to create some interface through Navision Application Server. For more info about "How to create Webservice for NAS" you can search the mibuso forum. Microsoft has one document, where is described step by step creating webservice for NAS in VS for interaction between MS Word and Nav.

Friday, January 12, 2007 5:11 AM by kine

# re: The description for Event ID ( nnnnn ) in Source ( XXXXX ) cannot be found

i will never understand, why people that are making application setups avoid to enter these values into registry on setup. there's bunch of applications that aren't use event manager properly.

Friday, January 12, 2007 6:24 AM by phenno

# re: NAV 5.0 Preview - Part 1 - The C/AL

Holly cow, we can indent blocks of code at once - how novel!! :>

Friday, January 12, 2007 1:58 PM by Mike

# re: The description for Event ID ( nnnnn ) in Source ( XXXXX ) cannot be found

Just wanted to add, how to use th fix. Basically

copy and pasted everything to text file.

including  Windows Registry Editor Version 5.00

then change the Server Name remove the < >

then change the file extension to .reg

then copy it to the computer where NAS is installed and double click on it. It will ask to register it, choose yes.

Friday, January 12, 2007 5:59 PM by ara3n

# re: NAV 5.0 Preview - Part 2 - Links

I always knew you were ahead of us, but one year is a bit too much, don't you thing ;°) . (I know, the workdate in the demo-company is set to 2008 :) ).

The "link" notation in the status bar is not clear enough, in my opinion.  AFAIK there is nothing like "Rec.LINKEXIST" in C/AL.  Also, the Record ID is something like: "Sales Header: Invoice,103004" or "Customer: 10000".  

It IS possible to create something more visible as the statusbar, but a bit "omslachtig" like they say in dutch (and don't know in English ;°).

Monday, January 15, 2007 4:07 AM by waldo (Eric Wauters)

# re: NAV 5.0 Preview - Part 2 - Links

Sorry, I didn't read your previous post well enough.  There IS a command rec.HASLINK ... :oops: .  

So, to make it more visible, you can create something similar like comment-button-bitmap.

Monday, January 15, 2007 4:13 AM by waldo (Eric Wauters)

# re: NAV 5.0 Preview - Part 2 - Links

May be some other remarks:

-  From Object Designer, you can't add record links ... would be nice for development.  Even when you create your own form, you can't add a record link on Object-records.

- You could be adding fields to the table "Record Link", but you can't add it to the default form.  Would be great to be able to easily extend its functionality.

Monday, January 15, 2007 4:28 AM by waldo (Eric Wauters)

# re: NAV 5.0 Preview - Part 2 - Links

Hmm I didn't notice that. For sure it would be nice to just do it from the Designer.

Monday, January 15, 2007 4:55 AM by David Singleton

# re: NAV 5.0 Preview - Part 2 - Links

Last remark (next time, I will try to put them together in one post ... sorry):

- Security settings: There is nothing to find in the "system"-permissions about "links".  You can control it per form (property: Form.LinksAllowed), but it seems you can't control it in the default security system (yet).

Monday, January 15, 2007 4:55 AM by waldo (Eric Wauters)

# re: NAV 5.0 Preview - Part 2 - Links

I agree, we can try to "push" it into some future version...

Monday, January 15, 2007 4:55 AM by kine

# re: NAV 5.0 Preview - Part 2 - Links

And about the security - you can do it on the virtual table... but not just for some "parent" tables... but may be when you will use Security filter... ;-)

Monday, January 15, 2007 4:58 AM by kine

# re: NAV 5.0 Preview - Part 2 - Links

I wouldn't know how to push it, but I know you can ;°).

For documentation in development, if you combine the new fields in record links table, and the possibility to put them on all objects (as many as you want) ... man, I can think of some nice features ...:

- Links to original analysis;

- Documentation of versionlist, with link to NAV system with the jobs and sub jobs

- Extra code on table to generate the link to NAV

- Extra documentation fields like "developer","analyst",...

- ...

Yes, if you want ... try to push it :D

Tuesday, January 16, 2007 2:07 AM by waldo (Eric Wauters)

# re: NAV 5.0 Preview - Part 1 - The C/AL

Can I use .net assemblies without implementing old com overhead (Guids, EventInterfaces ...)

Tuesday, January 16, 2007 3:26 AM by chris

# re: NAV 5.0 Preview - Part 1 - The C/AL

I am not assuming such a big change in Automation interface. In Automation server virtual table I can see same automations as in older versions, it means nothing more is accessible than before. I didn't tried to create my own library and use it, I am giving just 20% possibility of this change...

Tuesday, January 16, 2007 4:36 AM by kine

# re: NAV 5.0 Preview - Part 1 - The C/AL

As longs as Navision is written in unmanaged Code we'll have do define COM-Interfaces with all the Interfaces, Registry-Entries, etc.

I'm wondering if we'll be able to hack some .net controls into the new 5.1 client by using the good old winapi - functions.

Wednesday, January 17, 2007 4:10 AM by wakestar

# re: NAV 5.0 Preview - Part 2 - Links

I guess the problems with the Object Designer, is that the underlying table is not DataPerCompany.

Is it possible to add links for table 78 or 377? Or other systemtables like 2000000002 or 2000000006?

Wednesday, January 17, 2007 7:51 AM by Peter

# re: NAV 5.0 Preview - Part 3 - Export to external application

I don't get it :-(

How is this supposed to be used in any users daily work?

Wednesday, January 17, 2007 8:03 AM by Peter

# re: NAV 5.0 Preview - Part 2 - Links

It seems that you are right. I am unable to add links to any table which is DataPerCompany=No. We can hope that it will change till release version... :-/

Wednesday, January 17, 2007 8:04 AM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

1) You do not need to create report or something like that when you want to export some data into Excel

2) You do not need to use merge to insert data into Word

3) You do not need to use atuomations to work with Word and Excel

4) You (I mean partner) "just" need to create correct XSLT for anything the customer want to create in any application able to open XML file.

5)it means that you do not need any change in C/AL code to do the export, you can use whole set of attributes and properties of the aplication etc.

Many customers requests possibility to export this and this into excel, possibility to create Letter for customer on click...

Wednesday, January 17, 2007 8:15 AM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

Ad1)

To export a tabular form? Currently you will get the same result with copy’n paste.

To export a card form? I think I’ll still prefer to use zoom and then use copy’n paste. I would rarely have fields in Excel with NAV columns and layout.

Ad2)

To get any decent Word document you will need a dedicated stylesheet for the form.

Ad3)

Agree, but isn’t Office Automation easier than working with stylesheets in Notepad? ;-)

Ad4)

Until there is some great mapping tool (like BizTalk) I still think C/AL is easier.

Ad5)

Don’t quite understand. Example?

Yes, but without a GUI tool I don’t see how it will be any easier.

Wednesday, January 17, 2007 8:49 AM by Peter

# re: NAV 5.0 Preview - Part 2 - Links

Not unless you and others "Push" for it :-)

Once it is released it will be rather difficult to change. So it is NOW to request it changed.

They just need to make the "Record Link" with DataPerCompany=No and add a new field called Company. Then it should be quite easy to fix now, before release.

Wednesday, January 17, 2007 8:56 AM by Peter

# re: NAV 5.0 Preview - Part 3 - Export to external application

ad 1) Tabular form, but with some aditional data. Of course that Copy&Paste is the quickest way.

Export of all data on card form can be useful for example for reporting some issue to developer. You just click to export the form into excel, attach the excel to mail, describe the action and it is done. You do not need to take screenshots of the form to report the values you used etc.

ad 2) Yes, you need to create stylesheet for the form, from which you want to have it accessible.

ad 3) Not in case when the code is running on service tier and it means that the automation is used on the server (with service tier) and not on user PC. Another thing is using applications which have no automation interface (for example you can use it to create document for OpenOffice ;-))

ad 4) I fully agree, this is a big pain and I am waiting for some good application to be able to create the XSLT in some visual way

ad 5) With automation you are limited with the automation interface. With XSLT sheet you can generate any attribute which exists in the target XML schema. It means that you can generate (create) anything what can be saved in the XML. I know that most of the things there is automation function to set it, but may be that for someone and somewhen will be much easier to change the XSLT than change the C/AL code.

My opinion is that this functionality is there to have same possibility to export data as in SAP B1. And yes, without good tool it is too hard to use it. With good tool, it will be good feature. And it is good for salesmans for the wow effect when they show this to new customer... :-)

(PS: your post was not publiced immediately because it scores in SPAM filter)

Wednesday, January 17, 2007 9:18 AM by kine

# re: NAV 5.0 Preview - Part 2 - Links

hm,

I can't find any reason why it's not enabled... .  Did anyone test if on custom tables it's the same?

Wednesday, January 17, 2007 9:27 AM by waldo (Eric Wauters)

# re: NAV 5.0 Preview - Part 2 - Links

I tested it on custom table and it IS working! My mistake in previous test was that I tried it on empty table (record was not inserted yet...) how stupid mistake... :-(

But still you need to have some common form to be opened (form which you are able to design) and it is not working on some system tables (I create new form for Object table and it didn't work).

Wednesday, January 17, 2007 9:47 AM by kine

# re: NAV 5.0 Preview - Part 2 - Links

Great, but I doubt they can be viewed from all companies. Or?

Wednesday, January 17, 2007 9:55 AM by Peter

# re: NAV 5.0 Preview - Part 3 - Export to external application

Spam filter? Really? How embarrassing :-(

Ad 1) Ok - so without customized stylesheets it is mainly for troubleshooting.

Ad 3) Ohhh s**t! Haven’t thought of that! So you are saying that with the new 3-tier client will any automation code use the automation on the server and not on the client? Can’t quite figure out all consequence of that, but it will surely surprise quite a few. :-) Wonder how files are handled in the 3-tier client. Will paths be based on the server or client? I guess the new functions to up- and download indicates it will be based on the server.

Ad 5) I have created a lot of different xml-files from NAV, so it will take quite some time before it will be easier to make a stylesheet :-)

Great work you are doing – really looking forward to get the new version myself.

Wednesday, January 17, 2007 9:56 AM by Peter

# re: NAV 5.0 Preview - Part 2 - Links

OK ... I was just testing myself :°/.

Same result:

- first create a form .. then you can use record links.

- DataPerCompany = No --> Record links are still working

So I guess the DataperCompany isn't the trigger ...

Even, on form 358, the LinksAllowed property is on default <yes>.

Wednesday, January 17, 2007 9:57 AM by waldo (Eric Wauters)

# re: NAV 5.0 Preview - Part 3 - Export to external application

ad 3) I am not sure but I hope that there will be somepossibility to set where the atuomation will be running. But I have no informations about that right now. About the files - In my opinion if you use just Create or Open, the path will be local. When you will need to transfer the file to client PC, you will need to use UPLOAD or DOWNLOAD.

Wednesday, January 17, 2007 11:41 PM by kine

# re: NAV 5.0 just for Group 1 countries?

We're Group 2 ... This is outragous.

Where did you get this info?

Friday, January 26, 2007 5:12 AM by waldo (Eric Wauters)

# re: NAV 5.0 just for Group 1 countries?

Just one more proof what MS is rotten and full of morons...

MS just dreaming about NAV death. They can't understand this product.

Friday, January 26, 2007 5:24 AM by BlackTiger

# re: NAV 5.0 just for Group 1 countries?

This info is from our local MS newsletter for MBS Partners. I heard about that in November (but I thought that it is just about Czech localization). After my question and month of waiting I got the answer that it was published in the newsletter. After that I found that such a newsletter exists (it was first time I heard about it).

Friday, January 26, 2007 6:38 AM by kine

# re: NAV 5.0 just for Group 1 countries?

This sucks. We have a client that companies in GR2 and GR1. This means they can't upgrade to 5.0

Friday, January 26, 2007 6:46 AM by ara3n

# re: NAV 5.0 just for Group 1 countries?

Yes, same problems here... I sent feedback about that, but I think that just my voice will be like spitting into sea... and it is too late to change something like that...

Friday, January 26, 2007 6:57 AM by kine

# re: NAV 5.0 just for Group 1 countries?

We are mainly working for Belgian customers: Group 2.

I've been involved with the beta program from March 2006.  It has cost me much time and money to participate.  En of february, I'll go to Denmark for a week to join the trainings

...

and for what?  To be able to upgrade in only one year????

Saturday, January 27, 2007 6:33 AM by waldo (Eric Wauters)

# re: NAV 5.0 just for Group 1 countries?

Ooffffffff...  I'm releaved...

Have you got an official link to partnersource?

Sunday, January 28, 2007 3:19 AM by waldo (Eric Wauters)

# re: NAV 5.0 just for Group 1 countries?

I think Kine got the list from this page:

https://mbs.microsoft.com/partnersource/downloads/releases/microsoftdynamicsnav50.htm?printpage=false

All NAV 5 material is claimed to be announced here once they become available:

https://mbs.microsoft.com/partnersource/products/navision/50.htm?printpage=false

Sunday, January 28, 2007 6:22 AM by Peter

# re: NAV 5.0 just for Group 1 countries?

Thanks Peter, it is exactly what I have used.

Sunday, January 28, 2007 9:28 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

Hi.

I have a problem. I am the first at my company installing Vista and we have Navision 3.70

Instalation went fine, but I am not being able even to open up the program. It says that it stopped working and windows will close the program.

Can anyone help me, please?

Tuesday, January 30, 2007 3:19 PM by Nelson

# re: MBS Navision with MS SQL Option and Vista™ RC1

Sorry, but I have bad news for you. Navision 3.70 is not compatible with Vista, and because the support for it has ended, I assume that there will be no compatibility patch for it. You will need to do technical upgrade to newver version. But there is no released version fully compatible with Vista now.

Tuesday, January 30, 2007 11:24 PM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

Hmmmm,

I can't run (never mind design) codeunit 403 with my normal licence, and the Cronus licence tells me I have unknown OLE objects.

Total pain in the ***.

Wednesday, January 31, 2007 7:32 AM by MTC

# re: NAV 5.0 Preview - Part 3 - Export to external application

Yes, because you need fresh license file. This codeunit is new and you have no permissions in your pre 5.0 license. You need to use the Cronus (Contoso) license file for that.

I do not understand the "nd the Cronus licence tells me I have unknown OLE objects.". When? Exact text? I have no problems with that. Are you trying on VPC or you downloaded the install files and installed it from there?

Wednesday, January 31, 2007 7:37 AM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

I downloaded the install files, not the VPC.

When I click on the Word icon for example, Navision says something like:

This message is for C/AL programmers:

Could not create an instance of the OLE control or Automation server identified by GUID={F5078F18-C551-11D3-89B9-0000F81FE221} 6.0:{88D96A05-F192-11D4-A65F-0040963251E5}:Unknown Automation Server.Unknown Class. Check that the OLE control or Automation server is correctly installed and registered.

Well, I would, but don't have a clue which one it is.

Do I need Office 2007 to get this working?

Wednesday, January 31, 2007 7:47 AM by MTC

# re: NAV 5.0 Preview - Part 3 - Export to external application

What I see in my registry for this GUID, is that it is part of MSXML 6.0. You need to install this component. see http://www.microsoft.com/downloads/details.aspx?familyid=993c0bcf-3bcf-4009-be21-27e85e1857b1&displaylang=en

Wednesday, January 31, 2007 8:08 AM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

Thanks for that, it's working now.

Wednesday, January 31, 2007 8:55 AM by MTC

# re: Microsoft Dynamics NAV 5.0 Beta available for download

Seems as if they give you the password for the NAV but not the VPC winXP logon!

Wednesday, January 31, 2007 10:24 PM by mike

# re: Microsoft Dynamics NAV 5.0 Beta available for download

Why? the password is correct for the WinXP login (or was in my VPC I got two weeks ago). You just needs to know that there is English keyboard used when entering the password (mainly the @ char)

Thursday, February 01, 2007 12:34 AM by kine

# re: Microsoft Dynamics NAV 5.0 Beta available for download

I'm also unable to login. I have tried with both Danish and US-English keyboard, but still no luck.

The vhd-file is dated 25-01-7, so I doubt it is the same you got 2 weeks ago :-)

Thursday, February 01, 2007 2:28 AM by Peter

# re: Microsoft Dynamics NAV 5.0 Beta available for download

I tried the install files under vista, and all works perfectly!

Thursday, February 01, 2007 3:00 AM by waldo (Eric Wauters)

# re: Microsoft Dynamics NAV 5.0 Beta available for download

Peter: In my VPC the password was "pass@word1". May be they forgot to include the "1" at the end on the webpage...

Thursday, February 01, 2007 3:07 AM by kine

# re: Microsoft Dynamics NAV 5.0 Beta available for download

Hi,

I need advice on one issue i have encountered in Navision. I created a Sales Order. I want to convert this to Sales Invoice but don't want to Ship. In Posting -> POST, We have three options, Ship, Invoice, Ship and Invoice. I want to use only Invoice Option as want to ship later.

When I select Invoice option, Gives message -> Nothing to post and the process doesn't move to next step.

Can't I follow Invoice and then Shipping in Navision.

Kindly reply if anybody has some solution on this. It would be a great help.

Thanks.

Thursday, February 01, 2007 5:02 AM by anil

# re: Microsoft Dynamics NAV 5.0 Beta available for download

1) You asked this question on mibuso, didn't you? The forum is correct place to ask these question.

2) There is no standard way to do that. In Navision you cannot do Invoice before you ship the items. There is just possibility of Advance Invoice (part of standard in NAV 5.0, in older versions there are addons for that).

Thursday, February 01, 2007 5:26 AM by kine

# re: NAV 5.0 Preview - Part 1 - The C/AL

The thing I don't get is why they have not even mentioned most of those functions in the training materials available so far. At the moment they only say that they have added 4 functions:

• GETLASTERRORTEXT

• CLEARLASTERRORTEXT

• APPLICATIONPATH

• TEMPORARYPATH

Microsoft at times is quite clearly barmy.

Wednesday, February 07, 2007 7:45 AM by MTC

# re: NAV 5.0 Preview - Part 3 - Export to external application

I did a google search on user friendly style sheets. There is a company called Altova - with a web site by the same name - that offers a product called Stylevision that claims to provide this. It has a 30 day free evaluation. I don't have time to check it out myself, but it might be worth checking out to see if it will help with Navision.

Wednesday, February 21, 2007 10:19 AM by Dave Machanick

# re: NAV 5.0 Preview - Part 3 - Export to external application

I tried it, but it is just good editor for the stylesheet, but you need to do everything manually. I can imagine some editor, where I can see the source, the stylesheet and the resulting document...

Wednesday, February 21, 2007 10:26 AM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

Same here... Existing Stylesheets work, and also I get out the way for replacing the standard-cronus logo with another one. But I don't know how to finish larger changes in exisiting Stylesheets. Not at all I can imagine how to create an absolute new stylesheet for a diffrent issue.

A graphical xslt-editor is needed =/

Friday, March 02, 2007 5:04 AM by Lighty

# re: MBS Navision with MS SQL Option and Vista™ RC1

I have a problem with MDAC 6.0 for Vista.  Actually, I was unaware that Vista came with a version of MDAC and "overwrote" it with MDAC 2.8, 2.8 sp1, and a security patch.  I'm not even sure any of these installed correctly either.  My problem is - how do I remove these three foolish MDAC updates that I made to Vista?  I've tried using the component checker and I'm confused...please help.

Jeff

Saturday, March 03, 2007 2:19 PM by Jeff

# re: MBS Navision with MS SQL Option and Vista™ RC1

I am surprised that it was possible to install this version of MDAC under Vista. If the MDAC is not available for uninstall in Add and Remove Software control panel, you can try to use restore to some saved Checkpoint - see Start Menu - Maintenance - Backup and Maintenance - Repair Windows... (on the left panel)  I do not know exact names, I have localized Vista and I dont know the english names...

Sunday, March 04, 2007 8:43 AM by kine

# re: NAV 5.0 just for Group 1 countries?

Hello,

Are you sure that this is opened information?

Thank you

Wednesday, March 07, 2007 4:44 AM by Andrey

# re: NAV 5.0 just for Group 1 countries?

If you mean if it is up-to-date than yes. The list of countries is still same on the NAV 5.0 release page. And if you mean if it is "public" information, than I mean yes (it is public for partners, and there is no any limitations for partners how they will use this information).

Wednesday, March 07, 2007 4:58 AM by kine

# re: NAV 5.0 Preview - Part 2 - Links

Hey boys,

have you noticed that the case "They just need to make the "Record Link" with DataPerCompany=No and add a new field called Company. Then it should be quite easy to fix now, before release." is solved in the released version of NAV 5.0? The table is DataPerCompany=No and there is new field "Company"..  :-)

Tuesday, April 03, 2007 3:51 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

Thanks!It was really help.

Friday, April 13, 2007 10:23 PM by Sang Nguen Thanh - NETiKA

# re: MBS Navision with MS SQL Option and Vista™ RC1

I have used in navision 4.0 sp2 in windows 2003 server.I upgrade one client machine in vista,if try to connect navision mdac error occured.What i do.

By

Mariyappan.J

Mail id :mariyappan@everonn.com

Thursday, April 19, 2007 6:37 AM by Mariyappan

# re: MBS Navision with MS SQL Option and Vista™ RC1

Dear Mariyappan,

best will be if you do technical upgrade to NAV 4.0SP3 with compatibility update for Vista. In this case you will not have any problem and you will not need to modify anything.

But if you want to use SP2, have you read this article? If yes, why are you asking "what to do"? :-)

Thursday, April 19, 2007 6:50 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

I don't have navision sp3 so that i ask

Thursday, April 19, 2007 11:32 PM by mariyappan

# re: MBS Navision with MS SQL Option and Vista™ RC1

Download the SP3 is not problem, or it is?

If you are unable to use SP3 (but I do not know why), all what you need is in this article. If you do not understand something particular, ask question, but be more precise what is the problem and what you do not understand. ;-)

Friday, April 20, 2007 1:11 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

Thank you for your hope.

The Error Message is:

The Sql server ODBC driver on your computer is not a recent enough version.

Before the driver can be used by Microsoft Business you must upgrade it,along with the network libraries and supporting files, to version 2000.85.1022 or late.

This can be done by installing the latest version of Microsoft soluations-Navision,choosing the MDAC Component of a Custom installation.

You can also upgrade it by installing the sql server client tools or the microsoft MADC Component.

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

I also update MDAC Componet in vista client Machine.Same error message display.

Friday, April 20, 2007 1:42 AM by mariyappan

# re: MBS Navision with MS SQL Option and Vista™ RC1

The above Error message display in navision 4.0 sp2.I use only above version only give soluation

Friday, April 20, 2007 1:45 AM by mariyappan

# re: MBS Navision with MS SQL Option and Vista™ RC1

Once again: have you read my article? The article describe what you need to do to not have this version error under Vista. There is no other solution than the one described here. Do you understand this? You need to change the version of sqlsrv.dll manually.

Friday, April 20, 2007 1:49 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

It seems that I do not understand your sentence "I use only above version only give soluation". What does it mean? That you are using NAV 4.0SP3?

Friday, April 20, 2007 2:02 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

1 VERSIONINFO

FILEVERSION 2000,85,1117,0

PRODUCTVERSION 3,85,1117,0

FILEOS 0x40004

FILETYPE 0x2

{

BLOCK "StringFileInfo"

{

BLOCK "040904B0"

{

VALUE "CompanyName", "Microsoft Corporation"

VALUE "FileDescription", "Microsoft SQL Server ODBC Driver"

VALUE "FileVersion", "2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)"

VALUE "InternalName", "SQLSRV32"

VALUE "LegalCopyright", "Copyright © Microsoft Corporation 1990-2000"

VALUE "OriginalFilename", "SQLSRV32"

VALUE "ProductName", "Microsoft SQL Server"

VALUE "ProductVersion", "3.85.1117"

}

}

BLOCK "VarFileInfo"

{

VALUE "Translation", 0x0409 0x04B0

}

}

I try to open in vista system32 file through resource header the above message is display .how to change file virsion.I think file version is correct

Friday, April 20, 2007 4:53 AM by mariyappan

# re: MBS Navision with MS SQL Option and Vista™ RC1

Sorry but your previous posts scored in automatic SPAM filter, I needed to publish them manually.

1) there is no MDAC update for Vista. If you sucessfully installed one, something can be wrong now because this update. I recommend to not install such a update.

2) The version of your file seems correct. The problem will be somewhere else (may be because the "update". I tied it before too and I know that there were other problems when I installed MDAC for win XP under Vista.)

Sunday, April 22, 2007 11:16 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

Great, it works.

Thursday, May 10, 2007 8:59 AM by Thuan Ta - Vietnam

# re: NAV 5.0 Preview - Part 3 - Export to external application

It's great to see you blogging on NAV 5.0 and the new features. I've not seen any posts for a while but you have been an inspiration for me to try and write about my experiences with Dynamics NAV 5.0.

I was looking at the click-through demo for Dynamics NAV 5.1 (the new role-based user interface) and I was intrigued to see that the generation of a order confirmation looked to be using the same XSLT transformation into a word document as we have seen in NAV 5.0. I have no idea if there is going to be a tool to help you produce this, but I seriously doubt it. I am going to try and cover how to create an XSLT from scratch using Word and some knowledge of WordML on my Blog gaspodethewonderdog.blogspot.com. Hopefully I'll get some more time to play around with this but in the meantime - keep up the good work!

Wednesday, May 23, 2007 5:57 AM by Gaspode The Wonderdog

# re: MBS Navision with MS SQL Option and Vista™ RC1

you are genius, it really solved my problem, thank you very much

Monday, June 11, 2007 8:05 PM by Mah

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Wednesday, June 13, 2007 9:37 PM by Stylianos

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Friday, June 15, 2007 7:22 AM by Aiolos

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Friday, June 15, 2007 8:30 AM by Iakovos

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Saturday, June 16, 2007 5:53 AM by Romanos

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Monday, June 18, 2007 12:40 AM by Constandinos

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Tuesday, June 19, 2007 5:55 AM by Socrates

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Tuesday, June 19, 2007 3:35 PM by Nathanael

# re: NAV 5.0 Preview - Part 3 - Export to external application

Thank you for the helpful article about this new functionality in Nav 5.0. It is quite helpful to get in this stuff.

Can you tell me how did you get the Data XML on your screenshot (the picture before "Result of this transformation can look like this"). I didn't find a possibility to get a look at the xml data before it is transformed by the stylesheet. Thanks in Advance.

Tuesday, June 19, 2007 4:19 PM by Olli

# re: NAV 5.0 Preview - Part 3 - Export to external application

If you look into CU1, function LaunchApp, both XML are passed as parameters. I just added code which saves this XML into file... ;-)

Tuesday, June 19, 2007 11:12 PM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

That is the trick :-). Thank You for the quick response.

Wednesday, June 20, 2007 12:12 AM by Olli

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Wednesday, June 20, 2007 10:08 AM by Christos

# re: MBS Navision with MS SQL Option and Vista™ RC1

yo~~~thanks..it's work

Wednesday, June 20, 2007 7:40 PM by Chris Gan

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Saturday, June 23, 2007 8:09 PM by Andros

# re: MBS Navision with MS SQL Option and Vista™ RC1

really works!!! yer really saved me some big bucks there mate. cheers!

Friday, June 29, 2007 4:39 AM by vid

# re: MBS Navision with MS SQL Option and Vista™ RC1

Thank You very much, this was very helpfull.

Tuesday, July 03, 2007 5:01 AM by Tom

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Sunday, July 15, 2007 6:22 AM by Agias

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Sunday, July 15, 2007 5:11 PM by Kyriacos

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Monday, July 16, 2007 4:52 AM by Constandinos

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Monday, July 16, 2007 10:55 AM by Charilaos

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Monday, July 16, 2007 3:53 PM by Ambrosios

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Tuesday, July 17, 2007 9:15 AM by Harrys

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Wednesday, July 18, 2007 3:52 AM by Achilles

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Wednesday, July 18, 2007 11:15 PM by Nicolas

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Thursday, July 19, 2007 8:45 AM by Constantine

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Sunday, July 22, 2007 9:09 PM by Michail

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Thursday, July 26, 2007 3:19 AM by Sotirios

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Saturday, July 28, 2007 8:36 AM by Aniketos

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Sunday, July 29, 2007 9:27 PM by Angelos

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Tuesday, July 31, 2007 3:30 PM by Adonis

# re: NAV 5.0 Preview - Part 2 - Links

interesting

Wednesday, August 01, 2007 8:08 AM by Rhigas

# re: NAV 5.0 Preview - Part 2 - Links

Interesting...

Wednesday, August 01, 2007 11:10 PM by Stratis

# re: MBS Navision with MS SQL Option and Vista™ RC1

I try install navision 4.0(sp3).I got unknown lanuage error.What i do

Thursday, August 02, 2007 4:12 AM by Mariyappan

# re: MBS Navision with MS SQL Option and Vista™ RC1

If you are partner, see mbs.microsoft.com/.../KBDisplay.aspx.

(KB 931841)

If you are customer, ask your partner for needed updates.

Tuesday, August 07, 2007 11:50 PM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

Please help , is Navison 4.0 compatible with windows Vista home premium OS. navision is insatalled successfully but when I try to open It throws error as 'Unknown Language 630302' pls help what to do  

Thursday, August 09, 2007 3:04 AM by Seema

# re: MBS Navision with MS SQL Option and Vista™ RC1

For all:

NAV 4.0 is compatible with Vista since SP3 + Compatibility Rollup Updates!!!

If you are partner, ask Microsoft for latest Vista rollup updates for you country version of NAV 4.00SP3. If you are customer, ask your partner...

More about Vista compatibility can be found on www.mibuso.com forum.

Thursday, August 09, 2007 3:54 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

I don't have such resource editor application, will you share your edited sqlsrv32.dll file to me?

Thanks.

-- stupidzt@yahoo.com --

Tuesday, August 28, 2007 10:38 PM by stupidzt

# re: MBS Navision with MS SQL Option and Vista™ RC1

You do not need it anymore, just upgrade to SP3 + updates. It is much better e.g. because the Standard security model which means that synchronizing permissions take just less than one second.

Wednesday, August 29, 2007 1:34 AM by kine

# re: MBS Navision with MS SQL Option and Vista™ RC1

Recently I was trying to install the Navision Database server in Windows Vista. (Navision 4.0. SP3) While installing the Navision Database Server I am getting an error and the installation gets cancelled.

The error message is given below for solutions.

"This program has known compatability issues".

Friday, September 07, 2007 10:49 AM by R.Srinivasan

# re: MBS Navision with MS SQL Option and Vista™ RC1

ok.  Thank you for your response.

Friday, September 07, 2007 10:50 AM by R.Srinivasan

# re: MBS Navision with MS SQL Option and Vista™ RC1

"This program has known compatability issues"

Yes, it has. You need to install the compatibility updates for SP3 to have these issues solved. If you are MS partner, contact MS, if you are end-user, contact your partner.

Monday, September 10, 2007 12:23 AM by kine

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Hi

...Because BEEP needs to talk with Operating system, it somehow "give" the control to OS..

But this purposes having a NAV function as YIELD.

Tuesday, September 25, 2007 2:31 AM by Yaroslav Gaponov

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Yes, but YIELD was there for old 16bit systems, not working now on 32bit. I tried it, but it is not working with it, with BEEP it is working... :-)

Tuesday, September 25, 2007 3:03 AM by kine

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Hi

I know about problem this function((((

Big thanks for idea - I changed a my tool for make a release's fob www.geocities.com/.../Release

Tuesday, September 25, 2007 3:44 AM by Yaroslav Gaponov

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

I am happy that it is working for you. And I used it for similar thing as you - Version Control for NAV (automatic txt export of objects for central repository)

Tuesday, September 25, 2007 7:31 AM by kine

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Hi

This thing need for create fob file for send to customer after upgrade objects from old version to new version. This list of objects create from VCC.

I'm core developer a Version Control (CVC) till first release)))

Tuesday, September 25, 2007 9:54 AM by Yaroslav Gaponov

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

...and CVC work only with txt - it's TRUE.. but customers waiting a fob only...

Tuesday, September 25, 2007 9:57 AM by Yaroslav Gaponov

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Sorry, this other CVC))))

Tuesday, September 25, 2007 10:02 AM by Yaroslav Gaponov

# re: Convergence 2006 EMEA Presentation of NAV 5.0 for download

i want to see that product

Wednesday, September 26, 2007 1:21 AM by febin

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Hi Kine

Be careful with the "SendKeys"...

The SendKeys class has been updated for the .NET Framework 3.0 to enable its use in applications that run on Windows Vista.

The SendKeys class is susceptible to timing issues, which some developers have had to work around. The updated implementation is still susceptible to timing issues, but is slightly faster and may require changes to the workarounds.

more here...

msdn2.microsoft.com/.../system.windows.forms.sendkeys.aspx

Wednesday, October 03, 2007 3:23 AM by wakestar

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Thanks for that info Wakestar. Good to know...

Wednesday, October 03, 2007 3:58 AM by kine

# re: Powerfull command in Microsoft Dynamics NAV: BEEP

Btw. I am using Vista and I have no problems. Same thing is working on Win XP without changes too...

Wednesday, October 03, 2007 4:01 AM by kine

# re: NAV 5.0 Preview - Part 3 - Export to external application

Hi Kine,

You would help me a lot if you could post your code to save the XML as you  mentionedin your comment om June 19, 2007 11:12.

I'm trying to figure this out but i'm stuck.

Thnkx.

Monday, October 08, 2007 7:20 AM by Blackbird

# re: NAV 5.0 Preview - Part 3 - Export to external application

and did you by any change have been working for a solution to create Worddocuments in batch?

I you have to create a new DataXml-xml to pass on to cdu 1, that's a lot of work.

Monday, October 08, 2007 7:41 AM by Blackbird

# re: MBS Navision with MS SQL Option and Vista™ RC1

Cheers bro, you saved what little hair I have left!

Monday, October 15, 2007 1:20 PM by Clayton

# re: MBS Navision with MS SQL Option and Vista™ RC1

I tried your above described steps with NAV 4.0 SP2 and Vista X64.

My problem is, after I copy the DLL back into the SYSTEM32 folder, the changed version info is reseted and replaced with the original value of the file.

All changes are discarded.

Any hint on this issue?

Wednesday, October 24, 2007 7:14 AM by M. Buescher

# re: MBS Navision with MS SQL Option and Vista™ RC1

The Vista (and XP) has mechanism which protect system files from change. You need to disable this. But today is better to do technical upgrade to NAV 4.00SP3 + updates and you do not need to change anything on your PC.

Wednesday, October 24, 2007 7:41 AM by Kine

# re: Official Microsoft Dynamics NAV Blog

Hello, very nice site, keep up good job!

Admin good, very good.

Monday, October 29, 2007 5:57 AM by Stasigr

# re: Official Microsoft Dynamics NAV Blog

Hello, very nice site, keep up good job!

Admin good, very good.

Sunday, November 04, 2007 9:33 AM by Stasigrii

# re: MBS Navision with MS SQL Option and Vista™ RC1

I have VISTA an NAVI SP3, I have change the version in dll file, its not working. I have an error internal error 47-1, can u help ?

Friday, November 09, 2007 9:24 AM by Bojan Varga

# re: MBS Navision with MS SQL Option and Vista™ RC1

This "workaround" is just for SP2. If you have SP3 ask your partner or if you are partner ask Microsoft for needed updates for SP3.

Friday, November 09, 2007 10:23 AM by kine

# re: Where to place my code?

Hi Kine, wow - it's been a few months since you posted - good to see you back.

I'm all for this idea of bringing order to the world of NAV. It would be nice to see the "Isn't codeunit better?" replaced with some decisions that would help us understand what makes a codeunit better.

Also these diagrams don't look too good on the web site and are a bit tricky to read - maybe you could save them with a bit higher resolution or in a different format?

The first diagram - it isn't immediately obvious where to start - it would be nice to have the first box always being something like "Where do I put my Code?"

It would be interesting to see what the Rookies think - I'll ask some new starters in my team to take a look and leave a comment.

Monday, July 28, 2008 4:13 PM by David Roys

# re: Where to place my code?

Great idea! I have raised this question with my mentor more than once in my short time as a NAV Developer.

Monday, July 28, 2008 4:28 PM by Michael

# re: Where to place my code?

Hello David,

I know that many things in the diagram are not clear or just "to be there", but take it as a first version. I am waiting for comments like yours to make it better.

You can download the Visio diagram from the link in the article. Images in the article are just examples. In the visio file there are other diagrams too(Reports, Forms...). On the google code site, there are the images in full quality (200DPI) if you need them...

Tuesday, July 29, 2008 12:10 AM by kine

# re: The Art Of Nav – NAV 2009 CTP4 stats

Hi Kamil, does that mean that the CTP4 is available for general download now or is this as a result of your MVP status?

It's interesting to see these stats - it would be even more to see what would happen if you excluded the tables that were introduced to provide the Cue FlowField Counts for the Activities pages in the Role Centres. This would give us some indication of the data changes in the standard functionality that may require special attention for an upgrade. It would also be interesting to know how you are making these statistics. Did you write a custom program or are you using some kind of tool?

Wednesday, September 24, 2008 8:02 PM by David Roys

# re: The Art Of Nav – NAV 2009 CTP4 stats

Hello David. CTP4 is available for partners from today (25.9.2008). Of course, these statistics were done on CTP4 I had access as MVP. Statistics are based on results of my NAV objects for extracting the relations under name "The Art of NAV - Big picture of NAV" and Excel pivot table. Nothing more, nothing less. As announced, there are no big changes in data structure of NAV 2009 when compared with NAV 5.0SP1. Only some small changes. But this will need deeper analysis.

Wednesday, September 24, 2008 11:30 PM by kine

# re: Microsoft Dynamics NAV 2009 - C/AL is colored!

This is just great, but please make someone fix the block commenting bug. Please. :-)

Thursday, September 25, 2008 8:36 AM by Peter

# re: Microsoft Dynamics NAV 2009 - C/AL is colored!

We will see if the bug will make it into final version or someone will "debug" it... ;-)

Thursday, September 25, 2008 8:48 AM by kine

# re: The Art of NAV –Dynamics NAV 2009 network Stats

These results are very interesting. Thanks a lot for your great work! :-)

I'm quite surprised about the problem with reports, but great to get the info. This also clarifies that the new client is not an alternative to a Citrix solution for low bandwidth locations. I guess a Citrix client will only transfer 1-5% of the other two clients.

Friday, October 10, 2008 1:26 PM by PDJ

# re: Functional Testing in NAV 2009 SP1

Hi,

I have recently downloaded this NAV2009 SP1, but could not find this Property of codeunit "Sub-type", can you please guide me on this?

Friday, September 04, 2009 10:27 AM by Dhan Raj Bansal

# re: Functional Testing in NAV 2009 SP1

Sorry to bother you, I found the answer, basically one needs to do the following to see the sub-type property:

Tools>> Options>>Show C/AL Testability properties

Friday, September 04, 2009 10:29 AM by Dhan Raj Bansal