ODBC Delete/Update problems

Thu, 16 Jan 2003 10:08:49 -0800

Hello-
We are trying to use SAPDB as a back-end to a desktop database product
called R:Base. We can connect to SABDB via ODBC. We can 'Insert'
records and perform 'Selects' on the data. When we try to delete or
update records, we get an error. Below is the error I am receiving.

-WARNING- The current row can no longer be accessed on the server. (1032)

I am not sure whether R:Base is causing this error, or whether SAPDB is
the problem. I looked through the list server archives, and noticed
that people have reported similar problems when connecting to SAPDB from
VB .NET. Is this a bug in the ODBC driver, or could this be a problem
caused by the MDAC layer or something to do with .NET?
I have included part of the log file generated by the SAPDB ODBC driver. This log was created by a delete operation.

Specs
Windows 2000 Pro SP3
MDAC 2.7
.NET Framework
SAPDB 7.4 beta
SAPDB ODBC 7.3
R:Base 6.5++ for Windows

Thanks!

Greg Miller
Event Imaging Solutions, Inc. - A Kodak Company
(800) 433-8596 x4028
(636) 980-4028



SELECT * FROM TBL_COM_SALES
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00000901 3C002C00 01000000
mfIndex init : 2
mfIndex init : 2
WARNING: W-------8-------
SQLRESULTNAME : SQL_CURSOR_0002
SQLERRD(INDEX_3) : -1
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

EXISTS TABLE "ADMIN"."TBL_COM_SALES"
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SELECT SCOPE=NUM(1), COLUMN_NAME='SYSKEY', DATA_TYPE=99, TYPE_NAME='CHAR',
PRECISION=NUM(8), "LENGTH"=NUM(8), SCALE=NULL, PSEUDO_COLUMN=NUM(2), CODETYPE=
'BYTE' FROM SYSDBA.DUAL WHERE NULL<>NULL
PARSE : CMD :
mfIndex init : 3
PARSEID: OUTPUT: 000001B2 00000C01 3C002C00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SELECT SCOPE=NUM(1), COLUMN_NAME='SYSKEY', DATA_TYPE=99, TYPE_NAME='CHAR',
PRECISION=NUM(8), "LENGTH"=NUM(8), SCALE=NULL, PSEUDO_COLUMN=NUM(2), CODETYPE=
'BYTE' FROM SYSDBA.DUAL WHERE NULL<>NULL
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00000C01 3C002C00 01000000
mfIndex init : 3
mfIndex init : 3
SQLCODE: 100 Row not found
SQLRESULTNAME : SQL_CURSOR_0003
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

CLOSE "SQL_CURSOR_0003"
PARSE : CMD :
PARSEID: OUTPUT: 000001B2 00000E01 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

CLOSE "SQL_CURSOR_0003"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00000E01 06002800 01000000
PARSEID: SELECT: 000001B2 00000C01 3C002C00 01000000
mfIndex init : 3
mfIndex restore : 3
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

PARSEID: DROP : 000001B2 00000E01 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SQCDROPPARSID
PARSEID: : 000001B2 00000E01 06002800 01000000
mfIndex delete : 3

PARSEID: DROP : 000001B2 00000C01 3C002C00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SQCDROPPARSID
PARSEID: : 000001B2 00000C01 3C002C00 01000000

EXISTS TABLE "ADMIN"."TBL_COM_SALES"
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SELECT SCOPE=NUM(1), COLUMN_NAME, DATA_TYPE, TYPE_NAME, PRECISION, LENGTH,
SCALE, PSEUDO_COLUMN=NUM(2), CODETYPE FROM SYSDBA.SYSODBCCOLUMNS WHERE KEY_SEQ
IS NOT NULL AND TABLE_OWNER = 'ADMIN' AND TABLE_NAME = 'TBL_COM_SALES'
PARSE : CMD :
mfIndex init : 3
PARSEID: OUTPUT: 000001B2 00001201 3C002C00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SELECT SCOPE=NUM(1), COLUMN_NAME, DATA_TYPE, TYPE_NAME, PRECISION, LENGTH,
SCALE, PSEUDO_COLUMN=NUM(2), CODETYPE FROM SYSDBA.SYSODBCCOLUMNS WHERE KEY_SEQ
IS NOT NULL AND TABLE_OWNER = 'ADMIN' AND TABLE_NAME = 'TBL_COM_SALES'
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001201 3C002C00 01000000
mfIndex init : 3
mfIndex init : 3
SQLRESULTNAME : SQL_CURSOR_0004
SQLERRD(INDEX_3) : 1
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

