Skip site navigation (1) Skip section navigation (2)

Re: use declare/fetch

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Garner Chung <garner(at)nuws(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: use declare/fetch
Date: 2006-10-20 21:39:38
Message-ID: 4539421A.30909@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Garner Chung wrote:
> We're experimenting with the "use declare/fetch" setting in our MS
> Access/DAO - PG 8.1 environment. We're using the psqlODBC snapshot
> driver version, 8.02.01.03.
>
> However, we're experiencing a problem. With the "use declare/fetch"
> setting on we get an error on the (cache size - 49)th call to a dao
> recordset's MoveNext method. So with our current cache size setting of
> 500, the 451st call to MoveNext generates an ODBC error. With the cache
> size set to 100, the 51st call to MoveNext fails. See below for the
> relevant COMM log entries. 

Could you send me directly the Mylog output ?

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: noreplyDate: 2006-10-21 03:41:56
Subject: [ psqlodbc-Bugs-1000759 ] SQLGetInfo(SQL_NULL_COLLATION) returns SQL_NC_END instead of SQL_NC_HIGH
Previous:From: Garner ChungDate: 2006-10-20 18:49:39
Subject: use declare/fetch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group