Re: CA-Realia, SqlState -91, Odbc preprocessor and Oracle database

From: pl (pl_at_lamberti.it)
Date: 10/16/04 

Date: Sat, 16 Oct 2004 11:05:32 GMT

Using Microsoft Odbc Driver for Oracle, the buffer size was 64K
(default value); we tried to expand it, but the same error still
remains.

Thank you.

On Wed, 13 Oct 2004 08:51:22 GMT, Robert Wagner
<robert@wagner.net.yourmammaharvests> wrote:

>On Wed, 13 Oct 2004 05:51:23 GMT, pl <pl@lamberti.it> wrote:
>
>>We are using Workbench 3.1.8 and run into trouble with a very simple
>>example accessing an Oracle 9 database:
>>1. we wrote a test program with embedded sql, preprocess it to Odbc
>>2. we tried both Oracle Odbc driver from Oracle and from Microsoft
>>3. we are getting always the same run time error "SqlState -91 invalid
>>number of variables" when we try to fetch a row of data in excess of
>>about 1 (one) kbyte, regardless of the number of columns in the result
>>set.
>>
>>We have tried everything we know of and we still suppose there should
>>be some hidden option we should set.
>>Documentation says nothing that could help us any more.
>>
>>Does anybody knows what's going on?
>
>Go to Control Panel/Admin/Data Sources/User/Config/Options. If maximum
>buffer size is 1-2K, try making it larger.

Relevant Pages