IS it a BUG !?

From: 吴 允彬 <wwyb(at)mail(dot)ifuyao(dot)com>
To: pgsql-odbc(at)postgresql(dot)org <pgsql-odbc(at)postgresql(dot)org>
Subject: IS it a BUG !?
Date: 2005-07-13 06:15:27
Message-ID: 20050713062025.CF26D52BA9@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dear pgsql
I did not know whether it was a bug,but it occur often exactly,and I eager to know the reason to solve it.

I cannot open the recordset of progres database,below:

I using ODBC driver to connect the POSTGRES database
----------------------------------------------------
ENVIROMENT:
OS: WINXP SP
database: POSTGRES 8.0.3
ODBC: Ver:8.00.01.01 psqlodbc.msi
develop tool: VB6.0 SP6
-----------------------------------------------------
MY CODES:
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim ssql As String
Set cnn = New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open "Provider=MSDASQL.1;Password=btof;Persist Security Info=True;User ID=btof;Data Source=PostgreSQL"

Set rs = New ADODB.Recordset
** rs.Open "rcpparta", cnn, adOpenForwardOnly, adLockReadOnly, adCmdText
------------------------------------------------------------

"cnn.open" can execute as normal,and when testing it connect well,but when do "rs.open",or binding ADODC1 to DATAGRID1.datasource property,they both cause VB abnormal error,and then VB application was closed,ask me send error report.
I have resetup VB \ODBC more times,but it still no change.

so I expect this was updataed,thanks

best regard
Wuyunbin

follows are attachment: psqlodbc.log mylog.log
--------------------------------------------------
psqlodbc_2900.log:

Global Options: Version='08.00.0101', fetch=100, socket=8192, 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='dd_;', conn_settings='' conn_encoding='OTHER'
conn=59586304, query=' '
conn=59586304, query='select version()'
[ fetched 1 rows ]
[ PostgreSQL version string = 'PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)' ]
[ PostgreSQL version number = '8.0' ]
conn=59586304, query='set DateStyle to 'ISO''
conn=59586304, query='set geqo to 'OFF''
conn=59586304, query='set extra_float_digits to 2'
conn=59586304, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=59586304, query='select pg_client_encoding()'
[ fetched 1 rows ]
[ Client encoding = 'UNICODE' (code = 6) ]
conn=59586304, PGAPI_DriverConnect(out)='DSN=PostgreSQL;DATABASE=BTOFDB;SERVER=192.168.243.8;PORT=5432;UID=btof;PWD=xxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=8192;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=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0'
DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='', errnum=11, errmsg='bad parameter number'

------------------------------
mylog_2900.log:

[3356]CC_connect: entering...
[3356]CC_connect(): DSN = 'PostgreSQL', server = '192.168.243.8', port = '5432', database = 'BTOFDB', username = 'btof', password='xxxxx'
[3356]connecting to the server socket...
[3356]connection to the server socket succeeded.
[3356]sizeof startup packet = 292
[3356]sent the authentication block.
[3356]sent the authentication block successfully.
[3356]gonna do authentication
[3356]read 9, global_socket_buffersize=8192
[3356]auth got 'R'
[3356]areq = 5
[3356]in AUTH_REQ_MD5
[3356]read 15, global_socket_buffersize=8192
[3356]auth got 'R'
[3356]areq = 0
[3356]auth got 'K'
[3356]auth got 'Z'
[3356]sending an empty query...
[3356]send_query(): conn=59586304, query=' '
[3356]send_query: done sending query
[3356]in QR_Constructor
[3356]exit QR_Constructor
[3356]read 3, global_socket_buffersize=8192
[3356]send_query: got id = 'I'
[3356]send_query: got id = 'Z'
[3356]QResult: in DESTRUCTOR
[3356]QResult: free memory in, fcount=0
[3356]QResult: free memory out
[3356]QResult: exit DESTRUCTOR
[3356]empty query seems to be OK.
[3356]CC_lookup_pg_version: entering...
[3356]PGAPI_AllocStmt: entering...
[3356]**** PGAPI_AllocStmt: hdbc = 59586304, stmt = 59614768
[3356]CC_add_statement: self=59586304, stmt=59614768
[3356]PGAPI_ExecDirect: entering...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]**** PGAPI_ExecDirect: hstmt=59614768, statement='select version()'
[3356]PGAPI_ExecDirect: calling PGAPI_Execute...
[3356]PGAPI_Execute: entering...
[3356]PGAPI_Execute: clear errors...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=16, stmt='select version()'
[3356] stmt_with_params = 'select version()'
[3356] Sending SELECT statement on stmt=59614768, cursor_name='SQL_CUR038DA630'
[3356]send_query(): conn=59586304, query='select version()'
[3356]send_query: done sending query
[3356]in QR_Constructor
[3356]exit QR_Constructor
[3356]read 162, global_socket_buffersize=8192
[3356]send_query: got id = 'P'
[3356]send_query: got id = 'T'
[3356]QR_fetch_tuples: cursor = '', self->cursor=0
[3356]num_fields = 1
[3356]READING ATTTYPMOD
[3356]CI_read_fields: fieldname='version', adtid=25, adtsize=-1, atttypmod=-1
[3356]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[3356]MALLOC: tuple_size = 100, size = 800
[3356]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[3356]qresult: len=119, buffer='PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)'
[3356]end of tuple list -- setting inUse to false: this = 59581056
[3356]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[3356]send_query: got id = 'Z'
[3356] done sending the query:
[3356]extend_column_bindings: entering ... self=59614904, bindings_allocated=0, num_columns=1
[3356]exit extend_column_bindings
[3356]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3356]PGAPI_Fetch: stmt = 59614768, stmt->result= 59581056
[3356]manual_result = 0, use_declarefetch = 0
[3356]**** SC_fetch: manual_result
[3356]extend_getdata_info: entering ... self=59615116, gdata_allocated=0, num_columns=1
[3356]exit extend_gdata_info
[3356]fetch: cols=1, lf=0, opts = 59614904, opts->bindings = 59620584, buffer[] = 0
[3356]PGAPI_GetData: enter, stmt=59614768
[3356] num_rows = 1
[3356] value = 'PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)'
[3356]**** PGAPI_GetData: icol = 0, fCType = 1, field_type = 25, value = 'PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)'
[3356]copy_and_convert: field_type = 25, fctype = 1, value = 'PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)', cbValueMax=128
[3356]DEFAULT: len = 119, ptr = 'PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)'
[3356] SQL_C_CHAR, default: len = 119, cbValueMax = 128, rgbValueBindRow = 'PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)'
[3356]Got the PostgreSQL version string: 'PostgreSQL 8.0.3 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.0.0 20050505 (Red Hat 4.0.0-4)'
[3356]Extracted PostgreSQL version number: '8.0'
[3356]PGAPI_FreeStmt: entering...hstmt=59614768, fOption=1
[3356]QResult: in DESTRUCTOR
[3356]QResult: free memory in, fcount=1
[3356]row = 0, num_fields = 1
[3356]free [lf=0] 59620424
[3356]QResult: free memory out
[3356]QResult: exit DESTRUCTOR
[3356]SC_Destructor: self=59614768, self->result=0, self->hdbc=59586304
[3356]ARDFields_free 38da6b8 bookmark=38d2308[3356]ARD_unbind_cols freeall=1 allocated=1 bindings=38dbce8[3356]reset_a_column_binding: entering ... self=59614904, bindings_allocated=1, icol=1
[3356]APD_free_params: ENTER, self=59615020
[3356]IPD_free_params: ENTER, self=59615084
[3356]GDATA_unbind_cols freeall=1 allocated=1 gdata=38dbd10[3356]SC_Destructor: EXIT
[3356]CC_send_settings: entering...
[3356]PGAPI_AllocStmt: entering...
[3356]**** PGAPI_AllocStmt: hdbc = 59586304, stmt = 59614768
[3356]CC_add_statement: self=59586304, stmt=59614768
[3356]PGAPI_ExecDirect: entering...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]**** PGAPI_ExecDirect: hstmt=59614768, statement='set DateStyle to 'ISO''
[3356]PGAPI_ExecDirect: calling PGAPI_Execute...
[3356]PGAPI_Execute: entering...
[3356]PGAPI_Execute: clear errors...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=22, stmt='set DateStyle to 'ISO''
[3356] stmt_with_params = 'set DateStyle to 'ISO''
[3356] it's NOT a select statement: stmt=59614768
[3356]send_query(): conn=59586304, query='set DateStyle to 'ISO''
[3356]send_query: done sending query
[3356]in QR_Constructor
[3356]exit QR_Constructor
[3356]read 6, global_socket_buffersize=8192
[3356]send_query: got id = 'C'
[3356]send_query: ok - 'C' - SET
[3356]send_query: setting cmdbuffer = 'SET'
[3356]send_query: returning res = 59581056
[3356]send_query: got id = 'Z'
[3356]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3356]CC_send_settings: result 0, status 1 from set DateStyle
[3356]PGAPI_ExecDirect: entering...
[3356]recycle statement: self= 59614768
[3356]QResult: in DESTRUCTOR
[3356]QResult: free memory in, fcount=0
[3356]QResult: free memory out
[3356]QResult: exit DESTRUCTOR
[3356]PDATA_free_params: ENTER, self=59615192
[3356]**** PGAPI_ExecDirect: hstmt=59614768, statement='set geqo to 'OFF''
[3356]PGAPI_ExecDirect: calling PGAPI_Execute...
[3356]PGAPI_Execute: entering...
[3356]PGAPI_Execute: clear errors...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=17, stmt='set geqo to 'OFF''
[3356] stmt_with_params = 'set geqo to 'OFF''
[3356] it's NOT a select statement: stmt=59614768
[3356]send_query(): conn=59586304, query='set geqo to 'OFF''
[3356]send_query: done sending query
[3356]in QR_Constructor
[3356]exit QR_Constructor
[3356]read 6, global_socket_buffersize=8192
[3356]send_query: got id = 'C'
[3356]send_query: ok - 'C' - SET
[3356]send_query: setting cmdbuffer = 'SET'
[3356]send_query: returning res = 59581056
[3356]send_query: got id = 'Z'
[3356]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3356]CC_send_settings: result 0, status 1 from set geqo
[3356]PGAPI_ExecDirect: entering...
[3356]recycle statement: self= 59614768
[3356]QResult: in DESTRUCTOR
[3356]QResult: free memory in, fcount=0
[3356]QResult: free memory out
[3356]QResult: exit DESTRUCTOR
[3356]PDATA_free_params: ENTER, self=59615192
[3356]**** PGAPI_ExecDirect: hstmt=59614768, statement='set extra_float_digits to 2'
[3356]PGAPI_ExecDirect: calling PGAPI_Execute...
[3356]PGAPI_Execute: entering...
[3356]PGAPI_Execute: clear errors...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=27, stmt='set extra_float_digits to 2'
[3356] stmt_with_params = 'set extra_float_digits to 2'
[3356] it's NOT a select statement: stmt=59614768
[3356]send_query(): conn=59586304, query='set extra_float_digits to 2'
[3356]send_query: done sending query
[3356]in QR_Constructor
[3356]exit QR_Constructor
[3356]read 6, global_socket_buffersize=8192
[3356]send_query: got id = 'C'
[3356]send_query: ok - 'C' - SET
[3356]send_query: setting cmdbuffer = 'SET'
[3356]send_query: returning res = 59581056
[3356]send_query: got id = 'Z'
[3356]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3356]CC_send_settings: result 0, status 1 from set extra_float_digits
[3356]PGAPI_FreeStmt: entering...hstmt=59614768, fOption=1
[3356]QResult: in DESTRUCTOR
[3356]QResult: free memory in, fcount=0
[3356]QResult: free memory out
[3356]QResult: exit DESTRUCTOR
[3356]SC_Destructor: self=59614768, self->result=0, self->hdbc=59586304
[3356]ARDFields_free 38da6b8 bookmark=38dbce8[3356]ARD_unbind_cols freeall=1 allocated=0 bindings=0[3356]APD_free_params: ENTER, self=59615020
[3356]IPD_free_params: ENTER, self=59615084
[3356]GDATA_unbind_cols freeall=1 allocated=0 gdata=0[3356]SC_Destructor: EXIT
[3356]CC_lookup_lo: entering...
[3356]PGAPI_AllocStmt: entering...
[3356]**** PGAPI_AllocStmt: hdbc = 59586304, stmt = 59614768
[3356]CC_add_statement: self=59586304, stmt=59614768
[3356]PGAPI_ExecDirect: entering...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]**** PGAPI_ExecDirect: hstmt=59614768, statement='select oid from pg_type where typname='lo''
[3356]PGAPI_ExecDirect: calling PGAPI_Execute...
[3356]PGAPI_Execute: entering...
[3356]PGAPI_Execute: clear errors...
[3356]recycle statement: self= 59614768
[3356]PDATA_free_params: ENTER, self=59615192
[3356]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=42, stmt='select oid from pg_type where typname='lo''
[3356] stmt_with_params = 'select oid from pg_type where typname='lo''
[3356] Sending SELECT statement on stmt=59614768, cursor_name='SQL_CUR038DA630'
[3356]send_query(): conn=59586304, query='select oid from pg_type where typname='lo''
[3356]send_query: done sending query
[3356]in QR_Constructor
[3356]exit QR_Constructor
[3356]read 33, global_socket_buffersize=8192
[3356]send_query: got id = 'P'
[3356]send_query: got id = 'T'
[3356]QR_fetch_tuples: cursor = '', self->cursor=0
[3356]num_fields = 1
[3356]READING ATTTYPMOD
[3356]CI_read_fields: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1
[3356]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[3356]MALLOC: tuple_size = 100, size = 800
[3356]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[3356]end of tuple list -- setting inUse to false: this = 59581056
[3356]_next_tuple: 'C' fetch_total = 0 & this_fetch = 0
[3356]_next_tuple: 'C': DONE (fcount == 0)
[3356]send_query: got id = 'Z'
[3356] done sending the query:
[3356]extend_column_bindings: entering ... self=59614904, bindings_allocated=0, num_columns=1
[3356]exit extend_column_bindings
[3356]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[3356]PGAPI_Fetch: stmt = 59614768, stmt->result= 59581056
[3356]manual_result = 0, use_declarefetch = 0
[3356]PGAPI_FreeStmt: entering...hstmt=59614768, fOption=1
[3356]QResult: in DESTRUCTOR
[3356]QResult: free memory in, fcount=0
[3356]QResult: free memory out
[3356]QResult: exit DESTRUCTOR
[3356]SC_Destructor: self=59614768, self->result=0, self->hdbc=59586304
[3356]ARDFields_free 38da6b8 bookmark=38dbce8[3356]ARD_unbind_cols freeall=1 allocated=1 bindings=38db880[3356]reset_a_column_binding: entering ... self=59614904, bindings_allocated=1, icol=1
[3356]APD_free_params: ENTER, self=59615020
[3356]IPD_free_params: ENTER, self=59615084
[3356]GDATA_unbind_cols freeall=1 allocated=0 gdata=0[3356]SC_Destructor: EXIT
[3356]CC_lookup_characterset: entering...
[3356]send_query(): conn=59586304, query='select pg_client_encoding()'
[3356]send_query: done sending query
[3356]in QR_Constructor
[3356]exit QR_Constructor
[3356]read 61, global_socket_buffersize=8192
[3356]send_query: got id = 'P'
[3356]send_query: got id = 'T'
[3356]QR_fetch_tuples: cursor = '', self->cursor=0
[3356]num_fields = 1
[3356]READING ATTTYPMOD
[3356]CI_read_fields: fieldname='pg_client_encoding', adtid=19, adtsize=64, atttypmod=-1
[3356]QR_fetch_tuples: past CI_read_fields: num_fields = 1
[3356]MALLOC: tuple_size = 100, size = 800
[3356]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[3356]qresult: len=7, buffer='UNICODE'
[3356]end of tuple list -- setting inUse to false: this = 59581056
[3356]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[3356]send_query: got id = 'Z'
[3356]QResult: in DESTRUCTOR
[3356]QResult: free memory in, fcount=1
[3356]row = 0, num_fields = 1
[3356]free [lf=0] 59619544
[3356]QResult: free memory out
[3356]QResult: exit DESTRUCTOR
[3356]CC_connect: returning...
[3356]szConnStrOut = 'DSN=PostgreSQL;DATABASE=BTOFDB;SERVER=192.168.243.8;PORT=5432;UID=btof;PWD=xxxx;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=8192;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=dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0' len=550,1024
[3356]PGAPI_DriverConnect: returning 0
[3356][SQLGetDiagRecW][3356]PGAPI_GetDiagRec entering rec=1[3356]**** PGAPI_ConnectError: hdbc=59586304 <0>
[3356]enter CC_get_error
[3356]enter CC_create_errormsg
[3356]msg = ''
[3356]exit CC_create_errormsg
[3356]exit CC_get_error
[3356]CC_Get_error returned nothing.
[3356]PGAPI_GetDiagRec exiting 100
[3356][SQLGetFunctions][3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=23
[3356]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=24
[3356]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=79
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=3, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=83
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=0, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=78
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=81
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=15, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=72
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=10, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=82
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=90, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=44
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=17, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=43
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=1, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=144
[3356]PGAPI_GetInfo30: p='<NULL>', len=4, value=0, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=150
[3356]PGAPI_GetInfo30: p='<NULL>', len=4, value=4687, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=167
[3356]PGAPI_GetInfo30: p='<NULL>', len=4, value=4687, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=146
[3356]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=151
[3356]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=168
[3356]PGAPI_GetInfo30: p='<NULL>', len=4, value=1, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=111
[3356]PGAPI_GetInfo: p='N', len=2, value=0, cbMax=512
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=16
[3356]PGAPI_GetInfo: p='', len=0, value=0, cbMax=0
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=23
[3356]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=24
[3356]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=46
[3356]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=4
[3356][SQLSetConnectAttrW][3356]PGAPI_SetConnectAttr 1
[3356]PGAPI_SetConnectOption: entering fOption = 1 vParam = 0
[3356]SetStmtOption(): SQL_MAX_ROWS, vParam = 0
[3356][SQLSetConnectAttrW][3356]PGAPI_SetConnectAttr 0
[3356]PGAPI_SetConnectOption: entering fOption = 0 vParam = 0
[3356]SetStmtOption: SQL_QUERY_TIMEOUT, vParam = 0
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=6
[3356]PGAPI_GetInfo: p='PSQLODBC.DLL', len=24, value=0, cbMax=52
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=6
[3356]PGAPI_GetInfo: p='PSQLODBC.DLL', len=24, value=0, cbMax=52
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=6
[3356]PGAPI_GetInfo: p='PSQLODBC.DLL', len=24, value=0, cbMax=52
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=6
[3356]PGAPI_GetInfo: p='PSQLODBC.DLL', len=24, value=0, cbMax=48
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=1
[3356]PGAPI_GetInfo: p='<NULL>', len=2, value=0, cbMax=4
[3356][SQLGetConnectAttrW][3356]PGAPI_GetConnectAttr 109
[3356]PGAPI_GetConnectOption: entering...
[3356][SQLGetInfoW(30)][3356]PGAPI_GetInfo: entering...fInfoType=26
[3356]PGAPI_GetInfo: p='<NULL>', len=4, value=2, cbMax=4
[3356][[SQLAllocHandle]][3356]PGAPI_AllocStmt: entering...
[3356]**** PGAPI_AllocStmt: hdbc = 59586304, stmt = 59614768
[3356]CC_add_statement: self=59586304, stmt=59614768
[3356][SQLGetStmtAttrW][3356]PGAPI_GetStmtAttr Handle=59614768 10010
[3356][SQLGetStmtAttrW][3356]PGAPI_GetStmtAttr Handle=59614768 10011
[3356][SQLGetStmtAttrW][3356]PGAPI_GetStmtAttr Handle=59614768 10012
[3356][SQLGetStmtAttrW][3356]PGAPI_GetStmtAttr Handle=59614768 10013
[3356][SQLSetStmtAttrW][3356]PGAPI_SetStmtAttr Handle=59614768 18,10
[3356][SQLSetStmtAttrW][3356]PGAPI_SetStmtAttr Handle=59614768 18,0
[3356][SQLSetStmtAttrW][3356]PGAPI_SetStmtAttr Handle=59614768 17,1306504
[3356][SQLSetStmtAttrW][3356]PGAPI_SetStmtAttr Handle=59614768 17,0
[3356][SQLSetDescFieldW][3356]PGAPI_SetDescField h=59614988 rec=1 field=1004 val=13ef88,0
[3356]DESCRIPTOR ERROR: func=PGAPI_SetDescField, desc='', errnum=11, errmsg='bad parameter number'
[3356][SQLGetDiagRecW][3356]PGAPI_GetDiagRec entering rec=1

        

Best wishes
WU YUNBIN

~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"
FUYAO GLASS INDUSTRY GROUP CO.,LTD
WU YUNBIN <wwyb(at)mail(dot)ifuyao(dot)com>

URL: http://www.fuyaogroup.com
TEL: (86591)85363676 FAX: (85591)85363651

~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"

Browse pgsql-odbc by date

  From Date Subject
Next Message 吴 允彬 2005-07-13 06:16:31 IS it a BUG !?
Previous Message Minal 2005-07-13 05:59:14 Help needed