Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1000635 ] Failure with 08.02.0002 / 8.1.3: Cannot read ints of that length

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000635 ] Failure with 08.02.0002 / 8.1.3: Cannot read ints of that length
Date: 2006-05-07 12:05:12
Message-ID: 20060507120512.3898986C5BF@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000635, was opened at 2006-05-07 12:05
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000635&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Failure with 08.02.0002 / 8.1.3: Cannot read ints of that length

Initial Comment:
I'm trying to get psqlodbc running on OpenBSD 3.9 amd64 and i386 with PostgreSQL 8.1.3, but iodbctest fails.  No problems with 8.1.2.

Apps/libs:
iodbc-3.52.4
postgresql-8.1.3
psqlodbc-08.02.0002

My configuration:
$ cat .odbc.ini                                                                        
;
;  odbc.ini
;
[ODBC Data Sources]
PostgreSQL      = PostgreSQL ODBC

[ODBC]
TraceFile       = stderr
Trace           = 0

[PostgreSQL]
Driver          = /usr/local/lib/psqlodbc.so
FetchBufferSize = 99
Description     = PostgreSQL ODBC driver
Host            = localhost
UserName        = janus
Password        = 
Database        = janus
ServerOptions   = 
ConnectOptions  = 
Options         = 
ReadOnly        = no
RowVersioning   = no
ShowSystemTables= no
ShowOidColumn   = no
FakeOidIndex    = no
Debug           = 1

[Default]
Driver          = /usr/local/lib/psqlodbc.so

The failing iodbctest:
$ iodbctest "DSN=PostgreSQL" 
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
1: SQLDriverConnect = Error reading field information;
Cannot read ints of that length (109) SQLSTATE=08S01

The correspondending mylog:
calling getDSNdefaults
CC_connect: entering...
sslmode=disable
original_CC_connect: entering...
original_CC_connect: DSN = 'PostgreSQL', server = '', port = '5432', database = 'janus', username = 'janus', password='xxxxx'
connecting to the server socket...
connection to the server socket succeeded.
sizeof startup packet = 96
sent the authentication block.
sent the authentication block successfully.
gonna do authentication
read 280, global_socket_buffersize=4096
auth got 'R'
areq = 0
auth got 'S'
auth got 'S'
auth got 'S'
auth got 'S'
auth got 'S'
auth got 'S'
Got the PostgreSQL version string: '8.1.3'
Extracted PostgreSQL version number: '8.1'
auth got 'S'
auth got 'S'
auth got 'S'
auth got 'K'
auth got 'Z'
CC_send_settings: entering...
PGAPI_AllocStmt: entering...
**** PGAPI_AllocStmt: hdbc = 49b9e000, stmt = 44ea0000
CC_add_statement: self=49b9e000, stmt=44ea0000
PGAPI_FreeStmt: entering...hstmt=44ea0000, fOption=1
QResult: enter DESTRUCTOR
SC_init_Result(44ea0000)SC_Destructor: self=44ea0000, self->result=0, self->hdbc=49b9e000
APD_free_params:  ENTER, self=1156186504
IPD_free_params:  ENTER, self=44ea01f0
PDATA_free_params:  ENTER, self=44ea02a8
SC_Destructor: EXIT
CC_lookup_lo: entering...
send_query(): conn=49b9e000, query='select oid, typbasetype from pg_type where typname = 'lo''
send_query: done sending query
in QR_Constructor
exit QR_Constructor
read 77, global_socket_buffersize=4096
send_query: got id = 'T'
QR_fetch_tuples: cursor = '', self->cursor=0
num_fields = 2
socket error=9 Cannot read ints of that length
READING ATTTYPMOD
CI_read_fields: fieldname='oid', adtid=81788926, adtsize=0, atttypmod=1703936 (rel,att)=(0,0)
socket error=9 Cannot read ints of that length
READING ATTTYPMOD
CI_read_fields: fieldname='ÿÿ', adtid=2037408353, adtsize=29541, atttypmod=1954115681 (rel,att)=(0,116)
CONN ERROR: func=CC_send_query, desc='', errnum=109, errmsg='Error reading field information'
QResult: enter DESTRUCTOR
QResult: in QR_close_result
QResult: free memory in, fcount=0
QResult: free memory out
QResult: enter DESTRUCTOR
QResult: exit close_result
QResult: exit DESTRUCTOR
QResult: enter DESTRUCTOR
Got the large object oid: -999
CC_lookup_characterset: entering...
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=109, errmsg='Error reading field information'
[SQLGetDiagRecW]PGAPI_GetDiagRec entering type=2 rec=1
**** PGAPI_ConnectError: hdbc=49b9e000 <512>
enter CC_get_error
enter CC_create_errormsg
msg = 'Error reading field information'
exit CC_create_errormsg
exit CC_get_error
CC_get_error: status = 109, msg = #Error reading field information;
Cannot read ints of that length#
             szSqlState = '08S01',len=64, szError='Error reading field information;
Cannot read ints of that length'
PGAPI_GetDiagRec exiting 0
[SQLGetDiagRecW]PGAPI_GetDiagRec entering type=2 rec=2
**** PGAPI_ConnectError: hdbc=49b9e000 <512>
PGAPI_GetDiagRec exiting 100
[SQLGetDiagRecW]PGAPI_GetDiagRec entering type=2 rec=1
**** PGAPI_ConnectError: hdbc=49b9e000 <512>
enter CC_get_error
exit CC_get_error
CC_Get_error returned nothing.
PGAPI_GetDiagRec exiting 100
[[SQLFreeHandle]]PGAPI_FreeConnect: entering...
**** in PGAPI_FreeConnect: hdbc=49b9e000
enter CC_Destructor, self=49b9e000
in CC_Cleanup, self=49b9e000
after CC_abort
SOCK_Destructor
after SOCK destructor
exit CC_Cleanup
after CC_Cleanup
after free statement holders
exit CC_Destructor
PGAPI_FreeConnect: returning...
[[SQLFreeHandle]]**** in PGAPI_FreeEnv: env = 4208f120 ** 
in EN_Destructor, self=4208f120
exit EN_Destructor: rv = 1
   ok


----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000635&group_id=1000125

pgsql-odbc by date

Next:From: noreplyDate: 2006-05-09 13:48:56
Subject: [ psqlodbc-Bugs-1000639 ] Connect PostgreSQL to Oracle 10g through ODBC: can't read all_tables
Previous:From: Sistemas C.M.P.Date: 2006-05-05 15:18:09
Subject: postgres and crystal reports

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group