Unable to Connect to Database

[Emmeric]

A recent diskcheck found some coruppted and orphaned files over the weekend. I tried to start NT this morning and got an error.

"Unable to connect to database 'Provider=Microsoft.jet.OLEDB.4.0; User ID=Admin; Data Source=C:\Documents and Settings\Administrator\My Documents\NinjaTrader 6.5\\db\NinjaTrader.mdb': ObjectSpace: Connection String is Invalid - Could Not Load File or Assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7fIId50a3a' or one of its dependencies. The system cannot find the file specified."

I uninstalled NT and reinstalled it - got the same message when I restarted. I click OK and then get a Db.Globals.EngineI popup asking to Abort, Retry or Ignore. That brings the original popup back and then hitting OK again brings a new popup:

"No Registered JIT Debugger was Specified."

I'm sure this is something simple.

[NinjaTrader_RJ]

Hello,

Thank you for your post.


It could be you have an incorrect version of the Jet Database Engine or MDAC installed. Please go to the following pages for the correct versions. Download them on top of your existing versions.
You can install from here:
MS Jet Database Engine:

http://support.microsoft.com/kb/239114

MDAC:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

Then uninstall NinjaTrader via the windows control panel under add/remove programs. After this delete the folder NinjaTrader 6 from Start menu--> My Documents.
Now reboot your machine and download our latest production release from here:

http://www.ninjatrader.com/webnew/download_download.htm

Let me know if this corrects your issue.

[Emmeric]

Hello,

Thank you for your post.


It could be you have an incorrect version of the Jet Database Engine or MDAC installed. Please go to the following pages for the correct versions. Download them on top of your existing versions.
You can install from here:
MS Jet Database Engine:

http://support.microsoft.com/kb/239114

MDAC:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

Then uninstall NinjaTrader via the windows control panel under add/remove programs. After this delete the folder NinjaTrader 6 from Start menu--> My Documents.
Now reboot your machine and download our latest production release from here:

http://www.ninjatrader.com/webnew/download_download.htm

Let me know if this corrects your issue.

Hi, thanks for the fast response.

I followed each of those steps in order and am coming up with the same pop-up error alerts.

[NinjaTrader_RJ]

Hi, thanks for the fast response.

I followed each of those steps in order and am coming up with the same pop-up error alerts.

Ok, you may have a corrupt .NET.

Please try uninstalling ANY instance of the .NET Framework using the Windows Control Panel.

Then resintall .NET from this page: http://www.ninjatrader.com/webnew/su...ationguide.htm

[Emmeric]

Ok, you may have a corrupt .NET.

Please try uninstalling ANY instance of the .NET Framework using the Windows Control Panel.

Then resintall .NET from this page: http://www.ninjatrader.com/webnew/su...ationguide.htm

Hmm, yes. I had an issue installing the latest NET over the weekend. This is probably it.

Will let you know.

[Emmeric]

I run XP64 so I had to change download - yours was for a different system.

I am unable to install version 2.0 as I have the 2.0 SP and the 3.0 SP. I am unable to remove the SPs as Windows tells me they can't find them even though they show in the Add/Remove Programs list.

I restored to an earlier date, but the problem persists. I am thinking my only other option is a Windows reinstall.

I am trying to Windows Update the NET to the 3.5 version, but this is the idiocy that got me here in the first place. Windows Updates are for apparently for those who desire to spend days trying to fix the problems caused by these updates...

So a Windows reinstall? Or do you have another option?

Thoughts?

[NinjaTrader_RJ]

Unfortunatelly this is beyond what we can provide support for.

I suggest to contact Windows support for your best option, but it does look like an issue with your .NET Framework.

[Emmeric]

Unfortunatelly this is beyond what we can provide support for.

I suggest to contact Windows support for your best option, but it does look like an issue with your .NET Framework.

Ah, not a problem, but the Update to NET 3.5 did the trick. I re-established a connection and am logged in.

Thanks for your support - it was the NET Framework!

[netjedimaster]

is there a response to this error?

I am getting the same one and have worked on it for hours.

[NinjaTrader_VinceB]

Have you tried installing version 3.5 of the .Net?

[netjedimaster]

Vincent, Can I get some phone support so that I may get this fixed. I have just purchased the multibroker license and would like to start trading with Ninja.

This is what I have tried.
1. reinstalling NJ6.5
2. Reinstalling Netframe 2.0 and 3.5
3. Reinstalling service packs
4. Reinstalling Microsoft.jet 4.0

This is the exact error message...

Unable to connect to database 'Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Documents and Settings\My Documents\NinjaTrader6.5\\dbNinjaTrader.mbd': ObjectSpace: Connection String is Invalid - Unrecognized database format 'C:\Documents and Settings\My Documents\NinjaTrader 6.5\db\NinjaTrader.mdb'

[NinjaTrader_VinceB]

Please send a note to support at ninjatrader dot com and refer to this post. We will continue to assist from there.

[KBJ]

Fix for: Unable to Connect to NinjaTrader.mdb Database

One of my users ran into this problem last night, after a power failure at her house, and was getting exactly the same error message as was mentioned in this thread from last year...




And after trying all of the items in this thread (except for the last one of sending a note to support), I called in my Windows specialist and he found a free download that repaired the database.

The utility is called Jetcomp and it repairs Jet 4.0 databases. See: http://www.accessdatabaserepair.com/jetcomp.htm which says:

The Jet compact utility, jetcomp.exe, is a stand-alone utility that compacts databases created with Microsoft Jet database engine 3.x and 4.x. This utility may be run in conjunction with Microsoft Jet database engine 3.x and 4.x for recovering corrupted databases.

Although you can run the Microsoft Access Compact utility or the CompactDatabase method with Microsoft Jet database engine 3.x and 4.x, Jetcomp.exe may be able to recover some databases that these utilities cannot. The reason for this is that the Microsoft Access Compact utility and the CompactDatabase method attempt to open and close a database before attempting to compact it. In certain cases where these utilities may not be able to reopen the database, Compact will be unable to proceed, preventing recovery of the database. jetcomp.exe does not attempt to open and close the database before compacting, and may therefore be able to recover some databases that the Microsoft Access compact utility and the CompactDatabase method cannot.

Please backup your database before trying any Jetcomp repairs yourself.

Download JETCOMP.exe now

He then ran the utility on a copy of the NinjaTrader.mdb file (and put the repaired file back into the DB folder after it had been fixed)...



This allowed him to actually get NinjaTrader started, and then he ran the "Repair DB" option in the NinjaTrader Options screen...



I'm not sure if this last step was necessary, but as a result the NinjaTrader.mdb file ended up a little smaller, which I'm guessing will make it run a little faster, and it doesn't seem to have hurt anything, and I now have a happy trader who's back trading again this morning.

[NinjaTrader_Kyle]

Hello KBJ,

Thank you for taking the time to post this information!