Page 1 of 1

Time Out with ODBC + Ingres

Posted: Thu Nov 06, 2003 2:23 am
by psel
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

Posted: Thu Nov 06, 2003 4:54 pm
by infolock
problem is you aren't calling the variables correctly in the line :

Code: Select all

<?php
$conn=odbc_pconnect("DRIVER=Ingres;SERVER=".$ser.";DATABASE=".$db.";",$user,$pass); 
?>
this should be reading like :

Code: Select all

<?php

$conn=odbc_pconnect("DRIVER=Ingres;SERVER="".$ser."";DATABASE="".$db."";"".$user."","".$pass.""); 

?>