Hi,

I am implementing PostgreSQL as a replacement for a ms sql server web appl=
ication and are using pgsqlodbc (8.4.2) on my windows 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 2=
0 records displayed on each page. This is done by use of the .absolutepage=
property of ADODB.Recordset object. I set pagesize and when I open the r=
ecordset - the rs.absolutepage is -1

Here is the parameters I set when opening the recordset.

rs.CursorLocation =3D adUseClient
rs.PageSize =3D 20
rs.Open sql, sconn,1,3

I am using the OCBD driver right out of the box without any special options=
..

Are there options to make this work or is this not implemented in the drive=
r?

And since I am uncertain about this: Should I use the 9.x driver when the d=
atabase is 8.4?

Brgds

Bj=F8rn Ivar Katla
Bitmaker as
Fabrikkgaten 3
5059 Bergen - Norway

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

(2010/10/28 4:58), Bj=F8rn 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 my windows IIS/.ASP agains=
t my 8.4 postgreSQL database on an ubuntu server.
>
> Part of this applications is to enable users to search data and only ha=
ve 20 records displayed on each page. This is done by use of the .absolu=
tepage property of ADODB.Recordset object. I set pagesize and when I op=
en the recordset - the rs.absolutepage is -1
>
> Here is the parameters I set when opening the recordset.
>
> rs.CursorLocation =3D adUseClient
> rs.PageSize =3D 20
> rs.Open sql, sconn,1,3

I see .absolutePage=3D1 here.

Could you display .CursorType, .LockType or .CursorLocation after
opening the recordset?

regards,
Hiroshi Inoue


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Here are the results. Pagecount are correct ( pagesize set to 20, records:=
28)

rs.absolutepage : -1
rs.pagecount: 2
rs.cursortype: 3
rs.locktype: 3
rs.cusorlocation: 2

regards
Bj=F8rn Ivar Katla

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


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

(2010/10/28 21:20), Bj=F8rn Ivar Katla wrote:
> Here are the results. Pagecount are correct ( pagesize set to 20, reco=
rds: 28)
>
> rs.absolutepage : -1
> rs.pagecount: 2
> rs.cursortype: 3
> rs.locktype: 3
> rs.cusorlocation: 2

Doesn't rs.CursorLocation=3D2 mean adUseServer?

regards,
Hiroshi Inoue

> regards
> Bj=F8rn Ivar Katla
>
>>
>> (2010/10/28 4:58), Bj=F8rn Ivar Katla wrote:
>>> Hi,
>>>
>>> I am implementing PostgreSQL as a replacement for a ms sql server we=
b application and are using pgsqlodbc (8.4.2) on my windows IIS/.ASP agai=
nst 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 done by use of the .abso=
lutepage property of ADODB.Recordset object. I set pagesize and when I =
open the recordset - the rs.absolutepage is -1
>>>
>>> Here is the parameters I set when opening the recordset.
>>>
>>> rs.CursorLocation =3D adUseClient
>>> rs.PageSize =3D 20
>>> rs.Open sql, sconn,1,3
>>
>> I see .absolutePage=3D1 here.
>>
>> Could you display .CursorType, .LockType or .CursorLocation after
>> opening the recordset?
>>
>> regards,
>> Hiroshi Inoue

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

You are absolutely right - the declarations of the file containing adUs=
eClient was missing in my code and vbscript is very tolerant of declaration=
s anywhere in the code...

I have tried with a 3 now (adUseClient) and it works as it should. Great=
- that means that I can continue with my move form MS SQL server to Linux/=
PostgreSQL.

regards and sorry for wasting your time with my own shortcomings...

Bj=F8rn Ivar Katla


Den 28. okt. 2010 kl. 15.02 skrev Hiroshi Inoue:

> (2010/10/28 21:20), Bj=F8rn Ivar Katla wrote:
>> Here are the results. Pagecount are correct ( pagesize set to 20, recor=
ds: 28)
>>
>> rs.absolutepage : -1
>> rs.pagecount: 2
>> rs.cursortype: 3
>> rs.locktype: 3
>> rs.cusorlocation: 2
>
> Doesn't rs.CursorLocation=3D2 mean adUseServer?
>
> regards,
> Hiroshi Inoue
>
>> regards
>> Bj=F8rn Ivar Katla
>>
>>>
>>> (2010/10/28 4:58), Bj=F8rn 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 my windows 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 h=
ave 20 records displayed on each page. This is done by use of the .absolut=
epage property of ADODB.Recordset object. I set pagesize and when I open =
the recordset - the rs.absolutepage is -1
>>>>
>>>> Here is the parameters I set when opening the recordset.
>>>>
>>>> rs.CursorLocation =3D adUseClient
>>>> rs.PageSize =3D 20
>>>> rs.Open sql, sconn,1,3
>>>
>>> I see .absolutePage=3D1 here.
>>>
>>> Could you display .CursorType, .LockType or .CursorLocation after
>>> opening the recordset?
>>>
>>> regards,
>>> Hiroshi Inoue


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc