-
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
-
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.