[unixODBC-support] Trouble reading odbc.ini?
derrick at foundationcomputing.com
Sat Sep 11 02:13:36 BST 2004
System: Linux Enterprise 8
PHP: Version 4.1.2
Special Driver: Progress_SQL92_Driver
User: Linux "Newbie"
Trying to get PHP's ODBC to talk to Progress database.
The SQLEplorer that is installed with the Progress Client works OK, but
it appears that something is wrong with the unixODBC as called from
within PHP. It appears that the odbc.ini file simply never gets read,
and so when I try to connect with an "odbc_connect($dsn,$user,$pass)"
statement I get this:
Warning: SQL error: [unixODBC][Driver Manager]Data source name not
found, and no default driver specified, SQL state IM002
Using phpinfo() I can see that: The ODBC environment has unixODBC
enabled; my LD_LIBRARY_PATH includes the path to the pgpro915.so
driver file; and the ODBCINI points to /etc/odbc.ini like it's supposed
to. I've got the odbc.ini file configured per Progress' documented
recommendations for this. I've gone over the DSN name, driver name,
file names, and path names dozens of times, and I'm pretty sure I've
got them all correct.
Using odbcinst -q -d shows the Progress_SQL92_Driver as entered in the
Using odbcinst -q -s returns "SQLGetPrivateProfileString failed with ."
I'm kind of stuck, and don't know how to confirm that the odbc.ini file
is being read, or force it to get read, or anything like that. Can
anybody point me in the right direction to get this working properly?
More information about the unixODBC-support