Acess 如何调用 Sql2000中的存诸过程?

xiatianlin

我是这样建立的,但是不能运行起来,请各位大侠帮帮忙,不尽感谢!

Dim Conn As ADODB.Connection

Set Conn = New ADODB.Connection

Conn.ConnectionString = "rovider='sqloledb';Data Source='xtlnote';" & _

        "Initial Catalog='BBsys';Integrated Security='SSPI';"

Dim cmd As ADODB.Command

Set cmd = New ADODB.Command

With cmd

.ActiveConnection = Conn  提示"请示OLE DB会话对象,当前提供不支持此对象"

.CommandText = "test"

.CommandType = adCmdStoredProc

End With

cmd.execute()

xinbao

.ActiveConnection = CurrentProject.connect 行不行

gaoqiwen

你的连接未打开！

Conn.Open

[此贴子已经被作者于2005-10-18 16:53:06编辑过]