UC知道子目录下出现数据库连接出错,请检查连接字串
来源：百度知道 编辑：UC知道 时间：2024/05/16 11:02:10
我在网站的子目录下（假设这个文件名是：123）放置着网站文件，在123文件夹里有一个conn.asp，程序是：
<head>
<meta http-equiv="Content-Language" content="zh-cn">
</head>
<%
Dim Startime,SqlNowString,ConnStr
Dim conn,Db,MyDbPath,pos
Startime = Timer()
MyDbPath = ""
MyDbPath=request.ServerVariables("url")
pos=instr(MyDbPath,"/")+1
MyDbPath=left(MyDbPath,instr(pos,MyDbPath,"/"))
Const IsSqlDataBase = 0
If IsSqlDataBase = 1 Then
Const SqlDatabaseName = "dzwangweb2"
Const SqlPassword = ""
Const SqlUsername = "sa"
Const SqlLocalName = "(local)"
SqlNowString = "GetDate()"
Else
Db = "database/#008.asa"
SqlNowString = "Now()"
End If
If IsSqlDataBase = 1 Then
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & ";
<head>
<meta http-equiv="Content-Language" content="zh-cn">
</head>
<%
Dim Startime,SqlNowString,ConnStr
Dim conn,Db,MyDbPath,pos
Startime = Timer()
MyDbPath = ""
MyDbPath=request.ServerVariables("url")
pos=instr(MyDbPath,"/")+1
MyDbPath=left(MyDbPath,instr(pos,MyDbPath,"/"))
Const IsSqlDataBase = 0
If IsSqlDataBase = 1 Then
Const SqlDatabaseName = "dzwangweb2"
Const SqlPassword = ""
Const SqlUsername = "sa"
Const SqlLocalName = "(local)"
SqlNowString = "GetDate()"
Else
Db = "database/#008.asa"
SqlNowString = "Now()"
End If
If IsSqlDataBase = 1 Then
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & ";
这个问题这样就能解决:
第一：IIS中把根目录设置成你的这个网站根目录(很重要)
第二: Db变量的值第一字母必须是"/" ,如：db="/database/#008.asa"
这是我多年所知道，，要加分哦！