connection strings

Results 1 to 2 of 2

Thread: connection strings

  1. #1
    Join Date
    Dec 1969

    Default connection strings

    The two connection strings below do the same thing but the second one using Jet 4.0 is more efficient. Why?<BR><BR>"Driver={Microsoft Access Driver (*.mdb)};DBQ=server.mappath("/test.mdb")" <BR><BR>"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=server.mappath("/test.mdb")" <BR> <BR>Thank you.

  2. #2
    Join Date
    Dec 1969

    Default RE: connection strings

    They use different providers.<BR><BR>I think the first is an ODBC driver, the second obviously is an OLEDB driver. I don&#039;t know all the differences, but the important thing to remember is that OLEDB has a better performance than ODBC.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts