Errors while retrieving text field

From: "Peter L(dot)" <pluichinger2(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Errors while retrieving text field
Date: 2004-05-10 17:24:24
Message-ID: 20040510172424.54441.qmail@web60807.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I've been consistenly getting the folliwing errors while retrieving a record including a text field. Can anyone tell me why the psqlODBC keeps trying to convert my text field to a SQL_C_Binary field?

<Snippet>
[1800][[SQLAllocHandle]][1800]PGAPI_AllocStmt: entering...
[1800]**** PGAPI_AllocStmt: hdbc = 38745920, stmt = 38740256
[1800]CC_add_statement: self=38745920, stmt=38740256
[1800][[SQLGetStmtAttr]] Handle=38740256 10010
[1800]PGAPI_GetStmtAttr Handle=38740256 10010
[1800][[SQLGetStmtAttr]] Handle=38740256 10011
[1800]PGAPI_GetStmtAttr Handle=38740256 10011
[1800][[SQLGetStmtAttr]] Handle=38740256 10012
[1800]PGAPI_GetStmtAttr Handle=38740256 10012
[1800][[SQLGetStmtAttr]] Handle=38740256 10013
[1800]PGAPI_GetStmtAttr Handle=38740256 10013
[1800][[SQLSetStmtAttr]] Handle=38740256 1,0
[1800]PGAPI_SetStmtAttr Handle=38740256 1,0
[1800]PGAPI_SetStmtOption: entering...
[1800]SetStmtOption(): SQL_MAX_ROWS, vParam = 0
[1800][SQLGetInfo(30)][1800]PGAPI_GetInfo: entering...fInfoType=16
[1800]PGAPI_GetInfo: p='', len=0, value=0, cbMax=512
[1800][SQLPrepare][1800]PGAPI_Prepare: entering... len=106
[1800]**** PGAPI_Prepare: STMT_ALLOCATED, copy
[1800][SQLExecute][1800]PGAPI_Execute: entering...
[1800]PGAPI_Execute: clear errors...
[1800]recycle statement: self= 38740256
[1800]APD_free_params: ENTER, self=38740400
[1800]IPD_free_params: ENTER, self=38740428
[1800]IPD_free_params: EXIT
[1800]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=106, stmt='select "product_id", "sku", "description" from www.product product where (product."sku" = '5406-06-04') '
[1800] stmt_with_params = 'select "product_id", "sku", "description" from www.product product where (product."sku" = '5406-06-04') '
[1800] Sending SELECT statement on stmt=38740256, cursor_name='SQL_CUR024F2120'
[1800]send_query(): conn=38745920, query='select "product_id", "sku", "description" from www.product product where (product."sku" = '5406-06-04') '
[1800]send_query: done sending query
[1800]in QR_Constructor
[1800]exit QR_Constructor
[1800]read 105, global_socket_buffersize=4096
[1800]send_query: got id = 'P'
[1800]send_query: got id = 'T'
[1800]QR_fetch_tuples: cursor = '', self->cursor=0
[1800]num_fields = 3
[1800]READING ATTTYPMOD
[1800]CI_read_fields: fieldname='product_id', adtid=23, adtsize=4, atttypmod=-1
[1800]READING ATTTYPMOD
[1800]CI_read_fields: fieldname='sku', adtid=1043, adtsize=-1, atttypmod=80
[1800]READING ATTTYPMOD
[1800]CI_read_fields: fieldname='description', adtid=1043, adtsize=-1, atttypmod=8190
[1800]QR_fetch_tuples: past CI_read_fields: num_fields = 3
[1800]MALLOC: tuple_size = 100, size = 2400
[1800]next_tuple: inTuples = true, falling through: fcount = 101, fetch_count = 101
[1800]qresult: len=4, buffer='1643'
[1800]qresult: len=10, buffer='5406-06-04'
[1800]qresult: len=1, buffer=' '
[1800]end of tuple list -- setting inUse to false: this = 38778128
[1800]_next_tuple: 'C' fetch_total = 1 & this_fetch = 1
[1800]send_query: got id = 'Z'
[1800] done sending the query:
[1800]extend_column_bindings: entering ... self=38740344, bindings_allocated=0, num_columns=3
[1800]exit extend_column_bindings
[1800][SQLNumResultCols][1800]PGAPI_NumResultCols: entering...
[1800]SC_pre_execute: status = 3
[1800]PGAPI_NumResultCols: result = 38778128, status = 3, numcols = 3
[1800][SQLDescribeCol][1800]PGAPI_DescribeCol: entering.1..
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_DescribeCol: res = 38778128, stmt->status = 3, !finished=0, !premature=1
[1800]describeCol: col 0 fieldname = 'product_id'
[1800]describeCol: col 0 fieldtype = 23
[1800]describeCol: col 0 column_size = 10
[1800]describeCol: col 0 *pfSqlType = 4
[1800]describeCol: col 0 *pcbColDef = 10
[1800]describeCol: col 0 *pibScale = 0
[1800]describeCol: col 0 *pfNullable = 1
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 10 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800]PGAPI_ColAttr: UPDATEABLE = 2
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 3 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800]PGAPI_ColAttributes: col 0, length = 4
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 9 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800]COLUMN_MONEY=0
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 13 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 8 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 11 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800]AUTO_INCREMENT=0
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 1002 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=1 14 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 0 field_type = 23
[1800][SQLDescribeCol][1800]PGAPI_DescribeCol: entering.2..
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_DescribeCol: res = 38778128, stmt->status = 3, !finished=0, !premature=1
[1800]getCharColumnSize: type=1043, col=1, unknown = 0
[1800]describeCol: col 1 fieldname = 'sku'
[1800]describeCol: col 1 fieldtype = 1043
[1800]describeCol: col 1 column_size = 80
[1800]describeCol: col 1 *pfSqlType = 12
[1800]describeCol: col 1 *pcbColDef = 80
[1800]describeCol: col 1 *pibScale = 0
[1800]describeCol: col 1 *pfNullable = 1
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 10 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800]PGAPI_ColAttr: UPDATEABLE = 2
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 3 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800]getCharColumnSize: type=1043, col=1, unknown = 0
[1800]PGAPI_ColAttributes: col 1, length = 240
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 9 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800]COLUMN_MONEY=0
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 13 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 8 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 11 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800]AUTO_INCREMENT=0
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 1002 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=2 14 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 1 field_type = 1043
[1800][SQLDescribeCol][1800]PGAPI_DescribeCol: entering.3..
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_DescribeCol: res = 38778128, stmt->status = 3, !finished=0, !premature=1
[1800]getCharColumnSize: type=1043, col=2, unknown = 0
[1800]describeCol: col 2 fieldname = 'description'
[1800]describeCol: col 2 fieldtype = 1043
[1800]describeCol: col 2 column_size = 8190
[1800]describeCol: col 2 *pfSqlType = 12
[1800]describeCol: col 2 *pcbColDef = 8190
[1800]describeCol: col 2 *pibScale = 0
[1800]describeCol: col 2 *pfNullable = 1
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 10 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800]PGAPI_ColAttr: UPDATEABLE = 2
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 3 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800]getCharColumnSize: type=1043, col=2, unknown = 0
[1800]PGAPI_ColAttributes: col 2, length = 24570
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 9 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800]COLUMN_MONEY=0
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 13 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 8 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 11 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800]AUTO_INCREMENT=0
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 1002 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800][[SQLColAttribute]][1800]PGAPI_ColAttributes: entering..col=3 14 len=80.
[1800]SC_pre_execute: status = 3
[1800]**** PGAPI_ColAtt: result = 38778128, status = 3, numcols = 3
[1800]colAttr: col 2 field_type = 1043
[1800][SQLBindCol][1800]PGAPI_BindCol: entering...
[1800]**** PGAPI_BindCol: stmt = 38740256, icol = 1
[1800]**** : fCType=4 rgb=d5978 valusMax=4 pcb=d5a58
[1800] bound buffer[0] = 874872
[1800][SQLBindCol][1800]PGAPI_BindCol: entering...
[1800]**** PGAPI_BindCol: stmt = 38740256, icol = 2
[1800]**** : fCType=1 rgb=d5d3c valusMax=241 pcb=d5c40
[1800] bound buffer[1] = 875836
[1800][[SQLFetch]][1800]PGAPI_ExtendedFetch: stmt=38740256
[1800]SQL_FETCH_NEXT: num_tuples=1, currtuple=-1
[1800]PGAPI_ExtendedFetch: new currTuple = -1
[1800]manual_result = 0, use_declarefetch = 0
[1800]**** SC_fetch: manual_result
[1800]fetch: cols=3, lf=0, opts = 38740344, opts->bindings = 38740096, buffer[] = 874872
[1800]type = 23
[1800]value = '1643'
[1800]copy_and_convert: field_type = 23, fctype = 4, value = '1643', cbValueMax=4
[1800]copy_and_convert: retval = 0
[1800]fetch: cols=3, lf=1, opts = 38740344, opts->bindings = 38740096, buffer[] = 875836
[1800]type = 1043
[1800]value = '5406-06-04'
[1800]copy_and_convert: field_type = 1043, fctype = 1, value = '5406-06-04', cbValueMax=241
[1800]DEFAULT: len = 10, ptr = '5406-06-04'
[1800] SQL_C_CHAR, default: len = 10, cbValueMax = 241, rgbValueBindRow = '5406-06-04'
[1800]copy_and_convert: retval = 0
[1800]fetch: cols=3, lf=2, opts = 38740344, opts->bindings = 38740096, buffer[] = 0
[1800][SQLGetData][1800]PGAPI_GetData: enter, stmt=38740256
[1800] num_rows = 1
[1800] value = ' '
[1800]**** PGAPI_GetData: icol = 2, fCType = -2, field_type = 1043, value = ' '
[1800]copy_and_convert: field_type = 1043, fctype = -2, value = ' ', cbValueMax=255
[1800]couldn't convert the type 1043 to SQL_C_BINARY
[1800]STATEMENT ERROR: func=PGAPI_GetData, desc='', errnum=14, errmsg='Received an unsupported type from Postgres.'
[1800]CONN ERROR: func=PGAPI_GetData, desc='', errnum=0, errmsg='(NULL)'
[1800][[SQLGetDiagRec]]
[1800]PGAPI_GetDiagRec entering rec=1[1800]**** PGAPI_StmtError: hstmt=38740256 <512>
[1800]SC_get_error: status = 14, msg = #Received an unsupported type from Postgres.#
[1800] szSqlState = '07006',len=43, szError='Received an unsupported type from Postgres.'
[1800]PGAPI_GetDiagRec exiting 0
[1800][[SQLGetDiagRec]]
[1800]PGAPI_GetDiagRec entering rec=2[1800]**** PGAPI_StmtError: hstmt=38740256 <512>
[1800]SC_get_error: status = 14, msg = #Received an unsupported type from Postgres.#
[1800]PGAPI_GetDiagRec exiting 100
[1800][[SQLFetch]][1800]PGAPI_ExtendedFetch: stmt=38740256
[1800]SQL_FETCH_NEXT: num_tuples=1, currtuple=0
[1800][[SQLFreeHandle]][1800]PGAPI_FreeStmt: entering...hstmt=38740256, fOption=1
[1800]QResult: in DESTRUCTOR
[1800]QResult: free memory in, fcount=1
[1800]row = 0, num_fields = 3
[1800]free [lf=0] 38770768
[1800]free [lf=1] 38770744
[1800]free [lf=2] 38770720
[1800]QResult: free memory out
[1800]QResult: exit DESTRUCTOR
[1800]SC_Destructor: self=38740256, self->result=0, self->hdbc=38745920
[1800]reset_a_column_binding: entering ... self=38740344, bindings_allocated=3, icol=1
[1800]reset_a_column_binding: entering ... self=38740344, bindings_allocated=3, icol=2
[1800]reset_a_column_binding: entering ... self=38740344, bindings_allocated=3, icol=3
[1800]APD_free_params: ENTER, self=38740400
[1800]IPD_free_params: ENTER, self=38740428
[1800]IPD_free_params: EXIT
[1800]SC_Destructor: EXIT
</Snippet>


---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs

Browse pgsql-odbc by date

  From Date Subject
Next Message saurabh agarwal 2004-05-11 04:23:38 Re: where can i find documentation of odbc api
Previous Message Aris Basic 2004-05-10 16:13:49 SQLTables (Windows/libodbc++)