ODBC!!!!!!!!!!!!!!!

[kandan]

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

[laudy]

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.