(2010/10/28 4:58), Bjørn Ivar Katla wrote:
> Hi,
>
> I am implementing PostgreSQL as a replacement for a ms sql server web application and are using pgsqlodbc (8.4.2) on
mywindows IIS/.ASP against my 8.4 postgreSQL database on an ubuntu server.
>
> Part of this applications is to enable users to search data and only have 20 records displayed on each page. This is
doneby use of the .absolutepage property of ADODB.Recordset object. I set pagesize and when I open the recordset -
thers.absolutepage is -1
>
> Here is the parameters I set when opening the recordset.
>
> rs.CursorLocation = adUseClient
> rs.PageSize = 20
> rs.Open sql, sconn,1,3
I see .absolutePage=1 here.
Could you display .CursorType, .LockType or .CursorLocation after
opening the recordset?
regards,
Hiroshi Inoue