php and unixODBC

[John Gruber]

Nevermind... It was an environment thing. odbcinst put its odbc.ini file
in my home directory like it is supposed to. (for us older folks... it
needs a man page!) 

Fixed /etc/odbc.ini to include my datasource, reloaded Apache, and it
works great.  

Sorry to waste everyone's time.

John
 

-----Original Message-----
From: John Gruber 
Sent: Wednesday, October 13, 2004 9:57 AM
To: 'redhat-list at redhat.com'
Subject: php and unixODBC

I'm running Redhat ES 3 and have a problem. 

I installed the FreeTDS packages and have unixODBC setup to communicate
to a MS SQL Server. The iSQL tool and the php CLI have no problem
talking to my database. When I call the same php script from libphp4
apache I get the following:

Warning: SQL error: [unixODBC][Driver Manager]Data source name not
found, and no default driver specified, SQL state IM002 in SQLConnect

Mind you the php command line runs the scripts, talks to the database
and returns my record set. I assume this is an environment thing.  Can
anyone tell me how to setup my php.ini or set environment for apache to
be able to talk to my database? Is it not finding /etc/odbc.ini or what?

Thanks you smart people!

John Gruber