forex truth

Wednesday, December 16, 2009

NinjaTrader database access error solved - Repair MDAC Type on Windows XP SP3

I just installed the NinjaTrader Version 6.5.1000.14, when launching the Ninjatrader, it pop up a message box showing the error accessing the accesss database due to the MS JET version is not 6.0.

But when i try to run the MDAC Type 2.6 and 2.7 installation, it ran through smoothly but doesn't solve the issue.

If i to run the windowsxp-kb829558-x86-enu.exe downloaded from http://support.microsoft.com/kb/239114/, it gives me a message box saying that i've JET even newer and not necessary to update.


I checked my msjet40.dll the version is 4.0.9511.0 Windows XP SP3 and Security Bulletin MS08-028. When i run microsoft component checker, it said i use mdac 2.8 SP1 on WinXP SP3. (see attached image)


I also have tried to uninstalled Ninjatrader and install with Version 6.5.1000.13, but facing the same problem.

I'm using the .NET Framework 3.5 on Win XP Home.

After continue research, the solution below solved the problem, it's due to the MDAC file corrupted, nothing concern with Ninjatrader. As Ninjatrader need to access to Access database using the MDAC :

How to Repair MDAC 2.81 under Windows XP SP3 , dot NET Framework 3.5

1. In Windows Explorer, open the c:\Windows\Inf folder.

Note If you cannot see the c:\Windows\Inf folder, follow these steps:
a. On the desktop, double-click My Computer, and then on the Tools menu, click Folder Options.
b. Click the View tab.
c. Under Advanced settings, select the Show hidden files and folders check box.
d. Clear the Hide extensions for known file types check box.
e. Click OK.


In the C:\Windows\Inf folder, right-click the Mdac.inf file, and then click Install.

a. When requested for MDAC required files, point it to your WinXP Setup CD. It should be in the :\I386.

b. First file requested should be adcjavas.inc, but the file in the CD is adcjavas.in_ , you may need to unzip the file and point to it again.

c. At one stage when it can auto extract and continue installing the remaining files from your CD, then the whole process is done.

d. You may be requested to restart your computer for the changes to take effect.



Wow, eventually got the Ninjatrader running.

No comments: