Navision 4.0 SP3 not working in Vista

KillerPM · 2007-01-19

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 · 2007-01-20

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 · 2007-01-21

Or Virtual PC 2007 Beta

ara3n · 2007-01-21

or use RDP or citrix till navision releases the update.

princess · 2007-01-22

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 · 2007-01-22

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 · 2007-01-22

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 · 2007-01-22

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 · 2007-01-22

kine wrote:

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

manfredrusek · 2007-01-25

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 · 2007-01-25

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 · 2007-01-25

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 · 2007-01-25

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

ara3n · 2007-01-25

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

mjrogers · 2007-01-26

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

Phenno · 2007-01-26

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 · 2007-01-26

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

anil_mujagic · 2007-04-10

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 · 2007-04-10

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 · 2007-04-12

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

Is there a workaround for this?

Waldo · 2007-04-12

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

Louis · 2007-04-20

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

Waldo · 2007-04-20

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 · 2007-04-20

What is in the name of the platform files ?

FRA ? NLB ? BE ? W1 ?

TIA

Louis · 2007-04-20

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

Waldo · 2007-04-20

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

... if I remember correctly

guidorobben · 2007-05-24

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

Howdy, Stranger!

Quick Links

Categories

Navision 4.0 SP3 not working in Vista

Comments