Different DSNless methods

Results 1 to 2 of 2

Thread: Different DSNless methods

  1. #1
    Join Date
    Dec 1969

    Default Different DSNless methods

    Charles Carolls ASP site gives to examples of DSNless connections to Access. Can anyone explain the differences between them and when to use them please<BR><BR>from (http://www.learnasp.com/learn/dbopen.asp)<BR><BR>OLEDB Good Connection String (recommended)<BR>strconn="PROVIDER=Microsoft.Jet.O LEDB.4.0;DATA SOURCE="<BR>strconn=strconn & server.mappath(accessDB) & ";"<BR>&#039;strconn=strconn & "Password=whatever;"<BR><BR>ODBC Connection String (not recommended)<BR>strconn="DRIVER={Microsoft Access Driver (*.mdb)};"<BR>strconn=sourceDSN & "DBQ=" & server.mappath(accessdb)<BR>strconn=sourceDSN & "Password=whatever;"<BR><BR><BR>Thanks<BR>Rich

  2. #2
    Join Date
    Dec 1969

    Default Use the OLE-DB connection sting.

    The difference is that OLE-DB uses one less layer to get the data from the data souce to the requesting code, and is far more stable.

Posting Permissions

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