Re: [phplib] ODBC connection parameters From: Christof Beaupoil (beaupoil <email protected>)
Date: 11/08/00

forgot the answer to your question nicolaus,

> Warning: SQL error: [Oracle][ODBC][Ora]ORA-00997: Unzulässige Verwendung des
> Datentyps LONG , SQL state S1000 in SQLExecDirect in db_odbc.inc on line 61
> Database error: Invalid SQL: select count(*) from active_sessions where
> val='RXhhbXBsZV9TZXNzaW9uOiR0aGlzLT5pbiA9ICdmYWxzZSc7ICR0aGlzLT5wdCA9IGFycmF
> 5KCk7ICR0aGlzLT5wdFsnYXV0aCddID0gJ3RydWUnOyAkR0xPQkFMU1snYXV0aCddID0gbmV3IEV
> 4YW1wbGVfRGVmYXVsdF9BdXRoOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEd
> MT0JBTFNbJ2F1dGgnXS0+YXV0aFsnZXhwJ10gPSAnOTczNTE0MDgwJzsgJEdMT0JBTFNbJ2F1dGg
> nXS0+YXV0aFsncGVybSddID0gJyc7IA==' and changed='20001106131940' and
> sid='6f0e3783ac2a9fa7378a946f1b46ee5e' and name='Example_Session'
> ODBC Error: 1 (General Error (The ODBC interface cannot return detailed
> error messages).)
> Session halted.

looks to me like a similar problem with mssql: the datatype of the val
column must be searchable which 'long' in oracle might not be (ask the
oracle manual...) Change the columntype to a searchable texttype (like
char or something) Be carefull because the val thing gets very long very
fast. If it gets longer than you column alows session brakes again :(
btw.: does anybody know WHY phplib is doing a where over all three
columns (shouldn´t it be enough to say where sid='foo'??

cu
Christof Beaupoil

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>