asp连接SQL2000的语句:
set conn=Server.CreateObject("adodb.connection")
conn.open "Driver={SQL SERVER};server=(local);database=Mydata;UID=sa;PWD=123;"
conn.open "Driver={SQL SERVER};server=(local);database=Mydata;UID=sa;PWD=123;"
asp连接SQL2005的语句:
set conn=Server.CreateObject("adodb.connection")
path="Provider=SQLNCLI;Server=(local)/SQL2005;uid=Gaojie;pwd=123;database=Mydata2005"
conn.open path
path="Provider=SQLNCLI;Server=(local)/SQL2005;uid=Gaojie;pwd=123;database=Mydata2005"
conn.open path
DB_ServerName ="(local)/SQLEXPRESS" '数据库名称(IP+实例名)
DB_UserName = "sa" 'SQL用户名
DB_PassWord = "12F352f" 'SQL用户密码
DB_DateBase = "TFSCM" '数据库名
DB_Provider = "SQLNCLI" '驱动程序
DB_ConnStr = "Provider="&DB_Provider&"; UID="&DB_UserName&"; Pwd="&DB_PassWord&"; database="&DB_DateBase&"; Server="&DB_ServerName&";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DB_ConnStr
DB_UserName = "sa" 'SQL用户名
DB_PassWord = "12F352f" 'SQL用户密码
DB_DateBase = "TFSCM" '数据库名
DB_Provider = "SQLNCLI" '驱动程序
DB_ConnStr = "Provider="&DB_Provider&"; UID="&DB_UserName&"; Pwd="&DB_PassWord&"; database="&DB_DateBase&"; Server="&DB_ServerName&";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DB_ConnStr