Various database connection codes in ASP
-
<% -
set conn = Server. CreateObject( "ADODB.Connection" ) -
conn.open "YourDSNName" -
%>
-
<% -
set conn = Server. CreateObject( "ADODB.Connection" ) -
conn.open "YourDSNName" , "username" , "password" -
%>
-
<% -
Set conn = Server. CreateObject( "ADODB.Connection" ) -
Strconn= "DRIVER={Microsoft Access Driver (*.mdb)}; " -
Strconn=Strconn & "DBQ=e:\yanhang\database.mdb" -
conn.Open Strconn -
%>
-
<% -
Set conn = Server. CreateObject( "ADODB.Connection" ) -
Strconn= "DRIVER={Microsoft Access Driver (*.mdb)}; " -
Strconn=Strconn & "DBQ=" & Server. MapPath( "/database/yanhang.mdb" ) -
conn.Open Strconn -
%>
-
<% -
set conn = Server. CreateObject( "ADODB.Connection" ) -
conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename" -
%>
-
<% -
Set conn = Server. CreateObject( "ADODB.Connection" ) -
DSNtemp= "DRIVER={SQL Server}; SERVER=ServerName; UID=USER; PWD=password; DATABASE=databasename" -
conn.open DSNtemp -
%>
-
<% -
Set Conn = Server. CreateObject( "ADODB.connection" ) -
ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID; SourceType=DBC; SourceDB=C:\yanhang\database.dbc" -
Conn.Open ConnStr -
%>
-
<% -
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 -
%>