pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPsqlODBC Error
4+ messages / 4 participants
[nested] [flat]
* PsqlODBC Error
@ 1998-11-25 02:33 Mohd Rasyidi <rasyidi@aitpg.Adorna-RMIT.edu.my>
0 siblings, 0 replies; 4+ messages in thread
From: Mohd Rasyidi @ 1998-11-25 02:33 UTC (permalink / raw)
To: pgsql-interfaces
I got "could not connect to remote socket(#1)" when I tried to export my
Access 97 database to postgresql 6.3
My config for datasource(psqlODBC) in control panel:
Database = student #My database name in postgresql (Redhat 5.1)
Server = hostname.domainname.edu.my
User Name = rasyidi
Port = 5432 (default)
password = no password. (if I key in password also cannot connect)
option(Advanced)
datasource -- protocol = 6.3
In my redhat 5.1.
I createuser rasyidi
can create database
can create user.
using rasyidi, I createdb student and staff_info table with 4 fields:
Name,email,post,department(TEXT).
in pg_hba.conf, I add at the last line to allow all ip address in my place
can connect to the server:
host all xxx.xxx.xx.0 255.255.255.0 trust
thats all for my database server.
But I do not know the postmaster start with -i or not because I am using
rpm package that come with redhat 5.1.
My network environment.
Domain name server is on AIX server(building A) and redhat 5.1 is on
another server(Building B)
Have subnet mask.
Access 97
got 4 fields = name,email,post,department - no primary key
with some data inside the table.
database name simpledb and staff_info table.
Can some one help me to make the connection.
Thanks...
^ permalink raw reply [nested|flat] 4+ messages in thread
* PSQLODBC error
@ 1999-03-08 23:14 Ken J. Wright <ken@cncware.com>
0 siblings, 0 replies; 4+ messages in thread
From: Ken J. Wright @ 1999-03-08 23:14 UTC (permalink / raw)
To: pgsql-interfaces
-----------------------------------------------------------
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
* PSQLODBC error
@ 1999-03-08 23:47 Ken J. Wright <ken@ori-ind.com>
0 siblings, 0 replies; 4+ messages in thread
From: Ken J. Wright @ 1999-03-08 23:47 UTC (permalink / raw)
To: pgsql-interfaces
-----------------------------------------------------------
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
* Re: PSQLODBC error
@ 1999-04-09 22:39 Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 4+ messages in thread
From: Byron Nikolaidis @ 1999-04-09 22:39 UTC (permalink / raw)
To: Ken J. Wright <ken@ori-ind.com>; +Cc: pgsql-interfaces
Ken J. Wright wrote:
> Byron,
>
> Some more info. In the driver setup, if Parse Statements is checked, the
> error occurs. If not checked, then all is ok. I noticed in parse.c that
> memory for field info is allocated in 32 field blocks. Perhaps the error is
> here? At least I am now out of the deep water.
>
>
Yeah, I had a feeling about the parse statements thing. I think you found a
bug.
FYI, the "parse statements" option was added before we had the 6.4 protocol.
The newer protocol passes the size of the fields back in a query, which is
something the old 6.3 protocol did not do. So I wrote this grand parse routine
which would take a query and go ask the database about all the fields. The
"parse statements" still has an advantage over the 6.4 protocol, in that it can
find out about whether a field in a query can be "null" or not. Plus, it can
find out about column alias names. Unfortunately, I don't think the parse
statements can handle some of the newer syntaxes that will be introduced in
6.5.
To be honest, I don't think the driver should be parsing sql statements too
much anyway.
Byron
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-04-09 22:39 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-25 02:33 PsqlODBC Error Mohd Rasyidi <rasyidi@aitpg.Adorna-RMIT.edu.my>
1999-03-08 23:14 PSQLODBC error Ken J. Wright <ken@cncware.com>
1999-03-08 23:47 PSQLODBC error Ken J. Wright <ken@ori-ind.com>
1999-04-09 22:39 Re: PSQLODBC error Byron Nikolaidis <byronn@insightdist.com>
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