Reach a MDB-file without Jet client installation

[Magnus]

Hi!

I am writing a complex system where a small part will connect to an mdb.file
to reach some simple information.
The problem is that I don't want to deploy any jet engine.
Right now I have a well working Visual Studio 2005, with Dotnet 2.0 Windows
Server 2003 machine, without Access or Jet installed.
I would like to keep it that way, but I still want to write some simple
select queries to the mdb file.
Is this possible?!?! Is there components in Dotnet 2.0 or MDAC installed in
XP/WS2003 standard that provides this?

The current test code is:
System.Data.Odbc.OdbcConnection connPagero =
new System.Data.Odbc.OdbcConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Bank1iC.mdb;Persist Security Info=False;Mode=Read");
connPagero.Open();

The error I get with the Open method is:
The .Net Framework Odbc Data Provider requires Microsoft Data Access
Components(MDAC) version 2.6 or later. Version 2.12.4202.3 was found
currently installed.

Please help
Regards Magnus

 

[Norman Yuan]

"Server 2003 machine, without Access or Jet installed"?

Jet engine comes with Windows of all versions (at least since Win98. Do not
know for Vista). How do you manage to have a Windows computer without Jet?
In your case, of course, you do not need Access for your app to access data
in *.mdb file. So, yes, you can keep your computer as it is and have your
..NET app get data from *.mdb file. Note, you may want to update your
Windows, namely, the Jet engine, to latest service pack (SP8, I think).
MDAC, since its 2.6, does not include Jet update any more.