Postgres Pro
Downloads
Home   >   mailing lists

VB6, ADO returns EOF via ODBC but has records in PSQL - Mailing list pgsql-odbc

From Erika Marlow
Subject VB6, ADO returns EOF via ODBC but has records in PSQL
Date
Msg-id 8388742B98C6BE479282C543CD000EE0034C9DAE@ndes1.nisc.lan
Whole thread Raw
List pgsql-odbc
Tree view
I'm trying to find the set of records that are not in a comma delimited list using an SQL statement like:
 
SELECT name FROM construction WHERE name NOT IN ('a1        ', 'a2        ', '') ORDER BY name;
 
The values in the field are padded with spaces and I have to keep them that way for data integrity between software systems.  If I send this statement to the PostgreSQL database with ADO via the ODBC driver (adoRs.Open sql, dbconn, adOpenStatic, adLockOptimistic) I don't get any records.  However, if I execute the same statement in psql directly, I get nineteen rows.
 
Is there a property setting or something that I'm missing when using the driver?
 
Thanks,
 
Erika Marlow___________________
Senior Software Specialist
National Information Solutions Cooperative
One Innovation Circle
Lake St. Louis, MO 63367
+ Email: erika.marlow@nisc.coop
( Phone: 866.WWW.NISC (866.999.6472)
( Direct: 636.755.2519
 
Attachment

pgsql-odbc by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: Improve ODBC Throughput ?
Next
From: greg.campbell@us.michelin.com
Date:
Subject: Re: Improve ODBC Throughput ?