Navision 4.0 SP3 not working in Vista

KillerPM

So there is nothing I can do to get this working? We are going to buy Vista PC's in less then 3 weeks. Vista is here, I wish Navision would catch up.

kine

KillerPM wrote:

So there is nothing I can do to get this working? We are going to buy Vista PC's in less then 3 weeks. Vista is here, I wish Navision would catch up.

No, you cannot do anything with it. You can install XP now (downgrade) and after the SP (or some update) will be released, you can install Vista. Or you can use Terminal server... :?

Waldo

Or Virtual PC 2007 Beta

ara3n

or use RDP or citrix till navision releases the update.

princess

I've read all of the above, but i still have a question: Is there an update for the MDAC Version problem when using Vista with NAV 4.0 SP2 SQL Server Option?

One of our customers who works with NAV for less then 3 weeks, has switched from Windows XP to Vista and has this problem. It is quite urgent.

If anyone can give me the answer to this question, i would be eternally greatfull.

Waldo

This is a snippet of something someone once sent to me...

MBS Navision with MS SQL Option and Vista™
Because I am testing Microsoft Vista™ RC1 and I was curious to see Navision on Vista™, I tried to install it. Installation is not a problem. Native client is working without problems too. But biggest problem is a so small part of Navision as MDAC version detection is. This is biggest problem when you want connect Navision to some MS SQL server. You will got error about wrong MDAC version. Source of problem is the unified versioning of all DLL which are part of the Vista™. Navision is detecting MDAC version through File version of SQL ODBC driver – sqlsrv32.dll. On Windows XP you can see version like 2000.85.1117.0 etc. But under Vista™, the file has version 6.0.5600.16384 and this is “less" than requested version. Changing MDAC detection in Navision is no way.
But after some “hacking” you can succeed. There is the workaround:
Prepare the modified DLL:
1. You need some resource editor tool, for example the Resource Hacker application
2. Copy the file sqlsrv32.dll from your Vista system32 folder to another place.
3. Open this copy in the resource editor
4. Change FILEVERSION value to new value e.g. 2000.85.1117.0 (in the header of Version info ressource)
5. Compile the resource
6. Save the file (backup original file!)
Now you need to copy the file back into system32 folder. But under Vista™, this is not easy task. The file cannot be changed because just installer has enough rights.
Replacing original file with modified one:
1. Open properties of the original file
2. On the Security tab click Advanced
3. On the Owner tab click Edit
4. Select new owner of the file, for example your account
5. Commit all changes
6. Change permissions for your account to have all rights
7. Commit all changes
8. Now you are able to delete the file – delete it
9. Copy the modified file into system32 folder
Now, you are ready to use Navision with SQL Option under Vista™!
I hope, that this will help you to be able to test Vista™ when you are working with Navision.
I tested it on Vista™ RC1 and Navision 4.00SP2+rollup update.
Of course, all this you are doing on your own risk. This is not official workaround and is not supported in any way. Changing original files in any way can be prohibited with local law or license policy.

This should solve your problem ...
(it did in my case).

princess

Thanks for the quick response.

It isn't quite the most 'safe' solution, but i'll give it a shot.

I'll keep you posted

kine

This is one from my articles on my Blog... :-)

Original: http://msmvps.com/blogs/kine/archive/20 ... a-RC1.aspx

But this is just solving the MDAC detection problem within NAV 4.00SP2 + update 1 SQL Option. Other versions are not working (SP3, SP2 update3, SP1 etc.) and there is no solution for them.

Waldo

kine wrote:

This is one from my articles on my Blog... :-)

manfredrusek

Waldo wrote:

kine wrote:

This is one from my articles on my Blog... :-)

Hi,
last information fromtody. SP3 for Vista is announced with Ferbruary 16th.

Bye

Waldo

manfredrusek wrote:

Waldo wrote:

kine wrote:

This is one from my articles on my Blog... :-)

Hi,
last information fromtody. SP3 for Vista is announced with Ferbruary 16th.

Bye

\:D/
You got a URL?
Where can we find more info?

manfredrusek

Waldo wrote:

manfredrusek wrote:

Waldo wrote:

kine wrote:

This is one from my articles on my Blog... :-)

Hi,
last information fromtody. SP3 for Vista is announced with Ferbruary 16th.

Bye

\:D/
You got a URL?
Where can we find more info?

No, it's an information from the partner net (escalation services)

Waldo

Hm, not really official then ... anyway ... let's hope so.

ara3n

http://msmvps.com/blogs/kine/default.aspx

mjrogers

URL is here: https://mbs.microsoft.com/partnersource ... staCompatb

Phenno

ara3n wrote:

http://msmvps.com/blogs/kine/default.aspx

Hm... I just read a part about not releasing 5.0 for Grp2/3 countries. ](*,)

ara3n

Yeah this news sucks. they should give a reason for their decision.

anil_mujagic

kine wrote:

This is one from my articles on my Blog... :-)

Original: http://msmvps.com/blogs/kine/archive/20 ... a-RC1.aspx

But this is just solving the MDAC detection problem within NAV 4.00SP2 + update 1 SQL Option. Other versions are not working (SP3, SP2 update3, SP1 etc.) and there is no solution for them.

But what will be with other apps that are using MDAC? Will they then report a wrong version number?

hedegaard

I believe I had similar problem when installing NAV5.0W1. When I then tried a Local client I got that same error. I fixed the problem installing the NAV5.0DK version. After installing the Local version my "old" Navision client worked again.

Have you installed the NL version on your machine? I mean using the installation and not copy.

hrillo666

Actually, my boss still has the same problem with 4.0 SP3, the supposedly Vista compliant version.

Is there a workaround for this?

Waldo

So you can't run 4.0SP3 after installing the platform files???

Louis

Hello,
What is today's status of V4SP3 BE (Belgium) on Vista OS ?
Somebody at work with these components ?
TIA,
L #-o

Waldo

I run 4.0SP3 on my Vista Enterprise without any problems. Also 5 of my colleagues do so.
You have to install the platform files, and all should work fine.

Louis

What is in the name of the platform files ?

FRA ? NLB ? BE ? W1 ?

TIA

Louis

Platform Roll-up Microsoft Dynamics NAV FR 4.0 SP3 (KB931841).exe

Waldo

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYLSVQUSPTNTNSMQPYLPMTZVVOMOMMVUNNMKSRNMLPQZMRXRPX

... if I remember correctly

guidorobben

Is there another location to download the rollup?. Now you have to contact MS for a request.