VBScript：与 ODBC 的连接失败，并显示错误消息"Operation is not allowed when the object is closed"

Question

我有下面的代码，这是抛出我一个错误"操作是不允许当对象关闭"。我遗漏了什么?

 Dim dbconnect, dbresults
 Set dbconnect = CreateObject("ADODB.Connection")
 Set dbresult = CreateObject("ADODB.Recordset")
dbconnectString =  "driver=iSeries Access ODBC Driver;System=***;UID=***;PWD=***;Naming=1"
dbconnect.Open (dbconnectString)        
mySQLQuerry ="Select XOORIG  from FIQDLIB.FSFPXO as400xo WHERE as400xo.xoefdt = 1130418 and as400xo.xotrsq in (75440)"
dbresult.Open mySQLQuerry, dbconnect

Answer 1

打开连接后检查与WScript.Echo dbconnect.State的连接状态。此外，您的连接字符串看起来不正常。