Error 3669: Execution cancelled.

Error 3669: Execution cancelled.

Post by Alex S » Tue, 08 Dec 1998 04:00:00



Hi, there. This is the story.
I have a table called "tblXY" in Oracle 7.3.4 which looks like the following

x        y         att1     att2    att3
-------- --------- -------- ------- --------
123404   155827    a        a       c
155133   444266    a        b       c
523426   169851    a        b       a
233771   898801    a        b       c
.
.
.
863741   982200    a        b       c

The code is as followed:

Dim myWS As Workspace
Dim myCn As Connection
Dim myRst As Recordset
Dim sqlStr As String

Set myWS = DBEngine.CreateWorkspace("MyWorkspace", "myUID", _
           "myPWD", dbUseODBC)
Set myCn = myWS.OpenConnection("MyConnection", dbDriverNoPrompt, _
           True, "ODBC;DATABASE=OraDB;UID=myUID;PWD=myPWD;DSN=myDSN")
sqlStr = "SELECT * FROM tblXY WHERE x BETWEEN 100000 AND 900000 " & _
         "AND y BETWEEN 100000 AND 900000"
Set myRst = myCn.OpenRecordset(sqlStr, dbOpenSnapshot) '<---- error here
myRst.MoveLast
.
.
.

When I open the recordset, I receive Error 3669: Execution cancelled.
The same sqlStr works fine for a smaller area. When it is over
10000x10000, it crashes with Error 3669.

The same error also occurs when I add more parametera to the SQL string.
e.g. "SELECT * FROM tblXY WHERE ... AND ... AND .... AND ... AND ..."

Is it an error with the code or there are limitations with ODBC and VB?

Here is a little information about the platform:

OS          : Windows NT 4.0 Sevice Pack 4 (with MSDAC 2.0 SP1)
RDBMS       : Oracle Server for Windows NT 7.3.4.0.0
ODBC Driver : Oracle73 Ver 2.5 (from Oracle)
SQL*Net     : 2.3
VB Reference: Microsoft DAO 3.51 Object Library

OS          : Windows NT 4.0 Sevice Pack 3
RDBMS       : Oracle Server for Windows NT 7.3.4.0.0
ODBC Driver : Oracle73 Ver 2.5 (from Oracle)
SQL*Net     : 2.3
VB Reference: Microsoft DAO 3.5 Object Library

Thanks,
---------------------------------------------------------------------------