Hi!

I need to access an Informix database from a Linux Apache PHP system.
I uses the following code

$conn_id = ifx_connect ("db@server: port","user","pass");

but I get ther following ERROR:

Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-25556] in /srv/www/htdocs/www1/ifx.php on line 8

what is the right format I have to write in the sqlhosts -file?

thanx
MySven

Hi,

In $INFORMIXDIR/etc/..., this sqlhosts files, the format is the following one:

Instance name Type of connection Server Service
$INFORMIXSERVER onsoc[tcp|tli|str] Server name Xservice

In /etc/services must be:

Xservice nnnn/tcp

Now, test the environmen variable INFORMIXSQLHOSTS, INFORMIXDIR, INFORMIXSERVER, ONCONFIG.

Gustavo.

thanks!
How can I select the database on the server?

MySven

With the sql 'database xxx' statement.

What must be in the INFORMIXSQLHOSTS and ONCONFIG Variable?

the INFORMIXDIR = /opt/informix
the INFORMIXSERVER = servername

Hi,

The variable INFORMIXSQLHOSTS one talks about the way where this the file sqlhosts.
Ej. INFORMIXSQLHOSTS=$INFORMIXDIR/etc/you_sqlhosts_file

you_sqlhosts_file -- FORMAT --

DBSERVERNAME type conexion HOSTNAME service

Gustavo.