ASP连接MSSQL数据库语句

转载请注明出处：https://blog.csdn.net/l1028386804/article/details/85066490

ASP与MSSQL 2012  企业版连接字符串

ConnStr="Provider=SQLOLEDB;Data Source=127.0.0.1;Initial Catalog=westrac;User Id=sa;Pwd=ssddddHzx;"

ASP与MSSQL 2008 企业版连接字符串

ConnStr="driver={SQL Server};Server=.;database=gas;uid=sa;pwd=123456"

ASP与MSSQL 2005 企业版连接字符串

connstr="driver={SQL Server};Server=.;database=site_fsb;uid=sa;pwd=123456"

ASP与MSSQL 2000 企业版连接字符串

ConnStr="Provider=SQLOLEDB;Data Source=127.0.0.1;Initial Catalog=westrac;User Id=sa;Password=ssddddHzx;"

32位操作系统连接地址

ConnStr="Provider = Sqloledb; User ID = " & datauser & "; Password = " & databasepsw & "; Initial Catalog = " & databasename & "; Data Source = " & dataserver & ";"

64位操作系统连接地址

ConnStr="PROVIDER=SQLOLEDB;DATA SOURCE=" & dataserver & ";UID=" & datauser & ";PWD=" & databasepsw & ";DATABASE="& databasename &";"