[PHP-DEV] PHP 4.0 Bug #7781 Updated: Unable to connect to ODBC Datasource From: ties <email protected>
Date: 11/15/00

ID: 7781
User Update by: ties <email protected>
Old-Status: Feedback
Status: Closed
Bug Type: ODBC related
Description: Unable to connect to ODBC Datasource

There was a problem with the ODBC.ini file. ODBCConfig did not save it as /etc/odbc.ini. Problem solved. Thanks for your suggestions !

Previous Comments:
---------------------------------------------------------------------------

[2000-11-13 10:19:14] kara <email protected>
Does the user your webserver runs as (usually nobody) has read access to the odbc.ini file?

Maybe you have to set the environment variable ODBCINI pointing to the odbc.ini file location.

---------------------------------------------------------------------------

[2000-11-13 09:05:11] ties <email protected>
This error i get when connecting to a unixODBC datasource:

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/test.php4 on line 8

unixODBC 1.8.12 is correctly setup, I can access my Postgres database via the supplied 'DataManager' application. But somehow there seems to be no connection possible between PHP and the ODBC Driver manager. These are the compile options I used for PHP:

./configure --with-apxs=/usr/sbin/apxs --target=i386-redhat-linux --prefix=/usr --with-config-file-path=/etc --disable-debug --enable-pic --enable-inline-optimization --disable-static --with-exec-dir=/usr/bin --with-regex=system --with-gettext --with-gd --enable-debugger --with-jpeg-dir=/usr --with-png --with-zlib --with-gdbm --enable-safe-mode --enable-sysvsem --enable-sysvshm --enable-track-vars --without-mysql --with-unixODBC=/usr/local

---------------------------------------------------------------------------

Full Bug description available at: http://bugs.php.net/?id=7781 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>