vb动态链接库dll连接数据库 asp文件调用问题

来源:百度知道 编辑:UC知道 时间:2024/06/01 21:13:59
我用dll封装链接数据库的代码
Asp文件中调用Conn.结果出错
asp文件源码:

Set ConnDll = Server.CreateObject("Config.SqlConnection")
Conndll.Db = "yeekang"
Conndll.uid = "sa"
Conndll.pwd = "123456"
ConnDll.ConnectionData()
Set Rs = Server.CreateObject("Adodb.RecordSet")
Sql = "Select * From Ask"
Rs.Open Sql,newConn,1,1 '这里出错
Response.Write(Rs.RecordCount)

config.dll源码
Dim ConnStr As String
Dim Conn As New ADODB.Connection
Dim rp As Response
Dim rq As Request
Dim ap As Application
Dim se As Session
Dim sr As Server
Public Db As String
Public uid As String
Public Pwd As String
Public Sub OnStartPage(Mysc As ScriptingContext)
Set rp = Mysc.Response
Set rq = Mysc.Request
Set ap = Mysc.Application
Set se = Mysc.Session
Set sr = Mysc.Server
End Sub
Public Sub OnEndPage()
S

asp文件源码:

Set ConnDll = Server.CreateObject("Config.SqlConnection")
Conndll.Db = "yeekang"
Conndll.uid = "sa"
Conndll.pwd = "123456"
ConnDll.ConnectionData()
Set Rs = Server.CreateObject("Adodb.RecordSet")
Sql = "Select * From Ask"
Rs.Open Sql,ConnDll.Conn,1,1
Response.Write(Rs.RecordCount)

config.dll源码
Dim ConnStr As String
Public Conn As New ADODB.Connection
Dim rp As Response
Dim rq As Request
Dim ap As Application
Dim se As Session
Dim sr As Server
Public Db As String
Public uid As String
Public Pwd As String
Public Sub OnStartPage(Mysc As ScriptingContext)
Set rp = Mysc.Response
Set rq = Mysc.Request
Set ap = Mysc.Application
Set se = Mysc.Session
Set sr = Mysc.Server
End Sub
Public Sub OnEndPage()
Set rp = Nothing
Set rq = Nothing