[freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3
joffrey.pannequin at laposte.net
Fri Feb 4 06:10:30 EST 2005
I have several problems making freetds and php works together under AIX.
Has anyone successdully used this installation ?
At first, the apps and pools did not link OK. So I had to use the idea
of Fréderic le Guillou :
Now I have freetds which compiles and links OK. I can test the
connection to a SQL*Server DB with tsql.
I made this PHP test script :
$con = mssql_connect ("ip:port", "user", "****");
mssql_select_db ("db_name", $con);
$sql= "SELECT * FROM TABLE";
$rs= mssql_query ($sql, $con);
echo "<html><head>/Title/</head><body>The field number one is:";
echo mssql_result ($rs, 0, 0);
echo " </body></html>";
It works on the command line of php, but not from apache.
Another problem : when I change the code of freetds, i can recompile and
install in /usr/local/freetds the libraries, but it seems php does not
use the libraries (I can delete them, php command line still works).
My compilation directive :
./configure --prefix=/usr/local/unixODBC --enable-gui=no
--with-unixodbc=/usr/local/unixODBC --with-tdsver=8.0 --enable-dbmfix
More information about the FreeTDS