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