Byron,
Aren't you working on some issues along these lines right now?
Brian,
You should post these questions on the pgsql-interface list to increase the
chance of someone having experince with your problem. Also other users may
gain the exchange. Also, please provide the version of the driver. This
can be retrieved from the "ODBC
Data Source Administrator" in the "ODBC Drivers" tab.
Brian Curnow wrote:
> David,
>
> I am trying to use Visual Basic 5.0 to connect to Postgres 6.3.2. I
> read in the digest that someone had success with 'Recordset' items.
> I had been trying to use RDO ResultSet objects, and was getting errors
> about unsupported ODBC features on any SELECT that returned data. I
> just tried using the DAO/ODBC Direct (which is what Recordset objects
> are, I think) but got an ODBC call failed on the SELECT statement again.
>
> Do you know of any tricks to getting result sets, or limitations in the
> driver that would cause errors? I tried setting the connection to use
> no cursor, forward, read only, all that stuff I could find that sounded
> less demanding of the ODBC driver.
>
> Thanks,
>
> Brian Curnow