Error opening database

30 Sep 2006 1:12 PM

Steve Barnett

I've developed a test application on my PC that uses the JET Engine. The
connection string is very basic and is constructed as follows:
connectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source='{0}'", modelName);

On the development PC, this works fine. On a test PC, I get a message:
The format of the initialisation string does not conform to
specification starting at index 33

Since the same string works on the development PC, I'm taking this to mean
that there are missing drivers on the target PC. I thought I could sort this
by installing MDAC 2.8, but when I went to the downloads site, it explicitly
says that JET and OLEDB aren't included.

What do I need to get installed to be able to open my database? Or am I
wrong and there is a format error?

Thanks
Steve

30 Sep 2006 4:56 PM

Michael Nemtsev

Hello Steve,

try to download previous version of MDAC.
They remove old drives from one of 2.x version

SB> I've developed a test application on my PC that uses the JET Engine.
SB> The
SB> connection string is very basic and is constructed as follows:
SB> connectionString =
SB> String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data
SB> Source='{0}'", modelName);
SB> On the development PC, this works fine. On a test PC, I get a
SB> message:
SB> The format of the initialisation string does not conform to
SB> specification starting at index 33
SB> Since the same string works on the development PC, I'm taking this
SB> to mean that there are missing drivers on the target PC. I thought I
SB> could sort this by installing MDAC 2.8, but when I went to the
SB> downloads site, it explicitly says that JET and OLEDB aren't
SB> included.
SB>
SB> What do I need to get installed to be able to open my database? Or
SB> am I wrong and there is a format error?
SB>
SB> Thanks
SB> Steve
---
WBR,
Michael Nemtsev :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche