From: | "Campbell, Greg" <greg(dot)campbell(at)us(dot)michelin(dot)com> |
---|---|
To: | linuxgps <linuxgps(at)invitel(dot)hu> |
Cc: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, Thomas Holschen <Thomas(dot)Holschen(at)hela-food(dot)de>, Ludek Finstrle <luf(at)pzkagis(dot)cz>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Antw: Re: VBA 6 crashes with WIN2K, Postgres 8.1, |
Date: | 2006-01-07 00:00:14 |
Message-ID: | 43BF048E.4050009@us.michelin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(dot)Holschen(at)hela-food(dot)de] Sent: 06
>>> January 2006 11:20
>>> To: Ludek Finstrle; Dave Page
>>> Cc: pgsql-odbc(at)postgresql(dot)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
Attachment | Content-Type | Size |
---|---|---|
greg.campbell.vcf | text/x-vcard | 241 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | linuxgps | 2006-01-07 00:07:08 | Re: VBA 6 crashes with WIN2K, Postgres 8.1, why ? whichdll ?? |
Previous Message | Campbell, Greg | 2006-01-06 23:44:07 | Re: VBA 6 crashes with WIN2K, Postgres 8.1, why ? whichdll ?? |