----- ADO连接SQL Server的数据库连接字符串模板 ----------身份验证模式为:"sql server和windows"
Provider=SQLOLEDB.1;Persist Security Info=True;User ID=用户名;Password=密码;Initial Catalog=数据库名;Data Source=SQL服务器名身份验证模式为:"仅windows"
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=SQL服务器名
Provider=SQLOLEDB.1;Persist Security Info=True;User ID=用户名;Password=密码;Initial Catalog=数据库名;Data Source=SQL服务器名身份验证模式为:"仅windows"
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=SQL服务器名
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=SQL服务器名不行啊..显示登陆失败..
<%
set conn=server.createobject("adodb.connection")
connstr="provider=sqloledb.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=555;Data Source=fuwuqi"
conn.open connstr
%>
提示如下:
用户“fuwuqi\iusr_fuwuqi”登陆失败
然后把扩展名改为UDL
运行该文件
手动连接一下
再把文件改成TXT文件
打开
连接字符串在里面