Tags: andthat, back, buffer, characters, database, fetch, informix, meandoes, msaccess, mysql, odbc, oracle, select, size, sql, update

ODBC buffer size.... ??

On Database » Informix

2,643 words with 2 Comments; publish: Mon, 26 May 2008 15:16:00 GMT; (250214.84, « »)

update....

what does an ODBC fetch buffer size of 32,767 mean?

does that mean MSAccess will bring back 32,767 characters in one select and

that's it?

for example, if i use dbaccess to dump a list of owner.table names from the

IDS7 engine below, and do a character count on the file, it is very large,

... surpasses 32,767 characters.

but the IDS9 engine below ... while it has 20,000+ tables, the owner.table

names are smaller in size, potentially fitting in the 32,767 fetch buffer

size.....

i don't know enough about this ODBC stuff. I know i can not increase the

fetch buffer size in the ODBC setup, but it appears that the MSAccess

session can't bring back the entire table list because the select output is

larger than 32,767 characters?

help?

thanks,

NJ

All Comments

Leave a comment...

  • 2 Comments
    • yup, that appears to be the case...

      i isolated 1 table with 13 rows, created a new database with the one table

      and loaded it ...

      then created ODBC connection to the test database with the 1 table...

      now MSAccess did not puke on the table list... it easily fit in the 32,767

      fetch buffer size...

      another day... another lesson learned...

      NJ

      #1; Mon, 26 May 2008 15:17:00 GMT
    • Hi Norma.

      Probably an ODBC fetch buffer size same as FET_BUF_SIZE environment

      variable.

      See refer to Informix Client SDK manual.

      Regards.

      Tsutomu Ogiwara from Tokyo Japan.

      ICQ#:168106592

      >From: "NormaJean" <normajean.sebastian.informix.todaysummary.com.tellabs.com>

      >Reply-To: "NormaJean" <normajean.sebastian.informix.todaysummary.com.tellabs.com>

      >To: informix-list.informix.todaysummary.com.iiug.org

      >Subject: ODBC buffer size... ?

      >Date: Wed, 1 Jun 2005 18:24:14 -0500

      >update....

      >what does an ODBC fetch buffer size of 32,767 mean?

      >does that mean MSAccess will bring back 32,767 characters in one select and

      >that's it?

      >for example, if i use dbaccess to dump a list of owner.table names from the

      >IDS7 engine below, and do a character count on the file, it is very large,

      >... surpasses 32,767 characters.

      >but the IDS9 engine below ... while it has 20,000+ tables, the owner.table

      >names are smaller in size, potentially fitting in the 32,767 fetch buffer

      >size.....

      >i don't know enough about this ODBC stuff. I know i can not increase the

      >fetch buffer size in the ODBC setup, but it appears that the MSAccess

      >session can't bring back the entire table list because the select output is

      >larger than 32,767 characters?

      >help?

      >thanks,

      >NJ

      >

      >

      sending to informix-list

      #2; Mon, 26 May 2008 15:18:00 GMT