ConnectionString with Microsoft Jet OLEDB

[Gianluca_Venezia]

Hi all,
I'm approaching at .Net for make up a site but I have a problem with
web.config. I'm trying to use an *.mdb file as db, and I'd think to
use this:
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\db\db2.mdb" />

but server response me so:
ArgumentException: key word 'provider' not supported

and I'm finding no info about use *.mdb file...

Where I can find some info about?

Thanks
Gianluca

[Scott M.]

You should be specifying the full physical path to the database, not a
relative path.
Dim con as New Ole.OleDbConnection("Provider=Microsoft.JET.OLEDB. 4.0;Data
Source=C:\...."

"Gianluca_Venezia" <te************@yahoo.it> wrote in message
news:58**************************@posting.google.c om...

Hi all,
I'm approaching at .Net for make up a site but I have a problem with
web.config. I'm trying to use an *.mdb file as db, and I'd think to
use this:
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\db\db2.mdb" />

but server response me so:
ArgumentException: key word 'provider' not supported

and I'm finding no info about use *.mdb file...

Where I can find some info about?

Thanks
Gianluca

[Éric Moreau [VB MVP]]

What kind of Connection object are you using? You need to use a
OLEDBConnection (and not a SQLConnection) object.

--

HTH

Éric Moreau, MCSD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Concept S2i inc.(www.s2i.com)
"Gianluca_Venezia" <te************@yahoo.it> wrote in message
news:58**************************@posting.google.c om...

Hi all,
I'm approaching at .Net for make up a site but I have a problem with
web.config. I'm trying to use an *.mdb file as db, and I'd think to
use this:
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\db\db2.mdb" />

but server response me so:
ArgumentException: key word 'provider' not supported

and I'm finding no info about use *.mdb file...

Where I can find some info about?

Thanks
Gianluca

[Chris Dunaway]

On 7 Nov 2004 15:18:26 -0800, Gianluca_Venezia wrote:

Hi all,
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\db\db2.mdb" />

Check this link:

www.connectionstrings.com
--
Chris

dunawayc[AT]sbcglobal_lunchmeat_[DOT]net

To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.