请大虾帮忙写一个访问sql server的代码！急急

str="provider=SQLOLEDB;server=Server01;database=lc;UID=sa;PWD=1111111"

解决方案 »

  1.   


    <%
    option explicitdim startime,endtime,cn,strstartime=timer() 
     
     
     '&Ccedil;&euml;&acute;ó&Iuml;&ordm;&Ocirc;&Uacute;&acute;&Euml;&acute;&brvbar;&frac14;&Oacute;&Egrave;&euml;&acute;ú&Acirc;&euml;~&pound;&iexcl;
    strcn="provider=SQLOLEDB;server=ServerName;database=DB_name;UID=sa;PWD=123"set cn=server.CreateObject ("adodb.connection")
    cn.Mode=admodereadwrite
    cn.ConnectionString=constr
    cn.CursorLocation=aduseclient
    cn.Open strCncn.Open strfunction CloseDatabaseCn.closeSet cn = NothingEnd Function
    %>
      

  2.   

    str ="Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=databasename;Data Source=server;Connect Timeout=600" 
    or
    str="PROVIDER=SQLOLEDB;DATA SOURCE=server;UID=sa;PWD=password;DATABASE=databasename" 
    or
    str="driver={sql server};server=server;uid=sa;pwd=password;database=databasename"
      

  3.   

    conn.open "provider=SQLOLEDB;server=(local);database=database_name;UID=username;PWD=pwd"
      

  4.   

    str="provider=SQLOLEDB;server=(local);database=database_name;UID=username;PWD=pwd"