Problems with int8 and MS ADO/ODBC

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Problems with int8 and MS ADO/ODBC
Date: 2000-12-21 15:18:20
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2824@woody.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi,

I have a problem accessing int8 columns in ADO 2.6 recordset objects via
ODBC. I've been testing with a table called test with one int8 column called
id. It contains a couple of records with random numbers in them. VB code
such as shown will create the recordset object with the correct structure,
but no records (i.e. EOF is true). The column type is interpreted as
adBigInt. The Connection object shows two errors:

-2147217887 Multiple-step OLE DB operation generated errors. Check each OLE
DB status value, if available. No work was done

and

-2147217887 Provider does not support the property

If I add an int4 or text column to the table the error still occurs unless
the int8 is excluded from the query.

I have attached a commlog and SQL trace log, and the error can also be
reproduced by viewing data in a table (or running a SELECT query) containing
an int8 (or presumably a float8 or other large number) using pgAdmin v7.0.4

Thanks in anticipation,
Dave.

*** Code Snippet ***

Dim cn As New Connection
Dim rs As New Recordset
cn.Open "DSN=Regression;UID=postgres;PWD=****;"
rs.Open "SELECT * FROM test", cn
MsgBox rs!id
rs.Close
cn.Close

<<psqlodbc.log>> <<sql.log>>

Attachment Content-Type Size
psqlodbc.log application/octet-stream 1.3 KB
sql.log application/octet-stream 26.4 KB

Browse pgsql-interfaces by date

  From Date Subject
Next Message Johann Zuschlag 2000-12-21 21:17:58 keyword LIMIT in SQL-statement, psqlodbc workaround?
Previous Message J. 'FIK'Brand 2000-12-21 11:16:17 ODBC, Access and foreign key (part 2)