Please take our Survey
logo       
<prev   next>

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Need community help about ODBC .---- Can't fetch the data resource from ser: msg#00000

db.postgresql.odbc

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

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





---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
<Prev in Thread] Current Thread [Next in Thread>
Next by Date:  Re: Need community help about ODBC .---- Can't fetch the data resource from server., Jeff Eckermann
Next by Thread:  Re: Need community help about ODBC .---- Can't fetch the data resource from server., Jeff Eckermann
Indexes:  [Date] [Thread] [Top] [All Lists]

Google Custom Search
Recently Viewed:
qnx.openqnx.dev...    gcc.libstdc++.c...    solaris.opensol...    information-ret...    misc.misterhous...    web.catalyst.ge...    apache.webservi...    redhat.release....    hardware.lirc/2...    kernel.autofs/2...    technology.sust...    linux.vdr/2003-...    editors.lyx.gen...    org.user-groups...    netbsd.devel.pk...    xdg.devel/2004-...    version-control...    jakarta.slide.d...    debian.packages...    creativecommons...    ports.ppc.embed...    bug-tracking.bu...   
Home | blog view | USPTO Patent Archive | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe