Error 3669: Execution cancelled!

Error 3669: Execution cancelled!

Post by SeeQuel » Wed, 12 Jul 2000 04:00:00



I get the following error when myself (or my clients) connect to a SQL
Server 6.5 server with the application I am developing.

Does anyone know why?

 
 
 

1. Error 3669: Execution cancelled.

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,
---------------------------------------------------------------------------

2. On key label help

3. Error 3669 execution cancelled

4. Change of Logging Status: Implications?

5. What is Error 3669: Execution Cancelled ?

6. Query failure across linked server

7. Error 3669 execution cancelled

8. URGENT REQUEST!!

9. Error '3669' Execution Cancelled

10. Run time error 3669. Execution cancelled

11. Run time Error '3669' Execution cancelled

12. 3669 Execution cancelled

13. Execution cancelled 3669?