如题!我在网上看到的都是用ACCESS数据库的,比如:
'================================================================
'过程作用:打开数据库连接
'================================================================
Dim Conn,Auto_DataBaseName,Auto_HostName,Auto_DataBaseUrl
Sub ConnOpen()
If Auto_DataBaseKind = "0" Then
Auto_DataBaseName = "DataBaseName" '数据库名称
Auto_HostName = "localhost" '服务器名称或IP
Auto_UserId = "sa" '登陆数据库用户ID
Auto_LogoPassWord = "" '登陆数据库密码
Auto_OaClassConnStr = "Provider = Sqloledb; User ID = " & Auto_UserId & "; Password = " & Auto_LogoPassWord & "; Initial Catalog = " & Auto_DataBaseName & "; Data Source = " & Auto_HostName & ";"
ElseIf Auto_DataBaseKind = "1" Then
Auto_DataBaseName = "Data.mdb" '数据库名称
Auto_DataForder = "" 'Access数据库存放目录,请务必以“\”结尾
Auto_DataBaseUrl = Server.MapPath(Auto_DataForder & Auto_DataBaseName)
Auto_OaClassConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Auto_DataBaseUrl
Else
Response.Write("数据库类型定义错误,请检查文件DbConn.asp中数据库类型定义是否正确!")
Response.End()
End If
On Error Resume Next
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open Auto_OaClassConnStr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write ("数据库连接出错,请检查文件Conn.asp中连接字符串。")
Response.End()
End If
End Sub
'================================================================
'过程作用:关闭数据库连接
'================================================================
Sub ConnClose()
Conn.close()
Set Conn = Nothing
End Sub
%>
================================================================
我用的是SQL 2000数据库,我要怎么改上面的代码!请写详细点,我是小白.
ASP上传图片到文件夹,保存路径到SQL数据库
答案:1 悬赏:0 手机版
解决时间 2021-02-07 15:22
- 提问者网友:沉默的哀伤
- 2021-02-06 18:15
最佳答案
- 五星知识达人网友:西风乍起
- 2021-02-06 18:28
把数据库连接那一段改成下面这一段就可以了:
Dim Conn
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={SQL Server};server=localhost;uid=用户名;pwd=密码;database=数据度"
Sub Closedb() ' 关闭数据库连接
Conn.Close
Set Conn=Nothing
End Sub
Dim Conn
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={SQL Server};server=localhost;uid=用户名;pwd=密码;database=数据度"
Sub Closedb() ' 关闭数据库连接
Conn.Close
Set Conn=Nothing
End Sub
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