Various database connection codes in ASP

web front end seven thousand six hundred and ninety-five 14 years ago (2011-04-02)

MS Access data base Connection
Connect with DSN without user name and password:
 

ASP code
  1. <%    
  2. set conn = Server. CreateObject( "ADODB.Connection" )    
  3. conn.open  "YourDSNName"     
  4. %>  

Connect with DSN and have user name and password:

ASP code
  1. <%    
  2. set conn = Server. CreateObject( "ADODB.Connection" )    
  3. conn.open  "YourDSNName" , "username" , "password"     
  4. %>  

Connect with the actual database absolute path:
 

ASP code
  1. <%    
  2. Set  conn = Server. CreateObject( "ADODB.Connection" )    
  3. Strconn= "DRIVER={Microsoft Access Driver (*.mdb)};  "     
  4. Strconn=Strconn &  "DBQ=e:\yanhang\database.mdb"     
  5. conn.Open Strconn    
  6. %>   

 

Connect with the actual database relative path:
 

ASP code
  1. <%    
  2. Set  conn = Server. CreateObject( "ADODB.Connection" )    
  3. Strconn= "DRIVER={Microsoft Access Driver (*.mdb)};  "     
  4. Strconn=Strconn &  "DBQ="  & Server. MapPath( "/database/yanhang.mdb" )    
  5. conn.Open Strconn    
  6. %>  

 

MS SQL Server Database Connection
Connect with DSN:

ASP code
  1. <%    
  2. set conn = Server. CreateObject( "ADODB.Connection" )    
  3. conn.open  "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename"     
  4. %>  

No DSN connection:

ASP code
  1. <%    
  2. Set  conn = Server. CreateObject( "ADODB.Connection" )    
  3. DSNtemp= "DRIVER={SQL Server}; SERVER=ServerName; UID=USER; PWD=password; DATABASE=databasename"     
  4. conn.open DSNtemp    
  5. %>  

FoxPro database connection
 

ASP code
  1. <%    
  2. Set  Conn = Server. CreateObject( "ADODB.connection" )    
  3. ConnStr=  "Driver=Microsoft Visual Foxpro Driver;  UID=userID; SourceType=DBC; SourceDB=C:\yanhang\database.dbc"     
  4. Conn.Open ConnStr    
  5. %>  

 

Oracle database connection:
 

ASP code
  1. <%    
  2. set conn=server.createobject( "adodb.connection" )    
  3. conn.cursorlocation=adUseClient    
  4. DSNTemp= "Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang; Data Source=xxx.world"     
  5. conn.open DSNtemp    
  6. %>