转载请注明出处: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 &";"