What type of cursor are you using.
The sample in the MSDN (VB6 era help) says to use Client side cursor to enable AbsolutePosition,
AbsolutePage.
I guess it makes sense. A server side cursor is a pointer to records on the server. A ForwardOnly cursor
pulls back the recordset but only gives you a pointer to it, but doesn't know how many records are in the
set or how to page it before it has gone to the end -- and it can't go backward.
rule of thumb -- use:
rsCursorLocation = adUseClient
rs.open sql, cnn, adOpenStatic, adLockReadOnly, adCmdText ---- or something close to this
rs.Open sql, cnn -- also works
linuxgps wrote:
>
>
> In the VB debugger, watching 'CN' the cn.DefaultData immediately after
> the connection has
> ' multi step error and it says to check the ole db status if applicable'
>
> Following this it reads the first record, but ! the "rs.AbsolutPage,
> rs.AbsolutePosition" is "adPosUnknown"
>
> Is this a driver bug or I've missed up some setup, grant, odbc registry ???
> .
> Dave Page wrote:
>
>>
>>
>>
>>
>>> -----Original Message-----
>>> From: Thomas Holschen [mailto:Thomas.Holschen@hela-food.de] Sent: 06
>>> January 2006 11:20
>>> To: Ludek Finstrle; Dave Page
>>> Cc: pgsql-odbc@postgresql.org
>>> Subject: Antw: Re: [ODBC] VBA 6 crashes with WIN2K, Postgres 8.1,
>>> why? which dll ??
>>>
>>> The Example is installed with MSI-Installer for psqlODBC 08.01.0101.
>>> It's installed as c:/Programme/psqlODBC/docs/howto-vb.html.
>>>
>>
>>
>> Nowhere in there does it mention updateable cursors - in fact, it was
>> written long before they were even added to the driver.
>>
>> I just tested the example given, and with a few minor typo/thinko fixes
>> it works just fine *except* for the RecordCount which has been the
>> subject of recent discussion anyway.
>>
>> Regards, Dave
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend