Shulou(Shulou.com)06/01 Report--

Editor to share with you what are the methods of asp connecting to sql database, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

There are four ways for asp to connect to the sql database, as follows:

The first way to write:

MM_conn_STRING = "Driver= {SQLServer}; server= (local); uid=sa;pwd=;database=infs;" Set conn = Server.Createobject ("ADODB.Connection") conn.open MM_conn_STRINGSET RS=SERVER.CreateObject ("ADOBD.recordset") SQL= "SELECT * FROM TABLE ORDER BY ID DESC" RS.open SQL,CONN,3,3

The second way to write: (DSN connection)

MM_conn_STRING= "DSN=BBS;UID=SA;PWD=12345" Set conn = Server.Createobject ("ADODB.Connection") conn.open MM_conn_STRINGSET RS=SERVER.CreateObject ("ADOBD.recordset") SQL= "SELECT * FROM TABLE ORDER BY ID DESC" RS.open SQL,CONN,3,3 / / 3Pol 3 is the modify, delete, add switch!

The third way of writing:

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

Fourth: this method is used in ACCESS

Strconn = "DRIVER=Microsoft Access Driver (* .mdb); DBQ=" _ & Server.MapPath ("asp.mdb") set conn = server.createobject ("adodb.connection") conn.open strconn what are all the contents of asp's method of connecting to the sql database? thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.