Asp data connectivity method
MS Access Database Connection
DSN connections, and with no user name and password:
<%
Set conn = Server.CreateObject ( "ADODB.Connection")
Conn.open "YourDSNName"
%>
DSN connections, and with useful username and password:
<%
Set conn = Server.CreateObject ( "ADODB.Connection")
Conn.open "YourDSNName", "username", "password"
%>
The actual database absolute path links:
<%
Set conn = Server.CreateObject ( "ADODB.Connection")
Strconn = "DRIVER = (Microsoft Access Driver (*. mdb));"
Strconn Strconn & = "DBQ = e: \ yanhang \ database.mdb"
Conn.Open Strconn
%>
The actual database relative path links:
<%
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
Using DSN connection:
<%
Set conn = Server.CreateObject ( "ADODB.Connection")
Conn.open "DSN = MyDSN; UID = user; PWD = password; DATABASE = databasename"
%>
Not DSN connection:
<%
Set conn = Server.CreateObject ( "ADODB.Connection")
DSNtemp = "SQL Server DRIVER = (); 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
%>
Tags: ASP
0 Comments to “Asp data connectivity method”
No Comments. Send your comment.
Leave a Reply
You must be logged in to post a comment.