PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Reach a MDB-file without Jet client installation

Reply

Reach a MDB-file without Jet client installation

 
Thread Tools Rate Thread
Old 06-04-2006, 08:54 PM   #1
Magnus
Guest
 
Posts: n/a
Default Reach a MDB-file without Jet client installation


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


  Reply With Quote
Old 07-04-2006, 03:19 PM   #2
Norman Yuan
Guest
 
Posts: n/a
Default Re: Reach a MDB-file without Jet client installation

"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.

"Magnus" <magnus.blomberg@skanska.se> wrote in message
news:eyszqPbWGHA.4768@TK2MSFTNGP05.phx.gbl...
> 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
>



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off