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
Michael Nemtsev - 30 Sep 2006 17:56 GMT
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