Unable to connect to database 'Provider=Microsoft.Jet. etc. Unrecognized db format...

[Brenda]

Have been running NT for months with absolutely no problems. All of a sudden got this message when start up. Have Microsoft .NET Framework 3.5 SP1, which is the latest version. Am attaching a copy of the error message displayed by Ninja Trader. Thanks for any help.

[NinjaTrader_Jason]

Hello Brenda,

Can you please send me your latest log and trace files. You can find these files at the following locations.

Start Menu--> My Documents--> NinjaTrader 6.5--> Log--> log.20100319.txt for today. (log.yyyymmdd for any other date)

Start Menu--> My Documents--> NinjaTrader 6.5--> Trace--> trace.20100319.txt for today. (trace.yyyymmdd for any other date)

Please send them to support[at]ninjatrader[dot]com, reference this forum thread and put 'Attn Jason' in the subject header.

[Brenda]

Hi Jason,

Thank you very much for your prompt reply. I just e-mailed logs and traces for today the 19th (I retried unsuccessfully), yesterday (the first time the problem happened) and the 17th when I had no problems. Please let me know if you need any more info. Thanks for everything.

Brenda

[NinjaTrader_RyanO]

Hello Brenda,

I did receive your trace and log files, and please let us know if you have not received my response, or if the issue still persists.

In my reply, based on the log and trace files, I had you to rename the database. To rename the DB:

• Shutdown NinjaTrader and Go to the Start Menu
• Select My Documents--> NinjaTrader 6.5--> DB--> NinjaTrader.MDB.
• Right click on NinjaTrader.MDB and select "Rename."
• Name it "NewNinjaTrader.MDB."
• Then restart the software.

[Brenda]

Hi Ryan,

My apologies for not responding sooner to your helpful message. I did what you said and was able to run Ninja Trader again. Thank you so much. Had to recreate my charts, but what the heck, I think I had too much data anyways and it just got too crowded. I am now trying to keep just the data that I'm using. If it happens again I know what to do. By the way, I imagine that deleting the database would also work, wouldn't it?

Ryan, I have another problem sometimes. I add a new stock with Instrument Manager and then I try to get a chart of that stock and I get "Error in requesting historical data from IB: No security definition has been found for the request(200)" One of the symbols that that is happening with is the S&P Index (^SPX), which in fact I was able to get before I had the database problem. This security is defined in my IB simulation program, so I don't understand. Other securities are: ACH, GDX, UPL, PCX and others. All these are American Securities. This always happened with foreign securities such as PBR, but now am able to get PBR. I'm lost!

[NinjaTrader_RyanO]

Hi,

Within NinjaTrader the SP500 index is called SP500. Can you please reset your instruments and then chart that symbol in NinjaTrader. To reset your instruments please: go to the Tools menu, select the Options menu item, select the Misc tab, and then click on 'Reset Instruments'.


As for the other instruments please start typing on an open chart to change the symbol from the command line. This will also add the symbol to the database if it is not present already.

[Brenda]

Hi Ryan, did all you said and got the exact same results. Ninja Trader does not recognize SP500, SPX, nor ^SPX. Got error messages with the same symbols as before. Also did not make any difference typing them on the chart. It's very frustrating.

[NinjaTrader_RyanO]

Hi Brenda,

Can you please check whether you get data for those symbols in IB. If so please right click on the instrument and select Contract-->Details.

With the contract symbol please go to Tools-->Instrument Manager and for the instrument please input what is available from IB in the symbol mapping for IB within the NinjaTrader symbol mapping. Please see the following link for editing instruments.

http://www.ninjatrader-support.com/HelpGuideV6/helpguide.html?EditingInstruments