Hi,
I have a linux machine and I installed apache_1.3.20 and added php-4.0.6 as a module. on the same machine I have postgres sql and mysql running.I also have unixODBC-1.8.13.
I have added php-4.0.6 with pqgsql and mysql and unixODBC support.
in Xwindows I configured a system DSN for postgres sql and it is perfectly working.I checked this with DataManager.However I could not add a MySQL DSN as correct driver is not available.
after configuration and making of php and apache are over i tried to access a odbc testpage (odbc-t1.php) using netscape,the return message is that the dsn in datamanager is not found though the dsn name,username and password are actually
mentioned in the testpage and submitted.
I tried my luck with using a test page to access mysql database. I gave servername as localhost,username mysql and its password.
the return message says that "can't connect to local server through socket /tmp/mysql.sock
I checked that actually a socket is created
as /var/lib/mysql/mysql.lock file.
what I haveto do to access mysql database
as well as using ODBC connection to access
pgsql database.
