Results 1 to 2 of 2

Thread: ODBC!!!!!!!!!!!!!!!

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 1999
    Posts
    52

    Post


    i have a database that i connect (DSN-less) using ADO and i've tried two
    ways(succesfully) to open the connection :

    1. dbConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
    server.mappath(mDatabaseLoc)

    ' the location of the database is the web root mDatabaseLoc ="customer.mdb"

    2. dbConn.Open "Provider=Microsoft.Jet.OLEDB.3.51; Data
    Source=c:\inetpub\wwwroot\search\customer.mdb"


    can anyone pls tell me what is the difference between the two methods? and
    which is the better?


    thanks



  2. #2
    Member
    Join Date
    Nov 1999
    Location
    Princeton, New Jersey
    Posts
    46

    Post

    Hi,

    Check this article out at: http://www.4guysfromrolla.com/webtech/070399-1.shtml

    It details the differences between the DSN...DSN/less connection debate.

    Basically it says DSN/less is faster.

Posting Permissions

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



Click Here to Expand Forum to Full Width