大曲的制作方法:求救!!!关于动态网页(asp)的问题?
来源:百度文库 编辑:杭州交通信息网 时间:2024/04/29 10:02:01
当我用通用的数据源的ole db连接连接字符串如下
<%
Set conn = Server.CreateObject ("ADODB.Connection")
DBName="WebTeaching"
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=(local);UserID=sa;pwd=password;Database=" &DBName& ";"
conn.Open connstr %>这段是数据库的连接字符串,但在运行时出现以下提示:错误类型:
Microsoft OLE DB Provider for SQL Server (0x80004005)
连接字符串属性无效
/1/Chapter11/Webteaching/conn.asp, 第 5 行
我不明这是什么原因;
<%
Set conn = Server.CreateObject ("ADODB.Connection")
DBName="WebTeaching"
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=(local);UserID=sa;pwd=password;Database=" &DBName& ";"
conn.Open connstr %>这段是数据库的连接字符串,但在运行时出现以下提示:错误类型:
Microsoft OLE DB Provider for SQL Server (0x80004005)
连接字符串属性无效
/1/Chapter11/Webteaching/conn.asp, 第 5 行
我不明这是什么原因;
Database=" &DBName& ";" 最后的";" 去掉看看
"Provider=SQLOLEDB;data source=(local);initial catalog="&DBName&";userid=sa;password=password;"
<%
Const SqlDatabaseName = "alumni"
Const SqlPassword = "alumni"
Const SqlUsername = "alumni"
Const SqlLocalName = "(local)"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错,请检查连接字串。"
Response.End
End If
sub endConnection()
conn.Close
set conn=nothing
end sub
%>
这是我网站的代码
没有什么问题的