How do I connect to my database ?
You can use DSN-less connections.
DSN-less connections are faster than System DSN connections because DSN-less avoids doing a registry lookup. Furthermore you can receive additional performance benefits by directly using the OLEDB layer.
Here is an example:
Dim Conn, dbPath
dbPath = "D:\domains\yourdomain.com\db\youraccessfile.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPathOr you can use server map path:
Set MyConn = Server.CreateObject("ADODB.Connection")
conString = "DBQ=" & Server.MapPath("YourDatabase.mdb")
Myconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & conStringMore information can be found at:
http://www.aspin.com
http://www.powerasp.com