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 |
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) |