Skip to Content.
Sympa Menu

freetds - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Joffrey Pannequin <joffrey.pannequin AT laposte.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3
  • Date: Fri, 04 Feb 2005 11:44:20 +0000

Joffrey Pannequin wrote:

Hello,

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 :
https://lists.ibiblio.org/sympa/arc/freetds/2004q3/016748.html

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 :

<?php
$con = mssql_connect ("ip:port", "user", "****");
mssql_select_db ("db_name", $con);
$sql= "SELECT * FROM TABLE";
sleep(30);
$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>";
mssql_close ($con);
?>

It works on the command line of php, but not from apache.
Why ?

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 :

UnixODBC :
./configure --prefix=/usr/local/unixODBC --enable-gui=no

Freetds :

./configure --prefix=/usr/local/freetds
--with-unixodbc=/usr/local/unixODBC --with-tdsver=8.0 --enable-dbmfix

PHP :
./configure --prefix=/usr/local/php
--with-apxs=/usr/local/apache/bin/apxs
--with-oci8=/oracle/oracle8/app/oracle/product/8.1.7
--with-mssql=/usr/local/freetds --without-mysql
--with-unixODBC=/usr/local/unixODBC

Thanks,

Joffrey Pannequin

______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

Some info :
The TDSCONFDUMP displays quite a lot of information. But TDSCONF only displays this :
Starting log file for FreeTDS 0.62.4
on 2005-02-04 08:52:25 with debug level 99.
So according to the source code, it locks after reading the conf but before opening the network connection to the DB.





Archive powered by MHonArc 2.6.24.

Top of Page