MASS STATEMENT :
FETCH "SQL_CURSOR_0004"
PARSE : CMD :
WARNING: W--3------------
PARSEID: OUTPUT: 000001B2 00001401 2A002B00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

MASS STATEMENT :
FETCH "SQL_CURSOR_0004"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001401 2A002B00 01000000
PARAMETER DESCRIPTION: 0X03B4B628
Application Kernel
Nr. Type Length Type Length Fraction
---------------------------------------------
1 0 2 0 1 0
2 7 129 2 32 0
3 0 2 0 2 0
4 7 129 2 10 0
5 1 4 0 4 0
6 1 4 0 4 0
7 0 2 0 3 0
8 0 2 0 1 0
9 7 9 2 8 0
OUTPUT : 1: SCOPE : 1
OUTPUT : 2: COLUMN_NAME : LOCNO
OUTPUT : 3: DATA_TYPE : 99
OUTPUT : 4: TYPE_NAME : INTEGER
OUTPUT : 5: PRECISION : 10
OUTPUT : 6: LENGTH : 4
OUTPUT : 7: SCALE : 0
OUTPUT : 8: PSEUDO_COLUMN : 2
OUTPUT : 9: CODETYPE :
SQLERRD(INDEX_3) : 1
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

MASS STATEMENT :
FETCH "SQL_CURSOR_0004"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001401 2A002B00 01000000
SQLCODE: 100 Row not found
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

CLOSE "SQL_CURSOR_0004"
PARSE : CMD :
PARSEID: OUTPUT: 000001B2 00001501 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

CLOSE "SQL_CURSOR_0004"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001501 06002800 01000000
PARSEID: SELECT: 000001B2 00001201 3C002C00 01000000
mfIndex init : 3
mfIndex restore : 3
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

PARSEID: DROP : 000001B2 00001401 2A002B00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SQCDROPPARSID
PARSEID: : 000001B2 00001401 2A002B00 01000000

PARSEID: DROP : 000001B2 00001501 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SQCDROPPARSID
PARSEID: : 000001B2 00001501 06002800 01000000
mfIndex delete : 3

PARSEID: DROP : 000001B2 00001201 3C002C00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SQCDROPPARSID
PARSEID: : 000001B2 00001201 3C002C00 01000000

CLOSE "SQL_CURSOR_0002"
PARSE : CMD :
PARSEID: OUTPUT: 000001B2 00001901 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

CLOSE "SQL_CURSOR_0002"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001901 06002800 01000000
PARSEID: SELECT: 000001B2 00000901 3C002C00 01000000
mfIndex init : 2
mfIndex restore : 2
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

PARSEID: DROP : 000001B2 00001901 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SQCDROPPARSID
PARSEID: : 000001B2 00001901 06002800 01000000
mfIndex delete : 2

PARSEID: DROP : 000001B2 00000901 3C002C00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:23
END : DATE : 2003-01-15 TIME : 0010:36:23

SQCDROPPARSID
PARSEID: : 000001B2 00000901 3C002C00 01000000

SELECT "LOCNO","SALES_AMT","COM_TYPE" FROM "TBL_COM_SALES" FOR UPDATE OF
PARSE : CMD :
mfIndex init : 2
PARSEID: OUTPUT: 000001B2 00001C01 3C002D00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

SELECT "LOCNO","SALES_AMT","COM_TYPE" FROM "TBL_COM_SALES" FOR UPDATE OF
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001C01 3C002D00 01000000
mfIndex init : 2
mfIndex init : 2
WARNING: W-------8-------
SQLRESULTNAME : SQL_CURSOR_0005
SQLERRD(INDEX_3) : -1
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

