Hi, I'm having some trouble with and odbc connection. I have the ODBC driver for ORACLE 9, and every other query works fine on my application, but when I did a long query it spits out this ugly error:

Warning: odbc_do() [function.odbc-do]: SQL error: [Oracle][ODBC]Option value changed., SQL state 01S02 in SQLExecDirect in

Here's part of my code:

$query_Recordset1 = sprintf("
SELECT ALL BERNARDO.CT_LECTURA.MEDICION, BERNARDO.CT_LECTURA.CANTIDAD,
BERNARDO.CT_LECTURA.COMENTARIO, BERNARDO.CT_CONTENEDOR.CAPACIDAD,
BERNARDO.CT_LECTURA.ID_CONTENEDOR, BERNARDO.CT_LECTURA.FECHA
FROM BERNARDO.CT_CONTENEDOR, BERNARDO.CT_LECTURA
WHERE (BERNARDO.CT_LECTURA.ID_CONTENEDOR=BERNARDO.CT_CONTENEDOR.ID_CONTENEDOR
AND BERNARDO.CT_LECTURA.ID_UNINEG=BERNARDO.CT_CONTENEDOR.ID_UNINEG)
AND BERNARDO.CT_CONTENEDOR.ID_UNINEG = %s 
ORDER BY BERNARDO.CT_LECTURA.FECHA, BERNARDO.CT_LECTURA.ID_CONTENEDOR
",$colname_Recordset1);

$Recordset1 = odbc_do($connectionstring, $query_Recordset1);

The only info I've found is this:

http://bugs.php.net/bug.php?id=11&edit=1

    Ok, my problem was my handling of the dates. This was the query:

    SELECT ALL BERNARDO.CT_LECTURA.MEDICION, BERNARDO.CT_LECTURA.CANTIDAD, BERNARDO.CT_LECTURA.COMENTARIO, BERNARDO.CT_CONTENEDOR.CAPACIDAD, BERNARDO.CT_LECTURA.ID_CONTENEDOR, BERNARDO.CT_LECTURA.DATE FROM BERNARDO.CT_CONTENEDOR, BERNARDO.CT_LECTURA WHERE BERNARDO.CT_LECTURA.DATE>='01-APR-05' AND BERNARDO.CT_LECTURA.DATE <='11-APR-05' AND (BERNARDO.CT_LECTURA.ID_CONTENEDOR=BERNARDO.CT_CONTENEDOR.ID_CONTENEDOR AND BERNARDO.CT_LECTURA.ID_UNINEG=BERNARDO.CT_CONTENEDOR.ID_UNINEG) AND BERNARDO.CT_CONTENEDOR.ID_UNINEG = 4 ORDER BY BERNARDO.CT_LECTURA.DATE, BERNARDO.CT_LECTURA.ID_CONTENEDOR

    The ODBC wasn't handling the dates correctly, so I did this:
    Start -> Run -> regedit
    Then I surfed through the regedit variables:
    HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME0
    There's a variable there called NLS_LANG. I just changed it to:
    AMERICAN_AMERICA.WE8ISO8859P1

    And that did the trick.

      Write a Reply...