Hello.
I need to configure PHP-4.2.2-17.2 to work with Oracle 8.1.7 under Red Hat 9, but I need to do it using ODBC instead of OCI8. I have also installed php-odbc.
my odbc.ini file says:
extension=odbc.so
If I do a phpinfo() I can see this (an also a bunch of other parameters)
'--with-unixODBC=shared'
'--with-mysql=shared,/usr'
In the Oracle side I have Installed:
Generic Connectivity Using ODBC 8.1.7.0.0
I thought that I have all that I need but when I try to use a:
$conexion=odbc_connect('lhsweb','lhsweb','lhsweb')
I got a message:
Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/html/sagas/admin/prueba.php on line 5
I'm guessing that I need to tell somehow to the php the way to connect to Oracle, maybe in the odbc.ini file.
Can somebody help me with that or tell what I'm missing?
Thanks in advance
Christian Villada