|Symfony 1.0 and Oracle 8i [message #102988]
||Fri, 23 July 2010 11:38
Registered: July 2010
For my company I have to extend an existing app based on Symfony 1.0 with has modules generated with Propel's admin generator using a Mysql DB.
I have to develop a screen allowing to fetch (read) data from an Oracle 8I database.
Is this possible ?
I can access without problem to the Oracle DB with Toad but executing a symfony using propel features (build-schema or insert-sql) I get a connexion failure
Native Error: ORA-12513: TNS : le processus d'écoute ne connaît pas actuellement le service demandé dans le descripteur de connexion)
(Sorry for the french error)
I think this error maybe comes from the path of my tns.ora file. In which symfony file will I have to set the path of ORACLE_HOME or LD_LIBRARY_PATH?
It appears from topics on different forums that there are many ways to connect to an oracle database (oci8, by Service Name (TNS?), by Service ID) and some techniques work better that others.
Which way would be the most convenient?
[Updated on: Fri, 23 July 2010 11:39]