Re: MAXDATA/ARRAYSIZE vs. ODBC
Date: 1996/07/03
Message-ID: <4re8fn$2v4_at_vixen.cso.uiuc.edu>#1/1
In <31d995c6.1448878_at_news.neosoft.com> jmayes_at_neosoft.com (James K. Mayes) writes:
>Not completely sure about the solution... but I am fairly confident
>that the settings for SQL*Plus are just that: Settings for SQL*Plus
>and thus, have nothing to do with any ODBC buffer sizes.
>I had a similar problem with MS SQL Server 6.0... Our only solution
>once we hit the column limit was to construct a VIEW with fewer
>columns.
>Good luck,
>jimmy mayes
Thanks. Actually after browsing around the MS Knowledge Base, it turns out the problem is with FoxPro, not with ODBC... seems FoxPro's ODBC interface library is constructing a 'create table' command for FP which is too long for FP to execute. *sigh* Back to the drawing board...
Jason
--
/============/ Jason Hoos - jhoos_at_uiuc.edu \============\
/============/ Math Department System Co-Administrator \============\
/============/ University of Illinois - Urbana-Champaign \============\
Received on Wed Jul 03 1996 - 00:00:00 CEST