'MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("YOUR_DB.mdb")

'MS Access 2000
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\db\YOUR_DB.mdb"

'MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("YOUR_DB.mdb")

'MS Access 97
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\db\YOUR_DB.mdb"
 

'MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;"

'MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME"

'MySQL w/ MyODBC v2.50
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME"

'MySQL w/ MyODBC v3.51  (should be in one line only)
'strConnString = "driver={MySQL ODBC 3.51 Driver};
                                  option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '

'DSN

'strConnString = "DSN_NAME"

set adoConn = Server.CreateObject("ADODB.Connection")
adoConn.Open strConnString
%>