asp连接sql2000与sql2005(带实例名)

来源：互联网发布：java中抽象类和接口编辑：程序博客网时间：2024/06/06 12:42

asp连接SQL2000的语句:
set conn=Server.CreateObject("adodb.connection")
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

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

http://blog.csdn.net/wyaspnet/archive/2009/08/19/4462605.aspx

Server=.可以测试连接成功

http://topic.csdn.net/u/20090501/22/639286e2-5dc5-4eca-884f-c7ee681d7b58.html