Database connections : what's the difference ???

  • Thread starter Thread starter Jill Graham
  • Start date Start date
J

Jill Graham

Can someone explain me the difference between following two connection
methods ?

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\inetpub\test.mdb"

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=c:\inetpub\test.mdb"
 
The first example is using the OLEDB provider, the second is using ODBC.
Within Access itself, you can not use ODBC to connect to a Jet (mdb)
database, so this is probably an ASP page? I'm not an expert on ASP, but my
understanding is that OLEDB is generally recommended, unless perhaps you
were using a hosting service that required you to use ODBC. If I'm right in
thinking this is an ASP app, you may get more details in an ASP newsgroup.
 
Back
Top