
There are four ways to connect ASP to sql database, as follows:
The first way to write:
1 2 3 4 5 6 | MM_conn_STRING = "Driver={SQLServer};server=(local);uid=sa;pwd=;database=infs;"
Set conn = Server.Createobject( "ADODB.Connection" )
conn.open MM_conn_STRING
SET RS=SERVER.CreateObject( "ADOBD.recordset" )
SQL= "SELECT * FROM TABLE ORDER BY ID DESC"
RS.open SQL,CONN,3,3
|
Copy after login
The second way The first way of writing: (DSN connection)
1 2 3 4 5 6 | MM_conn_STRING= "DSN=BBS;UID=SA;PWD=12345"
Set conn = Server.Createobject( "ADODB.Connection" )
conn.open MM_conn_STRING
SET RS=SERVER.CreateObject( "ADOBD.recordset" )
SQL= "SELECT * FROM TABLE ORDER BY ID DESC"
RS.open SQL,CONN,3,3
|
Copy after login
The third way of writing:
1 2 3 | MM_conn_STRING_own = "Driver={SQLServer};server=(local);uid=sa;pwd=11111;database=infs;"
Set conn = Server.Createobject( "ADODB.Connection" )
conn.open MM_conn_STRING_own
|
Copy after login
The fourth way: This method is used in ACCESS
1 2 3 4 | strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" _
& Server.MapPath( "asp.mdb" )
set conn = server.createobject( "adodb.connection" )
conn.open strconn
|
Copy after login
The above is the detailed content of How to connect asp to sql database?. For more information, please follow other related articles on the PHP Chinese website!