Re: Server Side Cursors. - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Server Side Cursors.
Date
Msg-id 3BF99FDC.933D78A9@tpf.co.jp
Whole thread Raw
In response to Server Side Cursors.  ("Ryan C. Bonham" <Ryan@srfarms.com>)
List pgsql-odbc
"Ryan C. Bonham" wrote:
>
> Hi,
>
> I just ran across an interesting problem with my Visual Basic 6.0sp5
> Program. I am using version 7.1.0.8 of the ODBC driver. I have a
> DBGrid, it is actually The "True DBGrid" from Component One, on a
> Form. It is connected to a table, using a bound dataenvironment,
> which contains 5110 records. As long as I use server side cursors,
> the grid will only display 8 records. When I change to Client Side
> Cursors it displays all 5110 records.. I have tried changing lock
> types, etc.. and have not got server side to work at all. The ODBC
> Driver logs show that it is opening the correct table with all 5110
> records.. I have not turned on Server Side logging, but I can if
>  that will help figure this out.

What cursor type are you using ?

>
> Is this in anyway related to my previous post from 10/09/2001.
> "[ODBC] ODBC ServerSide Cursors Error"?

Not sure.

> Was that fix included in the new 7.1.0.8 driver?

Yes. The bug was not limited to server side cursors.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Alexaki Sofia
Date:
Subject: ODBC driver version
Next
From: Hiroshi Inoue
Date:
Subject: Re: ODBC driver version