以下代码是com在vb 下成功,在asp调用下产生:缺少对象: '[undefined]',不明白,请高手帮忙
------------------------------------------------------------
VB成功调用com:Option Explicit
Private conn As ADODB.Connection
Private rs As ADODB.Recordset
Private rs1 As ADODB.Recordset
Private com As webdb.webdbcommon '自定义com
Private Sub Form_Load()
Dim sql As String
Dim connstring As String
Set com = New webdb.webdbcommon
sql = "select * from News "
connstring = "Driver={SQL server};server=(LOCAL);Uid=sa;pwd=198071;database=web_db;"
Set rs1 = com.SqlExecute(connstring, sql)
Text1.Text = rs1.Fields("News_ID")
End Sub
---------------------------------------------------------------------------------------
asp调用com 不行:<%
Dim WebDB
Set WebDB= Server.CreateObject("webdb.webdbcommon")
................................
dim sql
dim connstring
dim rs
dim str
sql = "select * from News "
str="Driver={SQL server};server=(LOCAL);Uid=sa;pwd=198071;database=web_db;"
set rs=WebDB.Sqlexecute(cstr(str),cstr(sql))'此句提示:无缺少对象: '[undefined]'%>-------------------------------------------
COM 源码
Option Explicit
Private conn As ADODB.Connection
Private rs As ADODB.Recordset
Public Function SqlExecute(ConnectionString As String, SqlString As String) As ADODB.Recordset
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open ConnectionString
rs.Open SqlString, conn
Set SqlExecute = rs
'"driver={SQL Server};server=127.0.0.1;uid=sa;pwd=198071;database=web_db;"
'"select * from News order by News_Time desc ", conn
End Function
--------------------------------------
谢谢了
解决方案 »
- 如何用API调用WinRAR
- vb panel.Visible 无效——————菜鸟问题
- 用VB判断所做的Word操作是否正确
- 谁能为Text控件编写带有KeyPreview属性,以具有Form控件keyPreview属性的功能.
- 请问如何在窗体内捕获键盘输入了方向键,请尽快帮忙
- 一个vb里面的数据库变量问题
- 我有一个exe程序 需要一个ocx文件 请问我怎么打包
- ~~~请问如何察看一个控件在窗体中的位置?很菜的问题,却很急!!!!
- 哪位会CDO For Windows 2000的详细用法,能用远程SMTP主机吗?
- 为什么????help!!!
- asxToolbar 初始化时怎么按钮是隐藏的?
- 请教如何解读winsock 端口截获的数据包
Function FncExecuteSQL(strTxt,objRs)
On Error Resume Next
objRs.Open strTxt, objConn, 3, 1 If Err.No <> 0 Then
FncExecuteSQL = False
Else
FncExecuteSQL = True
End If
End Function
连接,打开,关闭用其他函数来写。