ASP连接MSSQL数据库语句

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

ASP与MSSQL 2012  企业版连接字符串
ConnStr=\"Provider=SQLOLEDB;Data Sourcer=127.0.0.1;Initial Catalog=westrac;User Id=sa;Pwd=ssddddHzx;\"

ASP与MSSQL 2008 企业版连接字符串
ConnStr=\"driver={SQL Server};Server=.;data =gas;uid=sa;pwd=123456\"

ASP与MSSQL 2005 企业版连接字符串
connstr=\"driver={SQL Server};Server=.;data =site_fsb;uid=sa;pwd=123456\"

ASP与MSSQL 2000 企业版连接字符串
ConnStr=\"Provider=SQLOLEDB;Data Sourcer=127.0.0.1;Initial Catalog=westrac;User Id=sa;Password=ssddddHzx;\"

32位操作系统连接地址
ConnStr=\"Provider = Sqloledb; User ID = \" & datauser & \"; Password = \" & data psw & \"; Initial Catalog = \" & data name & \"; Data Source = \" & dataserver & \";\"

64位操作系统连接地址
ConnStr=\"PROVIDER=SQLOLEDB;DATA SOURCE=\" & dataserver & \";UID=\" & datauser & \";PWD=\" & data psw & \";DATA =\"& data name &\";\"