I have installed PHP 4.3.3 on a IIS server and I am trying to connect to an Ingres 6.4 database on a AIX 4.3 server (UNIX).
I have installed Ingres/Net and the CA Ingres ODBC driver. When I test the ODBC driver through the ODBC Administration it connects to the database without any problem, but when I try to connect through the PHP, the script times out without displaying any errors.
I have tried the odbc_connect() with a MySQL server and it works fine. Could you please tell me what am I doing wrong?
The code is:
$ser="name"; #the name of the DB Server
$db="db_name"; #the name of the database
$user="xxx"; #a valid username
$pass="xxx"; #a password for the username
#one line
$conn=odbc_pconnect("DRIVER=Ingres;SERVER=".$ser.";DATABASE=".$db.";",$user,$pass);
#one line
Note: I haven't installed the php_ingres.dll on the windows server, maybe that is the problem?
Thanks
Time Out with ODBC + Ingres
Moderator: General Moderators
problem is you aren't calling the variables correctly in the line :
this should be reading like :
Code: Select all
<?php
$conn=odbc_pconnect("DRIVER=Ingres;SERVER=".$ser.";DATABASE=".$db.";",$user,$pass);
?>Code: Select all
<?php
$conn=odbc_pconnect("DRIVER=Ingres;SERVER="".$ser."";DATABASE="".$db."";"".$user."","".$pass."");
?>