[asp] ADODB

[ODBC ]

Dim DBCon

Set DBCon= Server.CreateObject("ADODB.Connection")

DBCon.Open "DSN=aaa"

또는

DBCon.Open "DSN=aaa;uid=aa;pwd=aaa"

[OLE DB - Microsoft.jet.OLEDB]

Dim DBCon

Set DBCon= Server.CreateObject("ADODB.Connection")

DBCon.Open "Provider=Microsoft.jet.OLEDB.4.0;Data Source=D:\~~\aa.mdb"

[OLE DB - SQLOLEDB]

Dim DBCon

Set DBCon= Server.CreateObject("ADODB.Connection")

DBCon.Open "Provider=SQLOLEDB;Data Source=mysql;Initial Catalog=aa;user ID=aaa;password=aa"