RE: - Unable to get unixODBC to work with informix driver

I have retried everything with a newer version of unixODBC from CVS
and now it works for isql.

The problem I have now is getting it to work with php off apache
on a webserver (redhat 7.3). The error returned from php is:-
Warning: SQL error: [unixODBC][Informix][Odbc Informix Driver]Data source
name not found and no default driver specified., SQL state IM002 in
SQLConnect in /var/www/html/ahs_web/php_todbc_p.php on line 19
Unable to connect to Informix database

I suspect that somehow it could not find the .odbc.ini in the home directory
of apache. I am not so familiar with web server and I am wondering exactly
where the system expects to look, for the home directory of the apache
process
that run the web server. I got the same error message for isql if I remove
the
.odbc.ini file from the home directory of the user that runs isql.

Suggestions or ideas welcome.

Thanks,

Hock Soon


-----Original Message-----
From: owner-unixodbc-dev@xxxxxxxxxxxx
[mailto:owner-unixodbc-dev@xxxxxxxxxxxx]On Behalf Of Stefan Radman
Sent: Tuesday, July 22, 2003 3:05 PM
To: unixodbc-dev@xxxxxxxxxxxx
Subject: RE: [unixODBC-DEV] - Unable to get unixODBC to work with
informix driver


Try "isql -v <dsn_name>"
That should provide you with a more detailed error message.

Stefan

> -----Original Message-----
> From: Ann Hock Soon [mailto:hocksoon@xxxxxxxxxxxxx]
> Sent: Tuesday, 22 July, 2003 05:37
> To: unixodbc-dev@xxxxxxxxxxxx
> Subject: [unixODBC-DEV] - Unable to get unixODBC to work with informix
> driver
>
>
> Hi,
>
> I have installed the unixODBC driver (2.2.5) on my Redhat 7.3
> Linux system
> and I am trying to
> get it to work with my informix database on the same machine.
>
> I know that my informix database is properly setup as I can get my
> application to
> connect to it without any problems. (Informix 7.30 with
> client sdk 2.10).
>
> I follow the suggestions for the informix driver in the manual at the
> www.unixodbc.org
> but still it fail.
>
> isql <dsn_name>
> gives the following errors:-
> [ISQL] ERROR: Could not SQLConnect
>
> Even if I do "isql rubbish", it gives the same error.
>
> Any idea what is wrong or how else I can try.
>
> Thanks,
>
> Hock Soon
> email: hocksoon@xxxxxxxxxxxxx
>