on 03-11-2009 2:35 PM
Hello
I migrate my database from 7.6 version to the last version 7.7.
I have the following issue when I execute request containing TIMESTAMP.
My request is like "select Msn,conv_date_time from DBM350_SM"
Msn is an integer and conv_date_time a time stamp
I use the Row-wise biding and SQLBindCol to retrieve information.
The SQLFetchScroll return -1 with error
szErrorMsg = "[SAP AG][SDBODBC DLL][MaxDB] General error;-10413 Illegal TIMESTAMP value for parameter/column (2)"
I have the same issue with Microsoft test program ODBCT32W.exe
Here is the ODBC dialog ...
Any help will be appreciated ....
Yann.
[11/03/2009 15:19:24.468]EskTrace{6600,7104} ENTER SQLExecDirectW (11) 12048
HSTMT 0x003c2f10
WCHAR * 0x0015f5c8 [ -3] "select Msn,conv_date_time from DBM350_SM\ 0"
SDWORD -3
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:24.468]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:24.468]EskTrace{6600,7104} EXIT SQLExecDirectW (11) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
WCHAR * 0x0015f5c8 [ -3] "select Msn,conv_date_time from DBM350_SM\ 0"
SDWORD -3
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLFreeStmt (16) 12048
HSTMT 0x003c2f10
UWORD 2 <SQL_UNBIND>
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLFreeStmt (16) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2 <SQL_UNBIND>
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLNumResultCols (18) 12048
HSTMT 0x003c2f10
SWORD * 0x0012f458
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLNumResultCols (18) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
SWORD * 0x0012f458 (2)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLGetInfoW (45) 11832
HDBC 0x003c2e38
UWORD 7 <SQL_DRIVER_VER>
PTR 0x0012f46c
SWORD 20
SWORD * 0x0012f44a
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLGetInfoW (45) 11832 with return code 0 (SQL_SUCCESS)
HDBC 0x003c2e38
UWORD 7 <SQL_DRIVER_VER>
PTR 0x0012f46c [ 18] "7.7.06.09"
SWORD 20
SWORD * 0x0012f44a (18)
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLColAttributesW (6) 12048
HSTMT 0x003c2f10
UWORD 1
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLColAttributesW (6) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 1
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLDescribeColW (8) 12048
HSTMT 0x003c2f10
UWORD 1
WCHAR * 0x00000000
SWORD 1
SWORD * 0x00000000
SWORD * 0x0012f468
UDWORD * 0x0012f450
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLDescribeColW (8) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 1
WCHAR * 0x00000000
SWORD 1
SWORD * 0x00000000
SWORD * 0x0012f468 (4)
UDWORD * 0x0012f450 (10)
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLBindCol (4) 12048
HSTMT 0x003c2f10
UWORD 1
SWORD -16 <SQL_C_SLONG>
PTR 0x00d60000
SDWORD 4
SDWORD * 0x00d40000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLBindCol (4) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 1
SWORD -16 <SQL_C_SLONG>
PTR 0x00d60000
SDWORD 4
SDWORD * 0x00d40000 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} ENTER SQLColAttributesW (6) 12048
HSTMT 0x003c2f10
UWORD 2
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.749]EskTrace{6600,7104} EXIT SQLColAttributesW (6) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} ENTER SQLDescribeColW (8) 12048
HSTMT 0x003c2f10
UWORD 2
WCHAR * 0x00000000
SWORD 2
SWORD * 0x00000000
SWORD * 0x0012f468
UDWORD * 0x0012f450
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.749]EskTrace{6600,7104} EXIT SQLDescribeColW (8) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
WCHAR * 0x00000000
SWORD 2
SWORD * 0x00000000
SWORD * 0x0012f468 (11)
UDWORD * 0x0012f450 (26)
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} ENTER SQLBindCol (4) 12048
HSTMT 0x003c2f10
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR 0x00da0000
SDWORD 16
SDWORD * 0x00d80000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.749]EskTrace{6600,7104} EXIT SQLBindCol (4) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR 0x00da0000
SDWORD 16
SDWORD * 0x00d80000 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.780]EskTrace{6600,7104} ENTER SQLExtendedFetch (59) 12048
HSTMT 0x003c2f10
UWORD 1 <SQL_FETCH_NEXT>
SDWORD 1
UDWORD * 0x0012f378
UWORD * 0x00162150
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.780]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.780]EskTrace{6600,7104} EXIT SQLExtendedFetch (59) 12048 with return code -1 (SQL_ERROR)
HSTMT 0x003c2f10
UWORD 1 <SQL_FETCH_NEXT>
SDWORD 1
UDWORD * 0x0012f378
UWORD * 0x00162150
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.780]EskTrace{6600,7104} ENTER SQLGetDiagRecW (1011) 3
SQLSMALLINT 3
SQLHANDLE 0x003c2f10
SQLSMALLINT 1
SQLWCHAR * 0x0012bca4 (NYI)
SQLINTEGER * 0x0012bd2c
SQLWCHAR * 0x003c3440 (NYI)
SQLSMALLINT 2000
SQLSMALLINT * 0x0012bc90
[11/03/2009 15:19:26.780]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 1
[11/03/2009 15:19:26.780]EskTrace{6600,7104} EXIT SQLGetDiagRecW (1011) 3 with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 0x003c2f10
SQLSMALLINT 1
SQLWCHAR * 0x0012bca4 (NYI)
SQLINTEGER * 0x0012bd2c (-10413)
SQLWCHAR * 0x003c3440 (NYI)
SQLSMALLINT 2000
SQLSMALLINT * 0x0012bc90 (98)
[11/03/2009 15:19:26.780]EskTrace{6600,7104}
DIAG [S1000] [SAP AG][SDBODBC DLL][MaxDB] General error;-10413 Illegal TIMESTAMP value for parameter/column (2) (-10413)
Hello,
I have the issue on the 32 bits MAXDB 7.7 version.
To reproduce the issue I create a table with a timestamp field.
and try to request the field with my code and it does not work.
You can reproduce with an Microsoft tools called ODBCtst32.exe.
I send to thomas the tools and screenshot to reproduce the issue.
Regards.
Yann.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I read something similar on [this other thread of the forum|]. Are you in SQLMODE internal or Oracle ?
This may also be related to the parameter DATE_TIME_FORMAT. ODBC timestamp format is ISO. Does it work if you set DATE_TIME_FORMAT to ISO ?
You could also test on a fresh 7.7 database (i.e. not migrated from a 7.6 like the one you are using).
Hello
I tried to reproduce the problem on my site but failed. I.e. rowwise binding with SQL_C_TYPE_TIMESTAMP works as it should.
If you send me an Em ail (see my profile), I will send you the test I used. Probably you can see, what in my test seems to be different to your situation.
Regards Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Do you have any idea why it's not possible to bind TimeStamp column with the odbc driver (SDBODBCW.DLL).
Select statement does not works with TIMEStamp columns if the content is not null on every table.
The only workaround, I find, is to replace COLNAME, substring(<COLNAME>, 1, 23).
I try with my own program that works on SAPDB7.4, MAXDB7.6, SQL SERVER, POSTGRE ....
I try with other program like ODBCTST32.exe (microsoft) and it does not works.
To reproduce, Create a table with a TimeStamp column. Insert line with a value in the time stamp. Try to request the column with unicode ODBC driver.
Yann.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
and the more important
SQLExecDirect 2009-03-13 11:15:19.943000
StatementHandle [in] : 10F35C60
StatementText [in] : 'CREATE TABLE DBM350_SM (ArchiveExpiration DATE, CancelRequestDateTime TIMESTAMP, RcpCompany VARCHAR(50) UNICODE, RcpName VARCHAR\
(50) UNICODE, IDX_RcpName VARCHAR(50) UNICODE, SndAccount VARCHAR(40) UNICODE, SndCompany VARCHAR(50) UNICODE, SndName VARCHAR(5\
0) UNICODE, Sub_date_time TIMESTAMP, Acc_date_time TIMESTAMP, SendDateTime TIMESTAMP, Conv_date_time TIMESTAMP, Comp_date_time T\
IMESTAMP, Call_Cost INTEGER, TotalCallCost INTEGER, Valid_date_time TIMESTAMP, Lstry_date_time TIMESTAMP, Ntry_date_time TIMESTA\
MP, Deferred SMALLINT, DIST_LASTWRITE TIMESTAMP, DIST_NUM INTEGER, DIST_VERSION INTEGER, DIST_OWNER CHAR(64) UNICODE, DIST_OWNER\
_DATE_TIME TIMESTAMP, DIST_ABORTED INTEGER, DIST_ABORTEDCOUNT INTEGER, ContFlag INTEGER, StatusCode INTEGER, PreviewMessage INTE\
GER, PreviewVisible INTEGER, Status_str VARCHAR(100) UNICODE, Max_Rtry INTEGER, N_Tries INTEGER, Msn INTEGER NOT NULL PRIMARY KE\
Y, ArchiveDuration INTEGER, AppName VARCHAR(50) UNICODE, IDX_AppName VARCHAR(50) UNICODE, EstimPrice FLOAT(38), EstimPriceUnit V\
ARCHAR(3) UNICODE, RealPrice FLOAT(38), RealPriceUnit VARCHAR(3) UNICODE, ContractID VARCHAR(40) UNICODE, MainAccountID VARCHAR(\
20) UNICODE, ProcessingLabel VARCHAR(6) UNICODE, Viewed SMALLINT, Notif SMALLINT, NotifIndex INTEGER, Purged INTEGER, ArcMsn INT\
EGER, ArcState INTEGER, ArcSavFile VARCHAR(30) UNICODE, PrgF_date_time TIMESTAMP, PrgR_date_time TIMESTAMP, RemoteMsn INTEGER, D\
elegatedSend INTEGER, Delegated INTEGER, DelegatedCancelled INTEGER, DelegationSyncID VARCHAR(28) UNICODE, RemoteNetworkLocation\
VARCHAR(128) UNICODE, RemoteNetworkPort INTEGER, RemoteNetworkProtocol VARCHAR(5) UNICODE, NeedValid SMALLINT, Vld_date_time TI\
MESTAMP, Valid_OwnerID VARCHAR(128) UNICODE, ValidationState INTEGER, PreferredValid_OwnerID VARCHAR(128) UNICODE, OwnerID VARCH\
AR(120) UNICODE, IDX_OwnerID VARCHAR(120) UNICODE, OwnerPB VARCHAR(50) UNICODE, SrcRUID VARCHAR(24) UNICODE, OriginalJobID VARCH\
AR(12) UNICODE, ResultFlowid VARCHAR(12) UNICODE, WorkflowID VARCHAR(32) UNICODE, UserComment VARCHAR(50) UNICODE, N_Pages INTEG\
ER, Pages_Produced INTEGER, Pages_Sent INTEGER, GroupKey VARCHAR(32) UNICODE, IsBillable VARCHAR(1) UNICODE, RetrievedByClient V\
ARCHAR(1) UNICODE, IDX_RetrievedByClient VARCHAR(1) UNICODE, State INTEGER, Def_date_time TIMESTAMP, Ident VARCHAR(120) UNICODE,\
IDX_Ident VARCHAR(120) UNICODE, Priority INTEGER DEFAULT 0, EmailTracking SMALLINT, OpeningDateTime TIMESTAMP, NbOpeningTime IN\
TEGER, LastOpeningDateTime TIMESTAMP, EnableAntiSpam SMALLINT, RcpAddress VARCHAR(120) UNICODE, IDX_RcpAddress VARCHAR(120) UNIC\
ODE, Subject VARCHAR(120) UNICODE, IDX_Subject VARCHAR(120) UNICODE, SndAddress VARCHAR(120) UNICODE, SndType VARCHAR(20) UNICOD\
E, OptOut SMALLINT, Docid VARCHAR(12) UNICODE, Deleted SMALLINT, Department VARCHAR(120) UNICODE, Flowid VARCHAR(12) UNICODE, SA\
TID VARCHAR(40) UNICODE, LBServer VARCHAR(40) UNICODE, DIST_FILE LONG BYTE)'
TextLength [in] : 2891
enc : UCS2 big endian (native)
::EXECUTE DBS WITH COMMIT 'SQLCURS_2' 2009-03-13 11:15:19.943000 [0x10F39E38]
SQL COMMAND : 'CREATE TABLE DBM350_SM (ArchiveExpiration DATE, CancelRequestDateTime TIMESTAMP, RcpCompany VARCHAR(50) UNICODE, RcpName VARCHAR\
(50) UNICODE, IDX_RcpName VARCHAR(50) UNICODE, SndAccount VARCHAR(40) UNICODE, SndCompany VARCHAR(50) UNICODE, SndName VARCHAR(5\
0) UNICODE, Sub_date_time TIMESTAMP, Acc_date_time TIMESTAMP, SendDateTime TIMESTAMP, Conv_date_time TIMESTAMP, Comp_date_time T\
IMESTAMP, Call_Cost INTEGER, TotalCallCost INTEGER, Valid_date_time TIMESTAMP, Lstry_date_time TIMESTAMP, Ntry_date_time TIMESTA\
MP, Deferred SMALLINT, DIST_LASTWRITE TIMESTAMP, DIST_NUM INTEGER, DIST_VERSION INTEGER, DIST_OWNER CHAR(64) UNICODE, DIST_OWNER\
_DATE_TIME TIMESTAMP, DIST_ABORTED INTEGER, DIST_ABORTEDCOUNT INTEGER, ContFlag INTEGER, StatusCode INTEGER, PreviewMessage INTE\
GER, PreviewVisible INTEGER, Status_str VARCHAR(100) UNICODE, Max_Rtry INTEGER, N_Tries INTEGER, Msn INTEGER NOT NULL PRIMARY KE\
Y, ArchiveDuration INTEGER, AppName VARCHAR(50) UNICODE, IDX_AppName VARCHAR(50) UNICODE, EstimPrice FLOAT(38), EstimPriceUnit V\
ARCHAR(3) UNICODE, RealPrice FLOAT(38), RealPriceUnit VARCHAR(3) UNICODE, ContractID VARCHAR(40) UNICODE, MainAccountID VARCHAR(\
20) UNICODE, ProcessingLabel VARCHAR(6) UNICODE, Viewed SMALLINT, Notif SMALLINT, NotifIndex INTEGER, Purged INTEGER, ArcMsn INT\
EGER, ArcState INTEGER, ArcSavFile VARCHAR(30) UNICODE, PrgF_date_time TIMESTAMP, PrgR_date_time TIMESTAMP, RemoteMsn INTEGER, D\
elegatedSend INTEGER, Delegated INTEGER, DelegatedCancelled INTEGER, DelegationSyncID VARCHAR(28) UNICODE, RemoteNetworkLocation\
VARCHAR(128) UNICODE, RemoteNetworkPort INTEGER, RemoteNetworkProtocol VARCHAR(5) UNICODE, NeedValid SMALLINT, Vld_date_time TI\
MESTAMP, Valid_OwnerID VARCHAR(128) UNICODE, ValidationState INTEGER, PreferredValid_OwnerID VARCHAR(128) UNICODE, OwnerID VARCH\
AR(120) UNICODE, IDX_OwnerID VARCHAR(120) UNICODE, OwnerPB VARCHAR(50) UNICODE, SrcRUID VARCHAR(24) UNICODE, OriginalJobID VARCH\
AR(12) UNICODE, ResultFlowid VARCHAR(12) UNICODE, WorkflowID VARCHAR(32) UNICODE, UserComment VARCHAR(50) UNICODE, N_Pages INTEG\
ER, Pages_Produced INTEGER, Pages_Sent INTEGER, GroupKey VARCHAR(32) UNICODE, IsBillable VARCHAR(1) UNICODE, RetrievedByClient V\
ARCHAR(1) UNICODE, IDX_RetrievedByClient VARCHAR(1) UNICODE, State INTEGER, Def_date_time TIMESTAMP, Ident VARCHAR(120) UNICODE,\
IDX_Ident VARCHAR(120) UNICODE, Priority INTEGER DEFAULT 0, EmailTracking SMALLINT, OpeningDateTime TIMESTAMP, NbOpeningTime IN\
TEGER, LastOpeningDateTime TIMESTAMP, EnableAntiSpam SMALLINT, RcpAddress VARCHAR(120) UNICODE, IDX_RcpAddress VARCHAR(120) UNIC\
ODE, Subject VARCHAR(120) UNICODE, IDX_Subject VARCHAR(120) UNICODE, SndAddress VARCHAR(120) UNICODE, SndType VARCHAR(20) UNICOD\
E, OptOut SMALLINT, Docid VARCHAR(12) UNICODE, Deleted SMALLINT, Department VARCHAR(120) UNICODE, Flowid VARCHAR(12) UNICODE, SA\
TID VARCHAR(40) UNICODE, LBServer VARCHAR(40) UNICODE, DIST_FILE LONG BYTE)'
ENCODING : UCS2 big endian (native)
SQL ERROR :
CODE : -6000
SQLSTATE : I6000
MESSAGE : POS(14) Duplicate table name:DBM350_SM
SQL ERROR :
CODE : -6000
SQLSTATE : I6000
MESSAGE : POS(14) Duplicate table name:DBM350_SM
SQLRETURN : SQL_ERROR
SQLGetDiagField 2009-03-13 11:15:19.958000
HandleType [in] : SQL_HANDLE_STMT
Handle [in] : 10F35C60
RecNumber [in] : 1
DiagIdentifier [in] : SQL_DIAG_SQLSTATE
BufferLength [in] : 12
enc : UCS2 big endian (native)
DiagInfoPtr [out] : S0001
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLGetDiagField 2009-03-13 11:15:19.958000
HandleType [in] : SQL_HANDLE_STMT
Handle [in] : 10F35C60
RecNumber [in] : 2
DiagIdentifier [in] : SQL_DIAG_SQLSTATE
BufferLength [in] : 12
enc : UCS2 big endian (native)
SQLRETURN : SQL_NO_DATA
SQLGetDiagRec 2009-03-13 11:15:19.958000
HandleType [in] : SQL_HANDLE_STMT
Handle [in] : 10F35C60
RecNumber [in] : 1
BufferLength [in] : 2000
enc : UCS2 big endian (native)
SQLState [out] : S0001
NativeErrorPtr [out] : -6000
MessageText [out] : [SAP AG][SDBODBC DLL][MaxDB] Base table or view already exists;-6000 POS(14) Duplicate table name:DBM350_SM
TextLengthPtr [out] : 107
SQLRETURN : SQL_SUCCESS
SQLGetDiagRec 2009-03-13 11:15:19.958000
HandleType [in] : SQL_HANDLE_STMT
Handle [in] : 10F35C60
RecNumber [in] : 2
BufferLength [in] : 2000
enc : UCS2 big endian (native)
SQLRETURN : SQL_NO_DATA
SQLGetDiagRec 2009-03-13 11:15:19.958000
HandleType [in] : SQL_HANDLE_STMT
Handle [in] : 10F35C60
RecNumber [in] : 1
BufferLength [in] : 4096
enc : UCS2 big endian (native)
SQLState [out] : S0001
NativeErrorPtr [out] : -6000
MessageText [out] : [SAP AG][SDBODBC DLL][MaxDB] Base table or view already exists;-6000 POS(14) Duplicate table name:DBM350_SM
TextLengthPtr [out] : 107
SQLRETURN : SQL_SUCCESS
SQLFreeHandle 2009-03-13 11:15:19.958000
HandleType [in] : SQL_HANDLE_STMT
Handle [in] : 10F35C60
SQLRETURN : SQL_SUCCESS
SQLAllocHandle 2009-03-13 11:15:19.958000
HandleType [in] : SQL_HANDLE_STMT
InputHandle [in] : 10F381B2
OutputHandlePtr [out] : &(10F35C60)
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:19.958000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_APP_ROW_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB2348
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:19.958000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_APP_PARAM_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB23D4
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:19.958000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_IMP_ROW_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB2460
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:19.958000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_IMP_PARAM_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB24EC
SQLRETURN : SQL_SUCCESS
SQLSetStmtAttr 2009-03-13 11:15:19.958000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_CURSOR_TYPE
StringLength [in] : SQL_IS_INTEGER
ValuePtr [in] : SQL_CURSOR_DYNAMIC
SQLRETURN : SQL_SUCCESS
SQLSetStmtAttr 2009-03-13 11:15:19.974000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_QUERY_TIMEOUT
StringLength [in] : SQL_IS_UINTEGER
ValuePtr [in] : 900
SQLRETURN : SQL_SUCCESS
SQLPrepare 2009-03-13 11:15:19.974000
StatementHandle [in] : 10F35C60
StatementText [in] : 'SELECT Msn, Ntry_date_time, Priority, DIST_ABORTED, DIST_ABORTEDCOUNT, DIST_OWNER, DIST_NUM, DIST_VERSION FROM DBM350_SM WHERE (\
Msn = 577075) WITH LOCK ISOLATION LEVEL 0'
TextLength [in] : 169
enc : UCS2 big endian (native)
::PARSE 'SQLCURS_2' 2009-03-13 11:15:19.974000 [0x1248FE90]
SQL COMMAND:'SELECT Msn, Ntry_date_time, Priority, DIST_ABORTED, DIST_ABORTEDCOUNT, DIST_OWNER, DIST_NUM, DIST_VERSION FROM DBM350_SM WHERE (\
Msn = 577075) WITH LOCK ISOLATION LEVEL 0'
ENCODING : UCS2 big endian (native)
PARSE ID: 00039D8D 00000901 54002C00 [1]
COLUMNS:
I T L P I N
1 INTEGER 10 0 1 7 'MSN'
2 TIMESTAMP 26 0 8 53 'NTRY_DATE_TIME'
3 INTEGER 10 0 61 7 'PRIORITY'
4 INTEGER 10 0 68 7 'DIST_ABORTED'
5 INTEGER 10 0 75 7 'DIST_ABORTEDCOUNT'
6 CHAR UNICODE 64 0 82 129 'DIST_OWNER'
7 INTEGER 10 0 211 7 'DIST_NUM'
8 INTEGER 10 0 218 7 'DIST_VERSION'
::GET RESULT SET [0x1248FE90]
CURSOR NAME: 'SQLCURS_2' [0x(null)]
::GET RESULT SET [0x1248FE90]
CURSOR NAME: 'SQLCURS_2' [0x(null)]
SQLRETURN : SQL_SUCCESS
SQLExecute 2009-03-13 11:15:22.207000
StatementHandle [in] : 10F35C60
::EXECUTE WITH COMMIT 'SQLCURS_2' 2009-03-13 11:15:22.207000 [0x1248FE90]
PARSE ID: 00039D8D 00000901 54002C00 [1]
SQL COMMAND: 'SELECT Msn, Ntry_date_time, Priority, DIST_ABORTED, DIST_ABORTEDCOUNT, DIST_OWNER, DIST_NUM, DIST_VERSION FROM DBM350_SM WHERE (\
Msn = 577075) WITH LOCK ISOLATION LEVEL 0'
ENCODING : UCS2 big endian (native)
RESULT COUNT: -1
CURSOR NAME: 'SQLCURS_2'
SQLRETURN : SQL_SUCCESS
SQLSetStmtAttr 2009-03-13 11:15:23.707000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_ROW_BIND_TYPE
StringLength [in] : SQL_IS_UINTEGER
ValuePtr [in] : 204
SQLRETURN : SQL_SUCCESS
SQLBindCol 2009-03-13 11:15:23.707000
StatementHandle [in] : 10F35C60
ColumnNumber [in] : 1
TargetType [in] : SQL_C_LONG
TargetValue [in/out]: 00000008
BufferLength [in] : 4
SQLFreeHandle 2009-03-13 11:15:43.573000
HandleType [in] : SQL_HANDLE_STMT
Handle [in] : 10F35C60
SQLRETURN : SQL_SUCCESS
SQLDisconnect 2009-03-13 11:15:46.775000
ConnectionHandle [in] : 10F30B86
::COMMIT 2009-03-13 11:15:46.775000 [0x10F34838]
::EXECUTE DBS WITH COMMIT 'SQLCURS_1' 2009-03-13 11:15:46.775000 [0x10F36008]
SQL COMMAND : 'COMMIT'
SQLRETURN : SQL_SUCCESS
SQLFreeHandle 2009-03-13 11:15:46.791000
HandleType [in] : SQL_HANDLE_DBC
Handle [in] : 10F30B86
::RELEASE CONNECTION 2009-03-13 11:15:46.791000 [0x10F34838]
SQLRETURN : SQL_SUCCESS
SQLDisconnect 2009-03-13 11:15:46.791000
ConnectionHandle [in] : 10F381B2
::COMMIT 2009-03-13 11:15:46.791000 [0x10F324F0]
::EXECUTE DBS WITH COMMIT 'SQLCURS_1' 2009-03-13 11:15:46.791000 [0x10F32D98]
SQL COMMAND : 'COMMIT'
SQLRETURN : SQL_SUCCESS
SQLFreeHandle 2009-03-13 11:15:46.791000
HandleType [in] : SQL_HANDLE_DBC
Handle [in] : 10F381B2
::RELEASE CONNECTION 2009-03-13 11:15:46.791000 [0x10F324F0]
SQLRETURN : SQL_SUCCESS
SQLFreeHandle 2009-03-13 11:15:46.791000
HandleType [in] : SQL_HANDLE_ENV
Handle [in] : 10F31E8D
SQLRETURN : SQL_SUCCESS
<CURRENT WRITE POSITION>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here are traces
SQLAllocHandle 2009-03-13 11:15:08.635000
HandleType [in] : SQL_HANDLE_ENV
InputHandle [in] : (null)
OutputHandlePtr [out] : &(10F31E8D)
SQLRETURN : SQL_SUCCESS
SQLSetEnvAttr 2009-03-13 11:15:08.635000
EnvironmentHandle[in] : 10F31E8D
Attribute [in] : SQL_ATTR_ODBC_VERSION
ValuePtr [in] : SQL_OV_ODBC3
StringLength [in] : 0
SQLRETURN : SQL_SUCCESS
SQLAllocHandle 2009-03-13 11:15:08.635000
HandleType [in] : SQL_HANDLE_DBC
InputHandle [in] : 10F31E8D
OutputHandlePtr [out] : &(10F381B2)
SQLRETURN : SQL_SUCCESS
SQLGetInfo 2009-03-13 11:15:08.635000
ConnectionHandle [in] : 10F381B2
InfoType [in] : SQL_DRIVER_ODBC_VER
BufferLength [in] : 12
enc : UCS2 big endian (native)
InfoValuePtr [out] : 03.51
StringLengthPtr [out] : 10
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:08.635000
ConnectionHandle [in] : 10F381B2
Attribute [in] : unknown ConnAttr:115
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
SQLRETURN : SQL_ERROR
SQLGetInfo 2009-03-13 11:15:08.635000
ConnectionHandle [in] : 10F381B2
InfoType [in] : SQL_MAX_CONCURRENT_ACTIVITIES
BufferLength [in] : 2
enc : UCS2 big endian (native)
InfoValuePtr [out] : 32767
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:08.635000
ConnectionHandle [in] : 10F381B2
Attribute [in] : SQL_ATTR_LOGIN_TIMEOUT
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
ValuePtr [in] : 60
SQLRETURN : SQL_SUCCESS
SQLDriverConnect 2009-03-13 11:15:08.635000
ConnectionHandle [in] : 10F381B2
WindowHandle [in] : (null)
InConnectionStr [in] : DRIVER={MaxDB (Unicode)};SERVERDB=EDP350;SERVERNODE=127.0.0.1;
::CONNECT 2009-03-13 11:15:08.635000 [0x10F324F0]
SERVERNODE: '127.0.0.1'
SERVERDB : 'EDP350'
USER : 'ESKDBADM'
CONNECT PROPERTIES: (9)
KEY: 'TRANSLATE_BINARY_AS_ENCODED' VALUE: '1'
KEY: 'ODBC_BIN2HEX' VALUE: '1'
KEY: 'ODBC_NUMBER_TRUNCATION' VALUE: '1'
KEY: 'CODEPAGENAME' VALUE: 'WINDOWS-1252'
KEY: 'DEFAULTMAPCHAR' VALUE: '?'
KEY: 'SQLMODE' VALUE: 'INTERNAL'
KEY: 'CHOPBLANKS' VALUE: '1'
KEY: 'COMPONENT' VALUE: 'ODB'
KEY: 'ISOLATIONLEVEL' VALUE: '1'
CONNECT COMMAND: 'CONNECT ? IDENTIFIED BY ? SQLMODE INTERNAL ISOLATION LEVEL 1'
SESSION ID: 1
CHOP TRAILING BLANKS ON INPUT DISABLED
VARIABLE INPUT DISABLED
SCROLLABLE CURSORS DISABLED
INTERNAL FORMAT FOR DATE/TIME I/O ENABLED
EXTENDED LOB LOCATOR FUNCTIONALITY ENABLED
OK
::SET AUTOCOMMIT ON 2009-03-13 11:15:09.025000 [0x10F324F0]
OutConnectionStr [out] : SERVERNODE=127.0.0.1;SERVERDB=EDP350;DRIVER={MaxDB (Unicode)};SERVERDB=EDP350;SERVERNODE=127.0.0.1;UID=ESKDBADM;
BufferLength [in] : 1024
DriverCompletion [in] : SQL_DRIVER_NOPROMPT
enc : UCS2 big endian (native)
SQLRETURN : SQL_SUCCESS
SQLGetDiagRec 2009-03-13 11:15:09.025000
HandleType [in] : SQL_HANDLE_DBC
Handle [in] : 10F381B2
RecNumber [in] : 1
BufferLength [in] : 0
enc : UCS2 big endian (native)
SQLRETURN : SQL_NO_DATA
SQLGetFunctions 2009-03-13 11:15:09.025000
ConnectionHandle [in] : 10F381B2
FunctionId [in] : SQL_API_ODBC3_ALL_FUNCTIONS
SupportedPtr [out] : 65535
SQLRETURN : SQL_SUCCESS
SQLGetInfo 2009-03-13 11:15:09.025000
ConnectionHandle [in] : 10F381B2
InfoType [in] : SQL_CURSOR_COMMIT_BEHAVIOR
BufferLength [in] : 2
enc : UCS2 big endian (native)
InfoValuePtr [out] : SQL_CC_PRESERVE
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLGetInfo 2009-03-13 11:15:09.025000
ConnectionHandle [in] : 10F381B2
InfoType [in] : SQL_CURSOR_ROLLBACK_BEHAVIOR
BufferLength [in] : 2
enc : UCS2 big endian (native)
InfoValuePtr [out] : SQL_CC_CLOSE
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:09.025000
ConnectionHandle [in] : 10F381B2
Attribute [in] : SQL_ATTR_AUTOCOMMIT
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
ValuePtr [in] : SQL_AUTOCOMMIT_ON
::SET AUTOCOMMIT ON 2009-03-13 11:15:09.025000 [0x10F324F0]
ValuePtr [in] : SQL_AUTOCOMMIT_ON
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:09.025000
ConnectionHandle [in] : 10F381B2
Attribute [in] : SQL_ATTR_SESSION_TIMEOUT
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
ValuePtr [in] : 900
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:09.025000
ConnectionHandle [in] : 10F381B2
Attribute [in] : SQL_ATTR_TXN_ISOLATION
StringLength [in] : 4
enc : UCS2 big endian (native)
ValuePtr [in] : SQL_TXN_READ_COMMITTED
SQLRETURN : SQL_SUCCESS
SQLAllocHandle 2009-03-13 11:15:17.147000
HandleType [in] : SQL_HANDLE_DBC
InputHandle [in] : 10F31E8D
OutputHandlePtr [out] : &(10F30B86)
SQLRETURN : SQL_SUCCESS
SQLGetInfo 2009-03-13 11:15:17.147000
ConnectionHandle [in] : 10F30B86
InfoType [in] : SQL_DRIVER_ODBC_VER
BufferLength [in] : 12
enc : UCS2 big endian (native)
InfoValuePtr [out] : 03.51
StringLengthPtr [out] : 10
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:17.147000
ConnectionHandle [in] : 10F30B86
Attribute [in] : unknown ConnAttr:115
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
SQLRETURN : SQL_ERROR
SQLGetInfo 2009-03-13 11:15:17.147000
ConnectionHandle [in] : 10F30B86
InfoType [in] : SQL_MAX_CONCURRENT_ACTIVITIES
BufferLength [in] : 2
enc : UCS2 big endian (native)
InfoValuePtr [out] : 32767
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:17.147000
ConnectionHandle [in] : 10F30B86
Attribute [in] : SQL_ATTR_LOGIN_TIMEOUT
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
ValuePtr [in] : 60
SQLRETURN : SQL_SUCCESS
SQLDriverConnect 2009-03-13 11:15:17.147000
ConnectionHandle [in] : 10F30B86
WindowHandle [in] : (null)
InConnectionStr [in] : DRIVER={MaxDB (Unicode)};SERVERDB=EDP350;SERVERNODE=127.0.0.1;
::CONNECT 2009-03-13 11:15:17.147000 [0x10F34838]
SERVERNODE: '127.0.0.1'
SERVERDB : 'EDP350'
USER : 'ESKDBADM'
CONNECT PROPERTIES: (9)
KEY: 'TRANSLATE_BINARY_AS_ENCODED' VALUE: '1'
KEY: 'ODBC_BIN2HEX' VALUE: '1'
KEY: 'ODBC_NUMBER_TRUNCATION' VALUE: '1'
KEY: 'CODEPAGENAME' VALUE: 'WINDOWS-1252'
KEY: 'DEFAULTMAPCHAR' VALUE: '?'
KEY: 'SQLMODE' VALUE: 'INTERNAL'
KEY: 'CHOPBLANKS' VALUE: '1'
KEY: 'COMPONENT' VALUE: 'ODB'
KEY: 'ISOLATIONLEVEL' VALUE: '1'
CONNECT COMMAND: 'CONNECT ? IDENTIFIED BY ? SQLMODE INTERNAL ISOLATION LEVEL 1'
SESSION ID: 2
CHOP TRAILING BLANKS ON INPUT DISABLED
VARIABLE INPUT DISABLED
SCROLLABLE CURSORS DISABLED
INTERNAL FORMAT FOR DATE/TIME I/O ENABLED
EXTENDED LOB LOCATOR FUNCTIONALITY ENABLED
OK
::SET AUTOCOMMIT ON 2009-03-13 11:15:17.162000 [0x10F34838]
OutConnectionStr [out] : SERVERNODE=127.0.0.1;SERVERDB=EDP350;DRIVER={MaxDB (Unicode)};SERVERDB=EDP350;SERVERNODE=127.0.0.1;UID=ESKDBADM;
BufferLength [in] : 1024
DriverCompletion [in] : SQL_DRIVER_NOPROMPT
enc : UCS2 big endian (native)
SQLRETURN : SQL_SUCCESS
SQLGetDiagRec 2009-03-13 11:15:17.162000
HandleType [in] : SQL_HANDLE_DBC
Handle [in] : 10F30B86
RecNumber [in] : 1
BufferLength [in] : 0
enc : UCS2 big endian (native)
SQLRETURN : SQL_NO_DATA
SQLGetFunctions 2009-03-13 11:15:17.162000
ConnectionHandle [in] : 10F30B86
FunctionId [in] : SQL_API_ODBC3_ALL_FUNCTIONS
SupportedPtr [out] : 65535
SQLRETURN : SQL_SUCCESS
SQLGetInfo 2009-03-13 11:15:17.162000
ConnectionHandle [in] : 10F30B86
InfoType [in] : SQL_CURSOR_COMMIT_BEHAVIOR
BufferLength [in] : 2
enc : UCS2 big endian (native)
InfoValuePtr [out] : SQL_CC_PRESERVE
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLGetInfo 2009-03-13 11:15:17.162000
ConnectionHandle [in] : 10F30B86
InfoType [in] : SQL_CURSOR_ROLLBACK_BEHAVIOR
BufferLength [in] : 2
enc : UCS2 big endian (native)
InfoValuePtr [out] : SQL_CC_CLOSE
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:17.162000
ConnectionHandle [in] : 10F30B86
Attribute [in] : SQL_ATTR_AUTOCOMMIT
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
ValuePtr [in] : SQL_AUTOCOMMIT_ON
::SET AUTOCOMMIT ON 2009-03-13 11:15:17.162000 [0x10F34838]
ValuePtr [in] : SQL_AUTOCOMMIT_ON
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:17.162000
ConnectionHandle [in] : 10F30B86
Attribute [in] : SQL_ATTR_SESSION_TIMEOUT
StringLength [in] : SQL_IS_UINTEGER
enc : UCS2 big endian (native)
ValuePtr [in] : 900
SQLRETURN : SQL_SUCCESS
SQLSetConnectAttr 2009-03-13 11:15:17.178000
ConnectionHandle [in] : 10F30B86
Attribute [in] : SQL_ATTR_TXN_ISOLATION
StringLength [in] : 4
enc : UCS2 big endian (native)
ValuePtr [in] : SQL_TXN_READ_COMMITTED
SQLRETURN : SQL_SUCCESS
SQLAllocHandle 2009-03-13 11:15:17.194000
HandleType [in] : SQL_HANDLE_STMT
InputHandle [in] : 10F30B86
OutputHandlePtr [out] : &(10F35C60)
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:17.194000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_APP_ROW_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB2348
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:17.194000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_APP_PARAM_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB23D4
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:17.194000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_IMP_ROW_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB2460
SQLRETURN : SQL_SUCCESS
SQLGetStmtAttr 2009-03-13 11:15:17.194000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_IMP_PARAM_DESC
BufferLength [in] : SQL_IS_POINTER
ValuePtr [out] : 0FFB24EC
SQLRETURN : SQL_SUCCESS
SQLSetStmtAttr 2009-03-13 11:15:17.194000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_CURSOR_TYPE
StringLength [in] : SQL_IS_INTEGER
ValuePtr [in] : SQL_CURSOR_FORWARD_ONLY
SQLRETURN : SQL_SUCCESS
SQLSetStmtAttr 2009-03-13 11:15:17.194000
StatementHandle [in] : 10F35C60
Attribute [in] : SQL_ATTR_QUERY_TIMEOUT
StringLength [in] : SQL_IS_UINTEGER
ValuePtr [in] : 900
SQLRETURN : SQL_SUCCESS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
When I enable traces i have a GPF (Access violation) when I first call SQLBindCol 2009-03-13 11:15:23.707000
Here is the call stack
# ChildEBP RetAddr Args to Child
WARNING: Stack unwind information not available. Following frames may be wrong.
00 00139f84 4889a0ef 00000000 00000001 00000004 sdbodbcw!SQLBindCol+0x354
01 00139fb4 66e1f061 488c0000 00000001 00000004 ODBC32!SQLBindCol+0x119 (FPO: [6,1,4])
02 0013a0cc 66cb3d30 13c1d9b0 00000001 00000004 DBManage35!SafeSQL::SQLBindCol(void * StatementHandle = 0x13c1d9b0, unsigned short ColumnNumber = 1, short TargetType = 4, void * TargetValue = 0x00000008, long BufferLength = 4, long * StrLen_or_Ind = 0x00000004)+0x171 (FPO: [Non-Fpo]) (CONV: cdecl) [d:\dev32\coterotie\faxgate\common\libs\dbmanage\safesql.cpp @ 1000]
03 0013addc 66d7d02f 13c321bc 00000002 00000008 DBManage35!IDBRowset::CreateAccessor(unsigned long dwAccessorFlags = 2, unsigned long cBindings = 8, struct tagDBBINDING * rgBindings = 0x13c1dce8, unsigned long cbRowSize = 0xcc, unsigned long * phAccessor = 0x13c2cd50, unsigned long * rgStatus = 0x00000000)+0x270 (FPO: [Non-Fpo]) (CONV: stdcall) [d:\dev32\coterotie\faxgate\common\libs\dbmanage\db2odbc.cpp @ 1933]
04 0013de2c 66e64bb0 0013debc 1094be38 0013eca4 DBManage35!CStorageRecordset::MoveFirst(class CDBConnection * aConnection = 0x1094be38)+0x8ef (FPO: [Non-Fpo]) (CONV: thiscall) [d:\dev32\coterotie\faxgate\common\libs\dbmanage\dbstorage.cpp @ 644]
05 0013ebac 66d65a8c 00000000 1016c1c8 cccccccc DBManage35!virtualRecordset::MoveFirst(void)+0x380 (FPO: [Non-Fpo]) (CONV: thiscall) [d:\dev32\coterotie\faxgate\common\libs\dbmanage\virtualrecordset.cpp @ 346]
06 0013eca4 77d05186 13c2ca08 0013ecf0 1016c1c8 DBManage35!CDBRecordset::MoveFirst(void)+0x42c (FPO: [Non-Fpo]) (CONV: stdcall) [d:\dev32\coterotie\faxgate\common\libs\dbmanage\dbrecordset.cpp @ 339]
07 0013ecbc 77d14acf 13c2ca08 00000038 00000004 OLEAUT32!DispCallFunc+0x16a
08 0013ed4c 66ccf241 00207ce4 13c2ca08 00000000 OLEAUT32!CTypeInfo2::Invoke+0x234 (FPO: [8,23,0])
09 0013ed80 66d0b142 13c2ca08 60020007 633a0bac DBManage35!ATL::CComTypeInfoHolder::Invoke(struct IDispatch * p = 0x13c2ca08, long dispidMember = 1610743815, struct _GUID * __formal = 0x633a0bac {00000000-0000-0000-0000-000000000000}, unsigned long lcid = 0x409, unsigned short wFlags = 1, struct tagDISPPARAMS * pdispparams = 0x0013ee80, struct tagVARIANT * pvarResult = 0x00000000, struct tagEXCEPINFO * pexcepinfo = 0x0013ee60, unsigned int * puArgErr = 0x0013eeb4)+0x61 (FPO: [Non-Fpo]) (CONV: thiscall) [c:\program files\microsoft visual studio .net 2003\vc7\atlmfc\include\atlcom.h @ 3589]
0a 0013edac 633a2684 13c2ca08 60020007 633a0bac DBManage35!ATL::IDispatchImpl<IDBRecordset,&IID_IDBRecordset,&LIBID_DBMANAGELib,1,0,ATL::CComTypeInfoHolder>::Invoke(long dispidMember = 1610743815, struct _GUID * riid = 0x633a0bac {00000000-0000-0000-0000-000000000000}, unsigned long lcid = 0x409, unsigned short wFlags = 1, struct tagDISPPARAMS * pdispparams = 0x0013ee80, struct tagVARIANT * pvarResult = 0x00000000, struct tagEXCEPINFO * pexcepinfo = 0x0013ee60, unsigned int * puArgErr = 0x0013eeb4)+0x32 (FPO: [Non-Fpo]) (CONV: stdcall) [c:\program files\microsoft visual studio .net 2003\vc7\atlmfc\include\atlcom.h @ 4414]
0b 0013ede8 633a25f1 0003a600 13c2ca08 60020007 JScript!IDispatchInvoke2+0xb5 (FPO: [10,3,4])
0c 0013ee24 633a257c 0003a600 13c2ca08 60020007 JScript!IDispatchInvoke+0x59 (FPO: [10,0,4])
0d 0013ee98 633a4246 0003a600 13c2ca08 60020007 JScript!InvokeDispatch+0x90 (FPO: [7,14,4])
0e 0013eedc 6339c824 0003a600 0013eefc 00000001 JScript!VAR::InvokeByName+0x1c2 (FPO: [6,6,0])
0f 0013ef1c 633a202b 0003a600 00000001 00000000 JScript!VAR::InvokeDispName+0x43 (FPO: [5,8,0])
10 0013ef40 633a41f2 0003a600 00000000 00000001 JScript!VAR::InvokeByDispID+0xb9 (FPO: [7,0,0])
11 0013eff8 633a2fcb 00000000 00000000 0003a8e0 JScript!CScriptRuntime::Run+0x16c9 (FPO: [SEH])
12 0013f010 633a4570 00000000 00000003 0ece0ea0 JScript!ScrFncObj::Call+0x8d (FPO: [5,0,4])
13 0013f09c 633a1098 0003a600 00000005 00000001 JScript!NameTbl::InvokeInternal+0xe0 (FPO: [SEH])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
I am going to send traces ASAP.
For information, if I use SQLStudio it works with driver 7.6 and 7.7 (I change driver used with debugger)
But SQLStudio do not use row wise binding.
DatabaseStudio seems not using ODBC.
I just made test (using my software) with 7.6 driver and Row Wise binding works on my 7.7 Database.
Yann.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Yann
For problem analysis, please provide a ODBC trace of the driver itself:
odbc_cons trace api on
odbc_cons trace sql on
Then repeat your test and send the trace file. With
odbc_cons show all
the location of the trace file is printed.
After that, call
odbc_cons trace off
Otherwise the ODBC driver continues to write trace files. FYI, odbc_cons is only available for MaxDB ODBC drivers 7.7 and higher.
Could you please give the MaxDB ODBC driver 7.6 a try. Maybe this problem does not occur with the ancestor of the current driver.
Regards Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Our software use SAPDB since version 7.4, and it also run on SQLServer. And I never have issues with ColumnWise binding.
As you can see in traces
SQLDescribeColW for collumn 2 return 11
SQLDescribeColW with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
WCHAR * 0x00000000
SWORD 2
SWORD * 0x00000000
SWORD * 0x0012f468 (11)
UDWORD * 0x0012f450 (26)
SWORD * 0x00000000
SWORD * 0x00000000
And I bind with type 11
SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR 0x00da0000
SDWORD 16
SDWORD * 0x00d80000 (0)
And then SQLExtendedFetch failed
EXIT SQLExtendedFetch (59) 12048 with return code -1 (SQL_ERROR)
And the error is
DIAG [S1000] [SAP AG][SDBODBC DLL][MaxDB] General error;-10413 Illegal TIMESTAMP value for parameter/column (2) (-10413)
Do you have any idea ?
Yann.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Here is the table definition
CREATE TABLE "ESKDBADM"."DBM350_SM"
(
"CONV_DATE_TIME" Timestamp,
"MSN" Integer NOT NULL,
UNIQUE(MSN),
PRIMARY KEY("MSN")
)
the row :
msn = 577057
and
conv_date_time = 2009-03-11 14:37:57.318000
For information it works if conv_date_time is null, then i update conv_date_time with now() and then it does not work ...
The following code contains ODBC calls with parameters made to driver.
Yann.
[11/03/2009 15:19:24.468]EskTrace{6600,7104} ENTER SQLExecDirectW (11) 12048
HSTMT 0x003c2f10
WCHAR * 0x0015f5c8 [ -3] "select Msn,conv_date_time from DBM350_SM\ 0"
SDWORD -3
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:24.468]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:24.468]EskTrace{6600,7104} EXIT SQLExecDirectW (11) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
WCHAR * 0x0015f5c8 [ -3] "select Msn,conv_date_time from DBM350_SM\ 0"
SDWORD -3
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLFreeStmt (16) 12048
HSTMT 0x003c2f10
UWORD 2 <SQL_UNBIND>
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLFreeStmt (16) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2 <SQL_UNBIND>
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLNumResultCols (18) 12048
HSTMT 0x003c2f10
SWORD * 0x0012f458
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLNumResultCols (18) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
SWORD * 0x0012f458 (2)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLGetInfoW (45) 11832
HDBC 0x003c2e38
UWORD 7 <SQL_DRIVER_VER>
PTR 0x0012f46c
SWORD 20
SWORD * 0x0012f44a
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLGetInfoW (45) 11832 with return code 0 (SQL_SUCCESS)
HDBC 0x003c2e38
UWORD 7 <SQL_DRIVER_VER>
PTR 0x0012f46c [ 18] "7.7.06.09"
SWORD 20
SWORD * 0x0012f44a (18)
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLColAttributesW (6) 12048
HSTMT 0x003c2f10
UWORD 1
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLColAttributesW (6) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 1
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLDescribeColW (8) 12048
HSTMT 0x003c2f10
UWORD 1
WCHAR * 0x00000000
SWORD 1
SWORD * 0x00000000
SWORD * 0x0012f468
UDWORD * 0x0012f450
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLDescribeColW (8) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 1
WCHAR * 0x00000000
SWORD 1
SWORD * 0x00000000
SWORD * 0x0012f468 (4)
UDWORD * 0x0012f450 (10)
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} ENTER SQLBindCol (4) 12048
HSTMT 0x003c2f10
UWORD 1
SWORD -16 <SQL_C_SLONG>
PTR 0x00d60000
SDWORD 4
SDWORD * 0x00d40000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.733]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.733]EskTrace{6600,7104} EXIT SQLBindCol (4) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 1
SWORD -16 <SQL_C_SLONG>
PTR 0x00d60000
SDWORD 4
SDWORD * 0x00d40000 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} ENTER SQLColAttributesW (6) 12048
HSTMT 0x003c2f10
UWORD 2
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.749]EskTrace{6600,7104} EXIT SQLColAttributesW (6) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
UWORD 8 <SQL_DESC_UNSIGNED>
PTR 0x0012f46c
SWORD 0
SWORD * 0x00000000
SDWORD * 0x0012f460 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} ENTER SQLDescribeColW (8) 12048
HSTMT 0x003c2f10
UWORD 2
WCHAR * 0x00000000
SWORD 2
SWORD * 0x00000000
SWORD * 0x0012f468
UDWORD * 0x0012f450
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.749]EskTrace{6600,7104} EXIT SQLDescribeColW (8) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
WCHAR * 0x00000000
SWORD 2
SWORD * 0x00000000
SWORD * 0x0012f468 (11)
UDWORD * 0x0012f450 (26)
SWORD * 0x00000000
SWORD * 0x00000000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} ENTER SQLBindCol (4) 12048
HSTMT 0x003c2f10
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR 0x00da0000
SDWORD 16
SDWORD * 0x00d80000
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.749]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.749]EskTrace{6600,7104} EXIT SQLBindCol (4) 12048 with return code 0 (SQL_SUCCESS)
HSTMT 0x003c2f10
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR 0x00da0000
SDWORD 16
SDWORD * 0x00d80000 (0)
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.780]EskTrace{6600,7104} ENTER SQLExtendedFetch (59) 12048
HSTMT 0x003c2f10
UWORD 1 <SQL_FETCH_NEXT>
SDWORD 1
UDWORD * 0x0012f378
UWORD * 0x00162150
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.780]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 0
[11/03/2009 15:19:26.780]EskTrace{6600,7104} EXIT SQLExtendedFetch (59) 12048 with return code -1 (SQL_ERROR)
HSTMT 0x003c2f10
UWORD 1 <SQL_FETCH_NEXT>
SDWORD 1
UDWORD * 0x0012f378
UWORD * 0x00162150
Handle : 3C2F10 ____ Connection : 3C2E38
select Msn,conv_date_time from DBM350_SM
[11/03/2009 15:19:26.780]EskTrace{6600,7104} ENTER SQLGetDiagRecW (1011) 3
SQLSMALLINT 3
SQLHANDLE 0x003c2f10
SQLSMALLINT 1
SQLWCHAR * 0x0012bca4 (NYI)
SQLINTEGER * 0x0012bd2c
SQLWCHAR * 0x003c3440 (NYI)
SQLSMALLINT 2000
SQLSMALLINT * 0x0012bc90
[11/03/2009 15:19:26.780]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 1
[11/03/2009 15:19:26.780]EskTrace{6600,7104} EXIT SQLGetDiagRecW (1011) 3 with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 0x003c2f10
SQLSMALLINT 1
SQLWCHAR * 0x0012bca4 (NYI)
SQLINTEGER * 0x0012bd2c (-10413)
SQLWCHAR * 0x003c3440 (NYI)
SQLSMALLINT 2000
SQLSMALLINT * 0x0012bc90 (98)
[11/03/2009 15:19:26.780]EskTrace{6600,7104}
DIAG [S1000] [SAP AG][SDBODBC DLL][MaxDB] General error;-10413 Illegal TIMESTAMP value for parameter/column (2) (-10413)
[11/03/2009 15:19:26.780]EskTrace{6600,7104} ENTER SQLGetDiagRecW (1011) 3
SQLSMALLINT 3
SQLHANDLE 0x003c2f10
SQLSMALLINT 2
SQLWCHAR * 0x0012bca4 (NYI)
SQLINTEGER * 0x0012bd2c
SQLWCHAR * 0x003c3440 (NYI)
SQLSMALLINT 2000
SQLSMALLINT * 0x0012bc90
[11/03/2009 15:19:26.780]EskTrace{6600,7104} TraceStr is not NULL RetHandle : 1
[11/03/2009 15:19:26.780]EskTrace{6600,7104} EXIT SQLGetDiagRecW (1011) 3 with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 3
SQLHANDLE 0x003c2f10
SQLSMALLINT 2
SQLWCHAR * 0x0012bca4 (NYI)
SQLINTEGER * 0x0012bd2c
SQLWCHAR * 0x003c3440 (NYI)
SQLSMALLINT 2000
SQLSMALLINT * 0x0012bc90
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yann,
please use code tags for content like log files, error messages, actual code etc.
The crap above is barely readable.
Moreover it would be useful to have the table definition and to see the rows for which you get the error.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.