Skip site navigation (1) Skip section navigation (2)

Need community help about ODBC .---- Can't fetch the data resource from server.

From: "Elvis Guo" <guoxf(at)163(dot)net>
To: pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org>
Subject: Need community help about ODBC .---- Can't fetch the data resource from server.
Date: 2004-02-01 10:09:47
Message-ID: 20040201101042.68594D1D528@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,Everybody.

I got some ODBC connection trouble. If u had even met this situation,please kindly tell me how your solved the proble.  Thanks advance.


1.My Runtime envionment:

OS:Windows XP Pro
CPU:1.5G P4 Intel
RAM:512M
HD:40G

ODBC Pakage src:
compressed:		psqlodbc-07_03_0200.zip  3,781,611
uncompressed:	psqlodbc.exe			 4,183,040

2.PostgreSQL version:
xjy=> select version();
                               version
------------------------------------------------------------------------
 PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3

My Database "xjy" have one table "employees"
 
xjy=> \z
      Access privileges for database "xjy"
 Schema |   Table   |     Access privileges
--------+-----------+----------------------------
 public | employees | {=,guoxf=arwdRxt,test=arw}
 public | my_seq    |

xjy=> select * from employees ;
 id  | ic  | last_name | first_name
-----+-----+-----------+------------
 104 | 105 | testb     | foo
 103 | 104 | ***       | foo

3.After Install the ODBC driver  "psqlodbc.exe",the system tell me OK.

4.Click xp control panel to install user  DSN, input the correct parameters .

5.My PostgreSQL server have granted the access privilege. I can use PgAdminIII access My database "xjy" successfully.I knew PgAdminIII used libpq.dll for querying. It did not use ODBC to connect the server .

6.So, I star Excell to test If I can get the data from my postgreSQL data base.Click "Data" menu,then "import data".., do the step Excell told me.

7. I can use the Excell test database connection. Its told me OK. But at the final step, I got the message, Excell can't get the data source.

8. I enable psqlodbc_xxx.log and mylog_xxx.log , please read the following detail content. If u can find what's going on there, please tell me how to solve this problem . I had checked all documentation. I still couldn't find any answere.Please help me .

psqlodbc_xxx.log
--------------------
conn=60503800, PGAPI_DriverConnect( in)='DSN=PostgreSQL30;', fDriverCompletion=3
DSN info: DSN='PostgreSQL30',server='192.168.0.12',port='5432',dbase='xjy',user='guoxf',passwd='xxxxx'
          onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings='',conn_encoding='OTHER'
          translation_dll='',translation_option=''
Global Options: Version='07.03.0200', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
                extra_systable_prefixes='pg_;', conn_settings='' conn_encoding='OTHER'
conn=60503800, query=' '
conn=60503800, query='select version()'
    [ fetched 1 rows ]
    [ PostgreSQL version string = 'PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3' ]
    [ PostgreSQL version number = '7.3' ]
conn=60503800, query='set DateStyle to 'ISO''
conn=60503800, query='set geqo to 'OFF''
conn=60503800, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=60503800, query='select pg_client_encoding()'
    [ fetched 1 rows ]
conn=60503800, query='set client_encoding to 'GBK''
conn=60503800, PGAPI_DriverConnect(out)='DSN=PostgreSQL30;DATABASE=xjy;SERVER=192.168.0.12;PORT=5432;UID=guoxf;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=pg_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0'
conn=60503800, query='select relname, nspname, relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v') and relname !~ '^pg_|^pg_' and pg_namespace.oid = relnamespace order by nspname, relname'
    [ fetched 1 rows ] 