FETCH "SQL_CURSOR_0005"
PARSE : CMD :
WARNING: W--3------------
PARSEID: OUTPUT: 000001B2 00001E01 1C002A00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

FETCH "SQL_CURSOR_0005"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001E01 1C002A00 01000000
PARAMETER DESCRIPTION: 0X0390E338
Application Kernel
Nr. Type Length Type Length Fraction
---------------------------------------------
1 1 4 30 10 0
2 7 17 0 14 2
3 7 2 2 1 0
OUTPUT : 1: LOCNO : 200
OUTPUT : 2: SALES_AMT : 40000.00
OUTPUT : 3: COM_TYPE : I
SQLERRD(INDEX_3) : 1
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

SELECT COUNT(*) FROM "TBL_COM_SALES" WHERE "LOCNO" = 200
PARSE : CMD :
mfIndex init : 3
PARSEID: OUTPUT: 000001B2 00001F01 3C002E00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

SELECT COUNT(*) FROM "TBL_COM_SALES" WHERE "LOCNO" = 200
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00001F01 3C002E00 01000000
mfIndex init : 3
mfIndex init : 3
SQLRESULTNAME : SQL_CURSOR_0006
SQLERRD(INDEX_3) : 1
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

MASS STATEMENT :
FETCH "SQL_CURSOR_0006"
PARSE : CMD :
WARNING: W--3------------
PARSEID: OUTPUT: 000001B2 00002101 2A002B00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

MASS STATEMENT :
FETCH "SQL_CURSOR_0006"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00002101 2A002B00 01000000
PARAMETER DESCRIPTION: 0X03B4B628
Application Kernel
Nr. Type Length Type Length Fraction
---------------------------------------------
1 7 13 0 10 0
OUTPUT : 1: EXPRESSION1 : 1
SQLERRD(INDEX_3) : 1
START : DATE : 2003-01-15 TIME : 0010:36:31
END : DATE : 2003-01-15 TIME : 0010:36:31

CLOSE "SQL_CURSOR_0006"
PARSE : CMD :
PARSEID: OUTPUT: 000001B2 00002201 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

CLOSE "SQL_CURSOR_0006"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00002201 06002800 01000000
PARSEID: SELECT: 000001B2 00001F01 3C002E00 01000000
mfIndex init : 3
mfIndex restore : 3
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

PARSEID: DROP : 000001B2 00002101 2A002B00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

SQCDROPPARSID
PARSEID: : 000001B2 00002101 2A002B00 01000000

PARSEID: DROP : 000001B2 00002201 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

SQCDROPPARSID
PARSEID: : 000001B2 00002201 06002800 01000000
mfIndex delete : 3

PARSEID: DROP : 000001B2 00001F01 3C002E00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

SQCDROPPARSID
PARSEID: : 000001B2 00001F01 3C002E00 01000000

CLOSE "SQL_CURSOR_0005"
PARSE : CMD :
PARSEID: OUTPUT: 000001B2 00002601 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

CLOSE "SQL_CURSOR_0005"
EXECUTE: CMD :
PARSEID: INPUT : 000001B2 00002601 06002800 01000000
PARSEID: SELECT: 000001B2 00001C01 3C002D00 01000000
mfIndex init : 2
mfIndex restore : 2
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

PARSEID: DROP : 000001B2 00001E01 1C002A00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

SQCDROPPARSID
PARSEID: : 000001B2 00001E01 1C002A00 01000000

PARSEID: DROP : 000001B2 00002601 06002800 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

SQCDROPPARSID
PARSEID: : 000001B2 00002601 06002800 01000000
mfIndex delete : 2

PARSEID: DROP : 000001B2 00001C01 3C002D00 01000000
START : DATE : 2003-01-15 TIME : 0010:36:32
END : DATE : 2003-01-15 TIME : 0010:36:32

SQCDROPPARSID
PARSEID: : 000001B2 00001C01 3C002D00 01000000

S1: DISCONNECT

SQCFINISH




_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to