ASP data connection

1. Connect with DSN without the user name and password:

<%
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open "yourdsnname"
%>

Connect with DSN and have the user name and password:

<%
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open "yourdsnname", "username", "password"
%>

2. Use the actual absolute path of the database to connect:

<%
Set conn = server. Createobject ("ADODB. Connection ")
Strconn = "driver = {Microsoft Access Driver (*. mdb )};"
Strconn = strconn & "DBQ = E:/yanhang/database. mdb"
Conn. Open strconn
%>

Use the actual database relative path to connect:

 

"Provider = Microsoft. Jet. oledb.4.0; Data Source =" & server. mappath ("/admin/# database. mdb ")

<%
Set conn = server. Createobject ("ADODB. Connection ")
Strconn = "driver = {Microsoft Access Driver (*. mdb )};"
Strconn = strconn & "DBQ =" & server. mappath ("/database/yanhang. mdb ")
Conn. Open strconn
%>

2. ms SQL Server database connection

Connect with DSN:

<%
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open "DSN = mydsn; uid = user; Pwd = password; database = databasename"
%>

No DSN connection required:

<%
Set conn = server. Createobject ("ADODB. Connection ")
Dsntemp = "driver = {SQL Server}; server = servername; uid = user; Pwd = password; database = databasename"
Conn. Open dsntemp
%>

Iii. FoxPro database connection

<%
Set conn = server. Createobject ("ADODB. Connection ")
Connstr = "driver = Microsoft Visual FoxPro driver; uid = userid; sourcetype = dBc; sourcedb = C:/yanhang/database. DBC"
Conn. Open connstr
%>

4. Oracle database connection:

<%
Set conn = server. Createobject ("ADODB. Connection ")
Conn. cursorlocation = aduseclient
Dsntemp = "provider = msdaora.1; Password = XXXXX; user id = yanhang; Data Source = xxx. World"
Conn. Open dsntemp
%>