pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive help / color / mirror / Atom feed From: Ken J. Wright <ken@cncware.com>
To: pgsql-interfaces@postgreSQL.org
Subject: PSQLODBC error
Date: Mon, 08 Mar 1999 15:14:01 -0800
Message-ID: <3.0.32.19990308151359.007f1300@ren.cncware.com> (raw )
-----------------------------------------------------------
An update here Byron,
If I remove fields cl9 thru the end, the problem goes away.
Try to add one more field back & it blows.
The table as shown here is no trouble in psql or libpq.
-----------------------------------------------------------
Hello Byron,
I'm getting the following error when opening a particular PostgreSQL table.
Access violation at adress 10001EF6 in module 'PSQLODBC'. Read of address
FFFFFFFF.
This does not happen with any other table. I have dropped and re-created,
but no help. I've attached sql1.log. Following is the schema.
PostgreSQL 6.4, psqlodbc 6.40.0004. Any clues?
Thanks,
Ken
Table = tk_cfg
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| config_id | varchar() |
16 |
| tkpath | varchar() |
0 |
| netpath | varchar() |
0 |
| workpath | varchar() |
0 |
| temppath | varchar() |
0 |
| execpath | varchar() |
0 |
| applpath | varchar() |
0 |
| statid | varchar() |
16 |
| menudb | varchar() |
8 |
| stepdb | varchar() |
8 |
| procdb | varchar() |
8 |
| typedb | varchar() |
8 |
| cmnddb | varchar() |
8 |
| conddb | varchar() |
8 |
| pwdb | varchar() |
8 |
| varfil | varchar() |
12 |
| decprec | int2 |
2 |
| touchcrt | char() |
1 |
| refresh | int2 |
2 |
| tempscript | varchar() |
8 |
| appltemppath | varchar() |
0 |
| applmenudb | varchar() |
8 |
| applmenuid | varchar() |
25 |
| applmenuexe | varchar() |
0 |
| cl1 | int2 |
2 |
| cl2 | int2 |
2 |
| cl3 | int2 |
2 |
| cl4 | int2 |
2 |
| cl5 | int2 |
2 |
| cl6 | int2 |
2 |
| cl7 | int2 |
2 |
| cl8 | int2 |
2 |
| cl9 | int2 |
2 |
| cl10 | int2 |
2 |
| cl11 | int2 |
2 |
| cl12 | int2 |
2 |
| cl21 | int2 |
2 |
| cl22 | int2 |
2 |
| cl23 | int2 |
2 |
| cl24 | int2 |
2 |
| rptlen | int2 |
2 |
| rptwid | int2 |
2 |
| rptcmd | varchar() |
80 |
+----------------------------------+----------------------------------+-----
--+
pioneer=> \d tk_cfg_idx
Table = tk_cfg_idx
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| config_id | varchar() |
-4 |
+----------------------------------+----------------------------------+-----
--+
Attachments:
Sql1.log (text/plain, 30.3K) download
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x01121688
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x01121688
transmgr ffc654a5:ffc5acf1 ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x011206a0
SQLHANDLE * 0x0152da48
transmgr ffc654a5:ffc5acf1 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x011206a0
SQLHANDLE * 0x0152da48 ( 0x01121688)
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 ENTER SQLGetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 7 <SQL_CONCURRENCY>
SQLPOINTER 0x006df1e4
SQLINTEGER 4
SQLINTEGER * 0x00000000
transmgr ffc654a5:ffc5acf1 EXIT SQLGetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121688
SQLINTEGER 7 <SQL_CONCURRENCY>
SQLPOINTER 0x006df1e4 (1)
SQLINTEGER 4
SQLINTEGER * 0x00000000
transmgr ffc654a5:ffc5acf1 ENTER SQLSetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 7 <SQL_ATTR_CONCURRENCY>
SQLPOINTER 0x00000004
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121688
SQLINTEGER 7 <SQL_ATTR_CONCURRENCY>
SQLPOINTER 0x00000004 (BADMEM)
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 ENTER SQLGetInfoW
HDBC 0x011206a0
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 0x006df1c4
SWORD 4
SWORD * 0x006df1c2
transmgr ffc654a5:ffc5acf1 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x011206a0
UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1>
PTR 0x006df1c4
SWORD 4
SWORD * 0x006df1c2 (4)
transmgr ffc654a5:ffc5acf1 ENTER SQLGetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 6 <SQL_CURSOR_TYPE>
SQLPOINTER 0x006df1e4
SQLINTEGER 4
SQLINTEGER * 0x00000000
transmgr ffc654a5:ffc5acf1 EXIT SQLGetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121688
SQLINTEGER 6 <SQL_CURSOR_TYPE>
SQLPOINTER 0x006df1e4 (0)
SQLINTEGER 4
SQLINTEGER * 0x00000000
transmgr ffc654a5:ffc5acf1 ENTER SQLSetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000001
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 EXIT SQLSetStmtAttr with return code 1 (SQL_SUCCESS_WITH_INFO)
SQLHSTMT 0x01121688
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000001 (BADMEM)
SQLINTEGER 4
DIAG [01S02] Requested value changed. (16)
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 ENTER SQLGetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 27 <unknown>
SQLPOINTER [Unknown attribute 27]
SQLINTEGER 4
SQLINTEGER * 0x00000000
transmgr ffc654a5:ffc5acf1 EXIT SQLGetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121688
SQLINTEGER 27 <unknown>
SQLPOINTER [Unknown attribute 27]
SQLINTEGER 4
SQLINTEGER * 0x00000000
transmgr ffc654a5:ffc5acf1 ENTER SQLSetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 12 <SQL_ATTR_USE_BOOKMARKS>
SQLPOINTER 0x00000002
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121688
SQLINTEGER 12 <SQL_ATTR_USE_BOOKMARKS>
SQLPOINTER 0x00000002 (BADMEM)
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 0 <SQL_CLOSE>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 3 <SQL_RESET_PARAMS>
transmgr ffc654a5:ffc5acf1 ENTER SQLFreeStmt
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 2 <SQL_UNBIND>
transmgr ffc654a5:ffc5acf1 ENTER SQLPrepare
HSTMT 0x01121688
UCHAR * 0x01531c0c [ -3] "Select * from tk_cfg Order By config_id\ d\ a\ 0"
SDWORD -3
transmgr ffc654a5:ffc5acf1 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UCHAR * 0x01531c0c [ -3] "Select * from tk_cfg Order By config_id\ d\ a\ 0"
SDWORD -3
transmgr ffc654a5:ffc5acf1 ENTER SQLSetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 22 <SQL_ATTR_PARAMSET_SIZE>
SQLPOINTER 0x00000000
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 EXIT SQLSetStmtAttr with return code -1 (SQL_ERROR)
SQLHSTMT 0x01121688
SQLINTEGER 22 <SQL_ATTR_PARAMSET_SIZE>
SQLPOINTER 0x00000000
SQLINTEGER 4
DIAG [HY092] [Microsoft][ODBC Driver Manager] Option type out of range (0)
transmgr ffc654a5:ffc5acf1 ENTER SQLExecute
HSTMT 0x01121688
transmgr ffc654a5:ffc5acf1 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
transmgr ffc654a5:ffc5acf1 ENTER SQLSetStmtAttr
SQLHSTMT 0x01121688
SQLINTEGER 26 <SQL_ATTR_ROWS_FETCHED_PTR>
SQLPOINTER 0x0152da70
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121688
SQLINTEGER 26 <SQL_ATTR_ROWS_FETCHED_PTR>
SQLPOINTER 0x0152da70
SQLINTEGER 4
transmgr ffc654a5:ffc5acf1 ENTER SQLColAttribute
SQLHSTMT 0x01121688
SQLSMALLINT 0
SQLSMALLINT 1001 <SQL_DESC_COUNT>
SQLPOINTER 0x006df032
SQLSMALLINT 4
SQLSMALLINT * 0x006df030
SQLPOINTER [Unknown attribute 1001]
transmgr ffc654a5:ffc5acf1 EXIT SQLColAttribute with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121688
SQLSMALLINT 0
SQLSMALLINT 1001 <SQL_DESC_COUNT>
SQLPOINTER 0x006df032
SQLSMALLINT 4
SQLSMALLINT * 0x006df030 (66)
SQLPOINTER [Unknown attribute 1001]
transmgr ffc654a5:ffc5acf1 ENTER SQLDescribeCol
HSTMT 0x01121688
UWORD 1
UCHAR * 0x006df162
SWORD 256
SWORD * 0x006df26e
SWORD * 0x006df26c
UDWORD * 0x006df268
SWORD * 0x006df266
SWORD * 0x006df264
transmgr ffc654a5:ffc5acf1 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 1
UCHAR * 0x006df162 [ 9] "config_id"
SWORD 256
SWORD * 0x006df26e (9)
SWORD * 0x006df26c (12)
UDWORD * 0x006df268 (16)
SWORD * 0x006df266 (0)
SWORD * 0x006df264 (1)
transmgr ffc654a5:ffc5acf1 ENTER SQLBindCol
HSTMT 0x01121688
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x01531c40
SDWORD 17
SDWORD * 0x01531c84
transmgr ffc654a5:ffc5acf1 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x01121688
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x01531c40
SDWORD 17
SDWORD * 0x01531c84 (-1)
transmgr ffc654a5:ffc5acf1 ENTER SQLDescribeCol
HSTMT 0x01121688
UWORD 2
UCHAR * 0x006df162
SWORD 256
SWORD * 0x006df26e
SWORD * 0x006df26c
UDWORD * 0x006df268
SWORD * 0x006df266
SWORD * 0x006df264
tkedit ffc36033:ffc6259f ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0121ff10
SQLHANDLE * 0x01529184
tkedit ffc36033:ffc6259f EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x0121ff10
SQLHANDLE * 0x01529184 ( 0x01121758)
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f ENTER SQLGetStmtAttr
SQLHSTMT 0x01121758
SQLINTEGER 7 <SQL_CONCURRENCY>
SQLPOINTER 0x006df7e4
SQLINTEGER 4
SQLINTEGER * 0x00000000
tkedit ffc36033:ffc6259f EXIT SQLGetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121758
SQLINTEGER 7 <SQL_CONCURRENCY>
SQLPOINTER 0x006df7e4 (1)
SQLINTEGER 4
SQLINTEGER * 0x00000000
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f ENTER SQLGetInfoW
HDBC 0x0121ff10
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 0x006df7c4
SWORD 4
SWORD * 0x006df7c2
tkedit ffc36033:ffc6259f EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x0121ff10
UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1>
PTR 0x006df7c4
SWORD 4
SWORD * 0x006df7c2 (4)
tkedit ffc36033:ffc6259f ENTER SQLGetStmtAttr
SQLHSTMT 0x01121758
SQLINTEGER 6 <SQL_CURSOR_TYPE>
SQLPOINTER 0x006df7e4
SQLINTEGER 4
SQLINTEGER * 0x00000000
tkedit ffc36033:ffc6259f EXIT SQLGetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121758
SQLINTEGER 6 <SQL_CURSOR_TYPE>
SQLPOINTER 0x006df7e4 (0)
SQLINTEGER 4
SQLINTEGER * 0x00000000
tkedit ffc36033:ffc6259f ENTER SQLSetStmtAttr
SQLHSTMT 0x01121758
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000002
SQLINTEGER 4
tkedit ffc36033:ffc6259f EXIT SQLSetStmtAttr with return code 1 (SQL_SUCCESS_WITH_INFO)
SQLHSTMT 0x01121758
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000002 (BADMEM)
SQLINTEGER 4
DIAG [01S02] [Microsoft][ODBC Cursor Library] Option value changed (0)
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 0 <SQL_CLOSE>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 3 <SQL_RESET_PARAMS>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f ENTER SQLFreeStmt
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 2 <SQL_UNBIND>
tkedit ffc36033:ffc6259f ENTER SQLGetStmtAttr
SQLHSTMT 0x01121758
SQLINTEGER 27 <unknown>
SQLPOINTER [Unknown attribute 27]
SQLINTEGER 4
SQLINTEGER * 0x00000000
tkedit ffc36033:ffc6259f EXIT SQLGetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121758
SQLINTEGER 27 <unknown>
SQLPOINTER [Unknown attribute 27]
SQLINTEGER 4
SQLINTEGER * 0x00000000
tkedit ffc36033:ffc6259f ENTER SQLTablesW
HSTMT 0x01121758
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x011212bc [ 256] "%\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0"
SWORD 256
WCHAR * 0x01120f08 [ 256] "TABLE\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0"
SWORD 256
tkedit ffc36033:ffc6259f EXIT SQLTablesW with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x00000000
SWORD 0
WCHAR * 0x011212bc [ 256] "%\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0"
SWORD 256
WCHAR * 0x01120f08 [ 256] "TABLE\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0"
SWORD 256
tkedit ffc36033:ffc6259f ENTER SQLColAttribute
SQLHSTMT 0x01121758
SQLSMALLINT 0
SQLSMALLINT 1001 <SQL_DESC_COUNT>
SQLPOINTER 0x006df5d2
SQLSMALLINT 4
SQLSMALLINT * 0x006df5d0
SQLPOINTER [Unknown attribute 1001]
tkedit ffc36033:ffc6259f EXIT SQLColAttribute with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121758
SQLSMALLINT 0
SQLSMALLINT 1001 <SQL_DESC_COUNT>
SQLPOINTER 0x006df5d2
SQLSMALLINT 4
SQLSMALLINT * 0x006df5d0 (27508)
SQLPOINTER [Unknown attribute 1001]
tkedit ffc36033:ffc6259f ENTER SQLDescribeCol
HSTMT 0x01121758
UWORD 1
UCHAR * 0x006df702
SWORD 256
SWORD * 0x006df80e
SWORD * 0x006df80c
UDWORD * 0x006df808
SWORD * 0x006df806
SWORD * 0x006df804
tkedit ffc36033:ffc6259f EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 1
UCHAR * 0x006df702 [ 15] "TABLE_QUALIFIER"
SWORD 256
SWORD * 0x006df80e (15)
SWORD * 0x006df80c (-1)
UDWORD * 0x006df808 (128)
SWORD * 0x006df806 (0)
SWORD * 0x006df804 (1)
tkedit ffc36033:ffc6259f ENTER SQLDescribeCol
HSTMT 0x01121758
UWORD 2
UCHAR * 0x006df702
SWORD 256
SWORD * 0x006df80e
SWORD * 0x006df80c
UDWORD * 0x006df808
SWORD * 0x006df806
SWORD * 0x006df804
tkedit ffc36033:ffc6259f EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 2
UCHAR * 0x006df702 [ 11] "TABLE_OWNER"
SWORD 256
SWORD * 0x006df80e (11)
SWORD * 0x006df80c (-1)
UDWORD * 0x006df808 (128)
SWORD * 0x006df806 (0)
SWORD * 0x006df804 (1)
tkedit ffc36033:ffc6259f ENTER SQLDescribeCol
HSTMT 0x01121758
UWORD 3
UCHAR * 0x006df702
SWORD 256
SWORD * 0x006df80e
SWORD * 0x006df80c
UDWORD * 0x006df808
SWORD * 0x006df806
SWORD * 0x006df804
tkedit ffc36033:ffc6259f EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 3
UCHAR * 0x006df702 [ 10] "TABLE_NAME"
SWORD 256
SWORD * 0x006df80e (10)
SWORD * 0x006df80c (-1)
UDWORD * 0x006df808 (128)
SWORD * 0x006df806 (0)
SWORD * 0x006df804 (1)
tkedit ffc36033:ffc6259f ENTER SQLDescribeCol
HSTMT 0x01121758
UWORD 4
UCHAR * 0x006df702
SWORD 256
SWORD * 0x006df80e
SWORD * 0x006df80c
UDWORD * 0x006df808
SWORD * 0x006df806
SWORD * 0x006df804
tkedit ffc36033:ffc6259f EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 4
UCHAR * 0x006df702 [ 10] "TABLE_TYPE"
SWORD 256
SWORD * 0x006df80e (10)
SWORD * 0x006df80c (-1)
UDWORD * 0x006df808 (128)
SWORD * 0x006df806 (0)
SWORD * 0x006df804 (1)
tkedit ffc36033:ffc6259f ENTER SQLDescribeCol
HSTMT 0x01121758
UWORD 5
UCHAR * 0x006df702
SWORD 256
SWORD * 0x006df80e
SWORD * 0x006df80c
UDWORD * 0x006df808
SWORD * 0x006df806
SWORD * 0x006df804
tkedit ffc36033:ffc6259f EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 0x01121758
UWORD 5
UCHAR * 0x006df702 [ 7] "REMARKS"
SWORD 256
SWORD * 0x006df80e (7)
SWORD * 0x006df80c (-1)
UDWORD * 0x006df808 (254)
SWORD * 0x006df806 (0)
SWORD * 0x006df804 (1)
tkedit ffc36033:ffc6259f ENTER SQLSetStmtAttr
SQLHSTMT 0x01121758
SQLINTEGER 25 <SQL_ATTR_ROW_STATUS_PTR>
SQLPOINTER 0x0152bc28
SQLINTEGER 0
tkedit ffc36033:ffc6259f EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x01121758
SQLINTEGER 25 <SQL_ATTR_ROW_STATUS_PTR>
SQLPOINTER 0x0152bc28
SQLINTEGER 0
tkedit ffc36033:ffc6259f ENTER SQLFetchScroll
SQLHSTMT 0x01121758
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLINTEGER 0
tkedit ffc36033:ffc6259f EXIT SQLFetchScroll with return code -1 (SQL_ERROR)
SQLHSTMT 0x01121758
SQLSMALLINT 1 <SQL_FETCH_NEXT>
SQLINTEGER 0
DIAG [SL009] [Microsoft][ODBC Cursor Library] No columns were bound prior to calling SQLFetchScroll/SQLExtendedFetch (0)
tkedit ffc36033:ffc6259f ENTER SQLGetDiagRecW
SQLSMALLINT 3
SQLHANDLE 0x01121758
SQLSMALLINT 1
SQLWCHAR * 0x006df5a4 (NYI)
SQLINTEGER * 0x006df7fc
SQLWCHAR * 0x011203a0 (NYI)
SQLSMALLINT 256
SQLSMALLINT * 0x006df7fa
tkedit ffc36033:ffc6259f EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 0x01121758
SQLSMALLINT 1
SQLWCHAR * 0x006df5a4 (NYI)
SQLINTEGER * 0x006df7fc (0)
SQLWCHAR * 0x011203a0 (NYI)
SQLSMALLINT 256
SQLSMALLINT * 0x006df7fa (103)
tkedit ffc36033:ffc6259f ENTER SQLGetDiagRecW
SQLSMALLINT 3
SQLHANDLE 0x01121758
SQLSMALLINT 2
SQLWCHAR * 0x006df5a4 (NYI)
SQLINTEGER * 0x006df7fc
SQLWCHAR * 0x011203a0 (NYI)
SQLSMALLINT 256
SQLSMALLINT * 0x006df7fa
tkedit ffc36033:ffc6259f EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 3
SQLHANDLE 0x01121758
SQLSMALLINT 2
SQLWCHAR * 0x006df5a4 (NYI)
SQLINTEGER * 0x006df7fc
SQLWCHAR * 0x011203a0 (NYI)
SQLSMALLINT 256
SQLSMALLINT * 0x006df7fa
view thread (4+ messages) latest in thread
Message-ID: <3.0.32.19990308151359.007f1300@ren.cncware.com>
Permalink: ../3.0.32.19990308151359.007f1300@ren.cncware.com/
Also on: postgresql.org/message-id/3.0.32.19990308151359.007f1300@ren.cncware.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ken@cncware.com
Subject: Re: PSQLODBC error
In-Reply-To: <3.0.32.19990308151359.007f1300@ren.cncware.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox