IS it a BUG !? - Mailing list pgsql-odbc
| From | 吴 允彬 |
|---|---|
| Subject | IS it a BUG !? |
| Date | |
| Msg-id | 20050713062035.40D6052872@svr1.postgresql.org Whole thread Raw |
| List | 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 SP2
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.datasourceproperty,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.020050505 (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,
compiledby 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
GCCi386-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.020050505 (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
wheretypname='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@mail.ifuyao.com>
URL: http://www.fuyaogroup.com
TEL: (86591)85363676 FAX: (85591)85363651
~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"~"
pgsql-odbc by date: