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

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

  • Next message: Richard: "Re: Creative Javascript writing (was: OFF Topic)" 
    Date: Wed, 13 Oct 2004 05:51:23 GMT

    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?
    Thanx
    Pl.

  • Next message: Richard: "Re: Creative Javascript writing (was: OFF Topic)"

    Relevant Pages

    • Re: CA-Realia, SqlState -91, Odbc preprocessor and Oracle database
      ... we wrote a test program with embedded sql, preprocess it to Odbc ... we tried both Oracle Odbc driver from Oracle and from Microsoft ...
      (comp.lang.cobol)
    • 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)
    • 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)