Question

asp连接sql数据库指定的初始化字符串不符合OLE DB规定

<%
dim connstr, conn
dim sql,rs
dim i
connstr="driver={sql server};server=127.0.0.1;database=book;"
set conn=server.createobject("adodb.connection")
conn.open connstr
%>
哪里有错不??
我试过
CONNSTR="driver={sql server};server=127.0.0.1;UID=XXX；PWD=XXXX；database=book;"
还是不行``

为什么还要判定的啊 ？？ 还是不行``！！天啊！！

会不会是权限没有设置好啊？？谁给我说一下权限的设置？

3楼的显示为发现数据源名称并且未指定默认驱动程序！！

Answer 1

<%
dim str
on error resume next
str="PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=book"
set conn=server.createobject("ADODB.CONNECTION")
if err then
err.clear
response.Write("数据库连接错误！")
else
conn.open str
if err then
err.clear
response.Write("数据库打开错误！")
end if
end if
%>

Answer 2

set conn=server.CreateObject("Adodb.connection")
strconn="provider=sqloledb;data source=地址;User ID=用户名;pwd=密码;Initial Catalog=数据库名"
conn.open strconn

Answer 3

connstr="driver={sql server};description=sqldemo;127.0.0.1;UID=XXX；PWD=XXXX；database=book;"

Answer 4

密码，password=“”

Answer 5

dim
conn
set
conn=server.createobject("adodb.connection")
'MSSQL连接
conn.open
"driver={SQL
server};server=127.0.0.1;UID=sa;PWD=123;database=book"
sub
closers(rs)
rs.close
set
rs=nothing
end
sub
sub
closeconn
conn.close
set
conn=nothing
end
sub