mylog_xxx.log
-------------------------------------------
[3604]globals.extra_systable_prefixes = 'dd_;'
[3604][[SQLAllocHandle]][3604]**** in PGAPI_AllocEnv ** 
[3604]** exit PGAPI_AllocEnv: phenv = 60497808 **
[3604][[SQLSetEnvAttr]] att=200,2
[3604][[SQLAllocHandle]][3604]PGAPI_AllocConnect: entering...
[3604]**** PGAPI_AllocConnect: henv = 60497808, conn = 60503800
[3604]EN_add_connection: self = 60497808, conn = 60503800
[3604]       added at i =0, conn->henv = 60497808, conns[i]->henv = 60497808
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=77
[3604]PGAPI_GetInfo: p='03.00', len=0, value=0, cbMax=12
[3604][SQLDriverConnect][3604]PGAPI_DriverConnect: entering...
[3604]**** PGAPI_DriverConnect: fDriverCompletion=3, connStrIn='DSN=PostgreSQL30;'
[3604]our_connect_string = 'DSN=PostgreSQL30;'
[3604]attribute = 'DSN', value = 'PostgreSQL30'
[3604]copyAttributes: DSN='PostgreSQL30',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[3604]globals.extra_systable_prefixes = 'pg_;'
[3604]our_connect_string = 'DSN=PostgreSQL30;'
[3604]attribute = 'DSN', value = 'PostgreSQL30'
[3604]CopyCommonAttributes: A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=pg_;[3604]CC_connect: entering...
[3604]CC_connect(): DSN = 'PostgreSQL30', server = '192.168.0.12', port = '5432', database = 'xjy', username = 'guoxf', password='xxxxx'
[3604]connecting to the server socket...
[3604]connection to the server socket succeeded.
[3604]sizeof startup packet = 292
[3604]sent the authentication block.
[3604]sent the authentication block successfully.
[3604]gonna do authentication
[3604]read 15, global_socket_buffersize=4096
[3604]auth got 'R'
[3604]areq = 0
[3604]auth got 'K'
[3604]auth got 'Z'
[3604]sending an empty query...
[3604]send_query(): conn=60503800, query=' '
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 3, global_socket_buffersize=4096
[3604]send_query: got id = 'I'
[3604]send_query: got id = 'Z'
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=0
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]empty query seems to be OK.
[3604]CC_lookup_pg_version: entering...
[3604]PGAPI_AllocStmt: entering...
[3604]**** PGAPI_AllocStmt: hdbc = 60503800, stmt = 60498248
[3604]CC_add_statement: self=60503800, stmt=60498248
[3604]PGAPI_ExecDirect: entering...
[3604]**** PGAPI_ExecDirect: hstmt=60498248, statement='select version()'
[3604]PGAPI_ExecDirect: calling PGAPI_Execute...
[3604]PGAPI_Execute: entering...
[3604]PGAPI_Execute: clear errors...
[3604]recycle statement: self= 60498248
[3604]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=16, stmt='select version()'
[3604]   stmt_with_params = 'select version()'
[3604]       Sending SELECT statement on stmt=60498248, cursor_name='SQL_CUR039B2148'
[3604]send_query(): conn=60503800, query='select version()'
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 113, global_socket_buffersize=4096
[3604]send_query: got id = 'P'
[3604]send_query: got id = 'T'
[3604]QR_fetch_tuples: cursor = '', self->cursor=0
[3604]num_fields = 1
[3604]READING ATTTYPMOD
[3604]CI_read_fields: fieldname='version', adtid=25, adtsize=-1, atttypmod=-1
[3604]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[3604]MALLOC: tuple_size = 100, size = 800
[3604]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[3604]qresult: len=70, buffer='PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3'
[3604]end of tuple list -- setting inUse to false: this = 60498128
[3604]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[3604]send_query: got id = 'Z'
[3604]     done sending the query:
[3604]extend_column_bindings: entering ... self=60498336, bindings_allocated=0, num_columns=1
[3604]exit extend_column_bindings
[3604]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3604]PGAPI_Fetch: stmt = 60498248, stmt->result= 60498128
[3604]manual_result = 0, use_declarefetch = 0
[3604]**** SC_fetch: manual_result
[3604]fetch: cols=1, lf=0, opts = 60498336, opts->bindings = 60528056, buffer[] = 0
[3604]PGAPI_GetData: enter, stmt=60498248
[3604]     num_rows = 1
[3604]     value = 'PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3'
[3604]**** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3'
[3604]copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3', cbValueMax=128
[3604]DEFAULT: len = 70, ptr = 'PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3'
[3604]    SQL_C_CHAR, default: len = 70, cbValueMax = 128, rgbValueBindRow = 'PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3'
[3604]Got the PostgreSQL version string: 'PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3'
[3604]Extracted PostgreSQL version number: '7.3'
[3604]PGAPI_FreeStmt: entering...hstmt=60498248, fOption=1
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=1
[3604]row = 0, num_fields = 1
[3604]free [lf=0] 60527944
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]SC_Destructor: self=60498248, self->result=0, self->hdbc=60503800
[3604]reset_a_column_binding: entering ... self=60498336, bindings_allocated=1, icol=1
[3604]APD_free_params:  ENTER, self=60498392
[3604]IPD_free_params:  ENTER, self=60498420
[3604]IPD_free_params:  EXIT
[3604]SC_Destructor: EXIT
[3604]CC_send_settings: entering...
[3604]PGAPI_AllocStmt: entering...
[3604]**** PGAPI_AllocStmt: hdbc = 60503800, stmt = 60498248
[3604]CC_add_statement: self=60503800, stmt=60498248
[3604]PGAPI_ExecDirect: entering...
[3604]**** PGAPI_ExecDirect: hstmt=60498248, statement='set DateStyle to 'ISO''
[3604]PGAPI_ExecDirect: calling PGAPI_Execute...
[3604]PGAPI_Execute: entering...
[3604]PGAPI_Execute: clear errors...
[3604]recycle statement: self= 60498248
[3604]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=22, stmt='set DateStyle to 'ISO''
[3604]   stmt_with_params = 'set DateStyle to 'ISO''
[3604]      it's NOT a select statement: stmt=60498248
[3604]send_query(): conn=60503800, query='set DateStyle to 'ISO''
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 6, global_socket_buffersize=4096
[3604]send_query: got id = 'C'
[3604]send_query: ok - 'C' - SET
[3604]send_query: setting cmdbuffer = 'SET'
[3604]send_query: returning res = 60498128
[3604]send_query: got id = 'Z'
[3604]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3604]CC_send_settings: result 0, status 1 from set DateStyle
[3604]PGAPI_ExecDirect: entering...
[3604]**** PGAPI_ExecDirect: hstmt=60498248, statement='set geqo to 'OFF''
[3604]PGAPI_ExecDirect: calling PGAPI_Execute...
[3604]PGAPI_Execute: entering...
[3604]PGAPI_Execute: clear errors...
[3604]PGAPI_Execute: recycling statement (should have been done by app)...
[3604]recycle statement: self= 60498248
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=0
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]APD_free_params:  ENTER, self=60498392
[3604]IPD_free_params:  ENTER, self=60498420
[3604]IPD_free_params:  EXIT
[3604]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=17, stmt='set geqo to 'OFF''
[3604]   stmt_with_params = 'set geqo to 'OFF''
[3604]      it's NOT a select statement: stmt=60498248
[3604]send_query(): conn=60503800, query='set geqo to 'OFF''
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 6, global_socket_buffersize=4096
[3604]send_query: got id = 'C'
[3604]send_query: ok - 'C' - SET
[3604]send_query: setting cmdbuffer = 'SET'
[3604]send_query: returning res = 60498128
[3604]send_query: got id = 'Z'
[3604]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3604]CC_send_settings: result 0, status 1 from set geqo
[3604]PGAPI_FreeStmt: entering...hstmt=60498248, fOption=1
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=0
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]SC_Destructor: self=60498248, self->result=0, self->hdbc=60503800
[3604]APD_free_params:  ENTER, self=60498392
[3604]IPD_free_params:  ENTER, self=60498420
[3604]IPD_free_params:  EXIT
[3604]SC_Destructor: EXIT
[3604]CC_lookup_lo: entering...
[3604]PGAPI_AllocStmt: entering...
[3604]**** PGAPI_AllocStmt: hdbc = 60503800, stmt = 60498248
[3604]CC_add_statement: self=60503800, stmt=60498248
[3604]PGAPI_ExecDirect: entering...
[3604]**** PGAPI_ExecDirect: hstmt=60498248, statement='select oid from pg_type where typname='lo''
[3604]PGAPI_ExecDirect: calling PGAPI_Execute...
[3604]PGAPI_Execute: entering...
[3604]PGAPI_Execute: clear errors...
[3604]recycle statement: self= 60498248
[3604]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=42, stmt='select oid from pg_type where typname='lo''
[3604]   stmt_with_params = 'select oid from pg_type where typname='lo''
[3604]       Sending SELECT statement on stmt=60498248, cursor_name='SQL_CUR039B2148'
[3604]send_query(): conn=60503800, query='select oid from pg_type where typname='lo''
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 33, global_socket_buffersize=4096
[3604]send_query: got id = 'P'
[3604]send_query: got id = 'T'
[3604]QR_fetch_tuples: cursor = '', self->cursor=0
[3604]num_fields = 1
[3604]READING ATTTYPMOD
[3604]CI_read_fields: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1
[3604]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[3604]MALLOC: tuple_size = 100, size = 800
[3604]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[3604]end of tuple list -- setting inUse to false: this = 60498128
[3604]_next_tuple: 'C' fetch_total = 0 & this_fetch = 0
[3604]_next_tuple: 'C': DONE (fcount == 0)
[3604]send_query: got id = 'Z'
[3604]     done sending the query:
[3604]extend_column_bindings: entering ... self=60498336, bindings_allocated=0, num_columns=1
[3604]exit extend_column_bindings
[3604]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3604]PGAPI_Fetch: stmt = 60498248, stmt->result= 60498128
[3604]manual_result = 0, use_declarefetch = 0
[3604]PGAPI_FreeStmt: entering...hstmt=60498248, fOption=1
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=0
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]SC_Destructor: self=60498248, self->result=0, self->hdbc=60503800
[3604]reset_a_column_binding: entering ... self=60498336, bindings_allocated=1, icol=1
[3604]APD_free_params:  ENTER, self=60498392
[3604]IPD_free_params:  ENTER, self=60498420
[3604]IPD_free_params:  EXIT
[3604]SC_Destructor: EXIT
[3604]CC_lookup_characterset: entering...
[3604]send_query(): conn=60503800, query='select pg_client_encoding()'
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 63, global_socket_buffersize=4096
[3604]send_query: got id = 'P'
[3604]send_query: got id = 'T'
[3604]QR_fetch_tuples: cursor = '', self->cursor=0
[3604]num_fields = 1
[3604]READING ATTTYPMOD
[3604]CI_read_fields: fieldname='pg_client_encoding', adtid=19, adtsize=64, atttypmod=-1
[3604]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[3604]MALLOC: tuple_size = 100, size = 800
[3604]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[3604]qresult: len=9, buffer='SQL_ASCII'
[3604]end of tuple list -- setting inUse to false: this = 60498128
[3604]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[3604]send_query: got id = 'Z'
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=1
[3604]row = 0, num_fields = 1
[3604]free [lf=0] 60528032
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]send_query(): conn=60503800, query='set client_encoding to 'GBK''
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 6, global_socket_buffersize=4096
[3604]send_query: got id = 'C'
[3604]send_query: ok - 'C' - SET
[3604]send_query: setting cmdbuffer = 'SET'
[3604]send_query: returning res = 60498128
[3604]send_query: got id = 'Z'
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=0
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]CC_connect: returning...
[3604]szConnStrOut = 'DSN=PostgreSQL30;DATABASE=xjy;SERVER=192.168.0.12;PORT=5432;UID=guoxf;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=pg_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0' len=545,1024
[3604]PGAPI_DriverConnect: returning 0
[3604][[SQLGetDiagRec]]
[3604]PGAPI_GetDiagRec entering rec=1[3604]**** PGAPI_ConnectError: hdbc=60503800 <0>
[3604]enter CC_get_error
[3604]enter CC_create_errormsg
[3604]msg = ''
[3604]exit CC_create_errormsg
[3604]exit CC_get_error
[3604]CC_Get_error returned nothing.
[3604]PGAPI_GetDiagRec exiting 100
[3604][SQLGetFunctions][3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=23
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=24
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=79
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=31, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=83
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=7, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=78
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=81
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=15, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=72
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=10, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=82
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=90, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=44
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=19, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=43
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=5, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=144
[3604]PGAPI_GetInfo30: p='<NULL>', len=4, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=150
[3604]PGAPI_GetInfo30: p='<NULL>', len=4, value=990799, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=167
[3604]PGAPI_GetInfo30: p='<NULL>', len=4, value=990799, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=146
[3604]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=151
[3604]PGAPI_GetInfo30: p='<NULL>', len=4, value=4213, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=168
[3604]PGAPI_GetInfo30: p='<NULL>', len=4, value=4213, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=111
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=512
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=16
[3604]PGAPI_GetInfo: p='', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=23
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=24
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=46
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3604][[SQLSetConnectAttr]] 1
[3604]PGAPI_SetConnectAttr 1
[3604]PGAPI_SetConnectOption: entering fOption = 1 vParam = 0
[3604]SetStmtOption(): SQL_MAX_ROWS, vParam = 0
[3604][[SQLSetConnectAttr]] 0
[3604]PGAPI_SetConnectAttr 0
[3604]PGAPI_SetConnectOption: entering fOption = 0 vParam = 0
[3604]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=6
[3604]PGAPI_GetInfo: p='PSQLODBC30.DLL', len=0, value=0, cbMax=52
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=6
[3604]PGAPI_GetInfo: p='PSQLODBC30.DLL', len=0, value=0, cbMax=52
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=6
[3604]PGAPI_GetInfo: p='PSQLODBC30.DLL', len=0, value=0, cbMax=52
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=6
[3604]PGAPI_GetInfo: p='PSQLODBC30.DLL', len=0, value=0, cbMax=48
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=1
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][[SQLGetConnectAttr]] 109
[3604]PGAPI_GetConnectAttr 109
[3604]PGAPI_GetConnectOption: entering...
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=0
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=128, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=114
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=42
[3604]PGAPI_GetInfo: p='', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=42
[3604]PGAPI_GetInfo: p='', len=0, value=0, cbMax=2
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=92
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=75
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=22
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=2
[3604]PGAPI_GetInfo: p='PostgreSQL30', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=2
[3604]PGAPI_GetInfo: p='PostgreSQL30', len=0, value=0, cbMax=26
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=25
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=17
[3604]PGAPI_GetInfo: p='PostgreSQL', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=17
[3604]PGAPI_GetInfo: p='PostgreSQL', len=0, value=0, cbMax=22
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=18
[3604]PGAPI_GetInfo: p='07.03.0200 PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=18
[3604]PGAPI_GetInfo: p='07.03.0200 PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3', len=0, value=0, cbMax=164
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=88
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=28
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=102
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=104
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=103
[3604]PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=106
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=85
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=4, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=90
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=24
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=23
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=40
[3604]PGAPI_GetInfo: p='procedure', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=40
[3604]PGAPI_GetInfo: p='procedure', len=0, value=0, cbMax=20
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=93
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=3, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=39
[3604]PGAPI_GetInfo: p='schema', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=39
[3604]PGAPI_GetInfo: p='schema', len=0, value=0, cbMax=14
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=91
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=29, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=15
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=73
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=95
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=15, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=45
[3604]PGAPI_GetInfo: p='table', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=45
[3604]PGAPI_GetInfo: p='table', len=0, value=0, cbMax=12
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=47
[3604]PGAPI_GetInfo: p='guoxf', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=47
[3604]PGAPI_GetInfo: p='guoxf', len=0, value=0, cbMax=12
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=36
[3604]PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4
[3604][[SQLGetConnectAttr]] 1209
[3604]PGAPI_GetConnectAttr 1209
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=13
[3604]PGAPI_GetInfo: p='192.168.0.12', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=13
[3604]PGAPI_GetInfo: p='192.168.0.12', len=0, value=0, cbMax=26
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=20
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=19
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=73
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=115
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=127, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=21
[3604]PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=6
[3604]PGAPI_GetInfo: p='PSQLODBC30.DLL', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=6
[3604]PGAPI_GetInfo: p='PSQLODBC30.DLL', len=0, value=0, cbMax=30
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=7
[3604]PGAPI_GetInfo: p='07.03.0200', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=7
[3604]PGAPI_GetInfo: p='07.03.0200', len=0, value=0, cbMax=22
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=113
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=113
[3604]PGAPI_GetInfo: p='N', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=94
[3604]PGAPI_GetInfo: p='_', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=94
[3604]PGAPI_GetInfo: p='_', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=97
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=98
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=99
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=100
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=101
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=49
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=15
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=38
[3604]PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=0
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=38
[3604]PGAPI_GetInfo: p='Y', len=0, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=50
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=7289, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=51
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=52
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=84
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=1
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=26
[3604]PGAPI_GetInfo: p='<NULL>', len=4, value=2, cbMax=4
[3604][[SQLAllocHandle]][3604]PGAPI_AllocStmt: entering...
[3604]**** PGAPI_AllocStmt: hdbc = 60503800, stmt = 60498248
[3604]CC_add_statement: self=60503800, stmt=60498248
[3604][[SQLGetStmtAttr]] Handle=60498248 10010
[3604]PGAPI_GetStmtAttr Handle=60498248 10010
[3604][[SQLGetStmtAttr]] Handle=60498248 10011
[3604]PGAPI_GetStmtAttr Handle=60498248 10011
[3604][[SQLGetStmtAttr]] Handle=60498248 10012
[3604]PGAPI_GetStmtAttr Handle=60498248 10012
[3604][[SQLGetStmtAttr]] Handle=60498248 10013
[3604]PGAPI_GetStmtAttr Handle=60498248 10013
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=93
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=3, cbMax=2
[3604][SQLGetInfo(30)][3604]PGAPI_GetInfo: entering...fInfoType=34
[3604]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=2
[3604][SQLTables][3604]PGAPI_Tables: entering...stmt=60498248 scnm=40c2310 len=0
[3604]PGAPI_AllocStmt: entering...
[3604]**** PGAPI_AllocStmt: hdbc = 60503800, stmt = 60523624
[3604]CC_add_statement: self=60503800, stmt=60523624
[3604]PGAPI_ExecDirect: entering...
[3604]**** PGAPI_ExecDirect: hstmt=60523624, statement='select relname, nspname, relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v') and relname !~ '^pg_|^pg_' and pg_namespace.oid = relnamespace order by nspname, relname'
[3604]PGAPI_ExecDirect: calling PGAPI_Execute...
[3604]PGAPI_Execute: entering...
[3604]PGAPI_Execute: clear errors...
[3604]recycle statement: self= 60523624
[3604]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=199, stmt='select relname, nspname, relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v') and relname !~ '^pg_|^pg_' and pg_namespace.oid = relnamespace order by nspname, relname'
[3604]   stmt_with_params = 'select relname, nspname, relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v') and relname !~ '^pg_|^pg_' and pg_namespace.oid = relnamespace order by nspname, relname'
[3604]       Sending SELECT statement on stmt=60523624, cursor_name='SQL_CUR039B8468'
[3604]send_query(): conn=60503800, query='select relname, nspname, relkind from pg_catalog.pg_class, pg_catalog.pg_namespace where relkind in ('r', 'v') and relname !~ '^pg_|^pg_' and pg_namespace.oid = relnamespace order by nspname, relname'
[3604]send_query: done sending query
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]read 103, global_socket_buffersize=4096
[3604]send_query: got id = 'P'
[3604]send_query: got id = 'T'
[3604]QR_fetch_tuples: cursor = '', self->cursor=0
[3604]num_fields = 3
[3604]READING ATTTYPMOD
[3604]CI_read_fields: fieldname='relname', adtid=19, adtsize=64, atttypmod=-1
[3604]READING ATTTYPMOD
[3604]CI_read_fields: fieldname='nspname', adtid=19, adtsize=64, atttypmod=-1
[3604]READING ATTTYPMOD
[3604]CI_read_fields: fieldname='relkind', adtid=18, adtsize=1, atttypmod=-1
[3604]QR_fetch_tuples: past CI_read_fields: num_fields = 3
[3604]MALLOC: tuple_size = 100, size = 2400
[3604]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[3604]qresult: len=9, buffer='employees'
[3604]qresult: len=6, buffer='public'
[3604]qresult: len=1, buffer='r'
[3604]end of tuple list -- setting inUse to false: this = 60498128
[3604]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[3604]send_query: got id = 'Z'
[3604]     done sending the query:
[3604]extend_column_bindings: entering ... self=60523712, bindings_allocated=0, num_columns=3
[3604]exit extend_column_bindings
[3604]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3604]PGAPI_BindCol: entering...
[3604]**** PGAPI_BindCol: stmt = 60523624, icol = 1
[3604]**** : fCType=1 rgb=1394f8 valusMax=128 pcb=0
[3604]       bound buffer[0] = 1283320
[3604]PGAPI_BindCol: entering...
[3604]**** PGAPI_BindCol: stmt = 60523624, icol = 2
[3604]**** : fCType=1 rgb=139678 valusMax=128 pcb=0
[3604]       bound buffer[1] = 1283704
[3604]PGAPI_BindCol: entering...
[3604]**** PGAPI_BindCol: stmt = 60523624, icol = 3
[3604]**** : fCType=1 rgb=1395f8 valusMax=128 pcb=0
[3604]       bound buffer[2] = 1283576
[3604]in QR_Constructor
[3604]exit QR_Constructor
[3604]extend_column_bindings: entering ... self=60498336, bindings_allocated=0, num_columns=5
[3604]exit extend_column_bindings
[3604]in QR_set_num_fields
[3604]in TL_Constructor
[3604]exit TL_Constructor
[3604]exit QR_set_num_fields
[3604]PGAPI_Fetch: stmt = 60523624, stmt->result= 60498128
[3604]manual_result = 0, use_declarefetch = 0
[3604]**** SC_fetch: manual_result
[3604]fetch: cols=3, lf=0, opts = 60523712, opts->bindings = 60526736, buffer[] = 1283320
[3604]type = 19
[3604]value = 'employees'
[3604]copy_and_convert: field_type = 19, fctype = 1, value = 'employees', cbValueMax=128
[3604]DEFAULT: len = 9, ptr = 'employees'
[3604]    SQL_C_CHAR, default: len = 9, cbValueMax = 128, rgbValueBindRow = 'employees'
[3604]copy_and_convert: retval = 0
[3604]fetch: cols=3, lf=1, opts = 60523712, opts->bindings = 60526736, buffer[] = 1283704
[3604]type = 19
[3604]value = 'public'
[3604]copy_and_convert: field_type = 19, fctype = 1, value = 'public', cbValueMax=128
[3604]DEFAULT: len = 6, ptr = 'public'
[3604]    SQL_C_CHAR, default: len = 6, cbValueMax = 128, rgbValueBindRow = 'public'
[3604]copy_and_convert: retval = 0
[3604]fetch: cols=3, lf=2, opts = 60523712, opts->bindings = 60526736, buffer[] = 1283576
[3604]type = 18
[3604]value = 'r'
[3604]copy_and_convert: field_type = 18, fctype = 1, value = 'r', cbValueMax=128
[3604]DEFAULT: len = 1, ptr = 'r'
[3604]    SQL_C_CHAR, default: len = 1, cbValueMax = 128, rgbValueBindRow = 'r'
[3604]copy_and_convert: retval = 0
[3604]table_name='employees', prefix[0]='pg_'
[3604]PGAPI_Tables: table_name = 'employees'
[3604]PGAPI_Fetch: stmt = 60523624, stmt->result= 60498128
[3604]manual_result = 0, use_declarefetch = 0
[3604]PGAPI_FreeStmt: entering...hstmt=60523624, fOption=1
[3604]QResult: in DESTRUCTOR
[3604]QResult: free memory in, fcount=1
[3604]row = 0, num_fields = 3
[3604]free [lf=0] 60526640
[3604]free [lf=1] 60526664
[3604]free [lf=2] 60526688
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]SC_Destructor: self=60523624, self->result=0, self->hdbc=60503800
[3604]reset_a_column_binding: entering ... self=60523712, bindings_allocated=3, icol=1
[3604]reset_a_column_binding: entering ... self=60523712, bindings_allocated=3, icol=2
[3604]reset_a_column_binding: entering ... self=60523712, bindings_allocated=3, icol=3
[3604]APD_free_params:  ENTER, self=60523768
[3604]IPD_free_params:  ENTER, self=60523796
[3604]IPD_free_params:  EXIT
[3604]SC_Destructor: EXIT
[3604]PGAPI_Tables: EXIT,  stmt=60498248
[3604][SQLBindCol][3604]PGAPI_BindCol: entering...
[3604]**** PGAPI_BindCol: stmt = 60498248, icol = 1
[3604]**** : fCType=1 rgb=3b47808 valusMax=256 pcb=3b47804
[3604]       bound buffer[0] = 62158856
[3604][SQLBindCol][3604]PGAPI_BindCol: entering...
[3604]**** PGAPI_BindCol: stmt = 60498248, icol = 5
[3604]**** : fCType=1 rgb=3b47910 valusMax=510 pcb=3b4790c
[3604]       bound buffer[4] = 62159120
[3604][[SQLFetch]][3604]PGAPI_ExtendedFetch: stmt=60498248
[3604]SQL_FETCH_NEXT: num_tuples=1, currtuple=-1
[3604]PGAPI_ExtendedFetch: new currTuple = -1
[3604]manual_result = 1, use_declarefetch = 0
[3604]**** SC_fetch: manual_result
[3604]fetch: cols=5, lf=0, opts = 60498336, opts->bindings = 60532432, buffer[] = 62158856
[3604]type = 1043
[3604]manual_result
[3604]value = '<NULL>'
[3604]copy_and_convert: field_type = 1043, fctype = 1, value = '<NULL>', cbValueMax=256
[3604]copy_and_convert: retval = 0
[3604]fetch: cols=5, lf=1, opts = 60498336, opts->bindings = 60532432, buffer[] = 0
[3604]fetch: cols=5, lf=2, opts = 60498336, opts->bindings = 60532432, buffer[] = 0
[3604]fetch: cols=5, lf=3, opts = 60498336, opts->bindings = 60532432, buffer[] = 0
[3604]fetch: cols=5, lf=4, opts = 60498336, opts->bindings = 60532432, buffer[] = 62159120
[3604]type = 1043
[3604]manual_result
[3604]value = ''
[3604]copy_and_convert: field_type = 1043, fctype = 1, value = '', cbValueMax=510
[3604]DEFAULT: len = 0, ptr = ''
[3604]    SQL_C_CHAR, default: len = 0, cbValueMax = 510, rgbValueBindRow = ''
[3604]copy_and_convert: retval = 0
[3604][[SQLFreeHandle]][3604]PGAPI_FreeStmt: entering...hstmt=60498248, fOption=1
[3604]QResult: in DESTRUCTOR
[3604]TupleList: in DESTRUCTOR
[3604]TupleList: exit DESTRUCTOR
[3604]QResult: free memory in, fcount=0
[3604]QResult: free memory out
[3604]QResult: exit DESTRUCTOR
[3604]SC_Destructor: self=60498248, self->result=0, self->hdbc=60503800
[3604]reset_a_column_binding: entering ... self=60498336, bindings_allocated=5, icol=1
[3604]reset_a_column_binding: entering ... self=60498336, bindings_allocated=5, icol=2
[3604]reset_a_column_binding: entering ... self=60498336, bindings_allocated=5, icol=3
[3604]reset_a_column_binding: entering ... self=60498336, bindings_allocated=5, icol=4
[3604]reset_a_column_binding: entering ... self=60498336, bindings_allocated=5, icol=5
[3604]APD_free_params:  ENTER, self=60498392
[3604]IPD_free_params:  ENTER, self=60498420
[3604]IPD_free_params:  EXIT
[3604]SC_Destructor: EXIT 





Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2004-02-01 17:17:44
Subject: Re: Need community help about ODBC .---- Can't fetch the data resource from server.
Previous:From: Lothar BehrensDate: 2004-01-31 18:00:30
Subject: Connecting problem using iODBC under linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group