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

From: Robert Wagner (robert_at_wagner.net.yourmammaharvests)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 08:51:22 GMT

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

  • Re: Acccess --> Oracle (unix Solaris)
    ... Use the Oracle ODBC driver. ... In place of the server name, ... > your Oracle DBA has set for the IP address & port. ... > SAMBA connections. ...
    (microsoft.public.access.queries)
  • Re: Import from Oracle - ODBC basics
    ... equivalent create a Local Net Service Name Configuration to the Oracle ... add a System DSN using the "Oracle ODBC Driver" (MUST be this ... A FULL installation of Oracle was required on the computer in order for ... the "Oracle ODBC Driver" to be available. ...
    (comp.databases.filemaker)
  • CA-Realia, SqlState -91, Odbc preprocessor and Oracle database
    ... we wrote a test program with embedded sql, ... we tried both Oracle Odbc driver from Oracle and from Microsoft ...
    (comp.lang.cobol)
  • Re: DBD::ODBC does not support bind_param_inout?
    ... my $csr = $dbh->prepare(q{ ... I presume since that starts PLSQL you are using Oracle. ... Which Oracle ODBC driver are you using? ...
    (perl.dbi.users)
  • Re: Oracle Database and VB6
    ... Any undesired problem using ODBC to connect to Oracle Database? ... Or i just setup the ODBC data source name and the Oracle ODBC driver in the client PC and everything are OK, similar to connectiong to Access Database. ...
    (microsoft.public.vb.general.discussion)