Various database connection codes
I have nothing to do today, so I summarized the connections of various databases, and now I share them with you:
MS Access database connection
Connect with DSN and no username and password:
<%
set conn = Server.CreateObject(ADODB.Connection)
conn.open YourDSNName
%>
Connect with DSN and have username and password:
<%
set conn = Server.CreateObject(ADODB.Connection)
conn.open YourDSNName,username,password
%>
Connect with the actual absolute path to the database:
<%
Set conn = Server.CreateObject(ADODB.Connection)
Strconn=DRIVER={Microsoft Access Driver (*.mdb)};
Strconn=Strconn & DBQ=e:/yanhang/database.mdb
conn.Open Strconn
%>
Connect with actual database relative path:
<%
Set conn = Server.CreateObject(ADODB.Connection)
Strconn=DRIVER={Microsoft Access Driver (*.mdb)};
Strconn=Strconn & DBQ= & Server.MapPath(/database/yanhang.mdb)
conn.Open Strconn
%>
MS SQL Server database connection
Connect with DSN:
<%
set conn = Server.CreateObject(ADODB.Connection)
conn.open DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename
%>
Without DSN connection:
<%
Set conn = Server.CreateObject(ADODB.Connection)
DSNtemp=DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=databasename
conn.open DSNtemp
%>
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
%>
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
%>