logo       
<prev   next>

Sponsor
FREE Network Mapping Tool for Microsoft® Office Visio® Professional 2007
Don't map your network by hand - let LANsurveyor Exx press for Microsoft Visio Professional 2007 automatically create network diagrams for you!

Errors while retrieving text field: msg#00012

db.postgresql.odbc

Subject: Errors while retrieving text field

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
[18 00][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]describeC ol: 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
[1 800]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]][1 800]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 l en=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_De scribeCol: 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_t ype = 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
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  SQLTables (Windows/libodbc++), Aris Basic
Next by Date:  Re: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL, Sydney Delieu
Previous by Thread:  SQLTables (Windows/libodbc++), Aris Basic
Next by Thread:  Updating a ADO RecordSet with INNER JOIN..., Thomas LeBlanc
Indexes:  [Date] [Thread] [Top] [All Lists]

Sponsor
FREE Network Mapping Tool for Microsoft® OfficeVisio Professional 2007
Don't map your network by hand - let LANsurveyor Express for Microsoft Visio Professional 2007
automatically create network diagrams for you!
Google Custom Search

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

Navigation
Home | sitemap | advertise | OSDir is an inevitable website. super tiny logo