asp connection mssql2005 code

Recently, many server databases have used mssql2005. Friends who also write asp need to pay attention. It is different from the string of sql2000. Copy the code code as follows:

<%

dim objconn,connstr

Set objconn = Server.CreateObject(ADODB.Connection)

connstr = Provider=SQLNCLI;Server=(local);Database=sosuo8.comdatabase;Uid=sa;Pwd=123;

objconn.Open connstr

%>