未设置对象变量或 With block 变量该怎样解决?

mhf813 2004-10-09 08:51:34
我用vb写了一个连接数据库的组件如下:
工程名:dataAsp 类名:Connections
Private myscriptingcontext As ScriptingContext
Private myapplication As Application
Private myrequest As Request
Private myresponse As Response
Private myserver As Server
Private mysession As Session

Public Sub onstartpage(passedscriptingcontext As ScriptingContext)
Set myscriptingcontext = passedscriptingcontext
Set myapplication = myscriptingcontext.Application
Set myrequest = myscriptingcontext.Request
Set myresponse = myscriptingcontext.Response
Set myserver = myscriptingcontext.Server
Set mysession = myscriptingcontext.Session
End Sub

Public Sub onendpage()
Set myscriptingcontext = Nothing
Set myapplication = Nothing
Set myrequest = Nothing
Set myresponse = Nothing
Set myserver = Nothing
Set mysession = Nothing
End Sub


Public Function Conn() As ADODB.Connection
Dim strConn As String
Dim strData As String
Dim myConn As ADODB.Connection
Dim i As String
strData = "E:\data\test.mdb"
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strData
myConn.Open strConn
lawerConn = myConn
End Function

在asp中调用:
dim myConn,conn
set myConn=server.createobject("dataAsp.Connections")
conn=myconn.Conn()

提示错误:
错误类型:
dataAsp (0x800A005B)
未设置对象变量或 With block 变量

请问该怎样解决?
...全文
312 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
香椿炒鸡蛋 2004-10-09
  • 打赏
  • 举报
回复
up haha
bladeinside 2004-10-09
  • 打赏
  • 举报
回复
dim myConn as ADODB.Connection

--------->改成

dim myConn as new ADODB.Connection
mhf813 2004-10-09
  • 打赏
  • 举报
回复
我试了
不过还是提示错误:
dataAsp (0x800A005B)
未设置对象变量或 With block 变量

请问该怎样解决?

28,391

社区成员

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages,是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