freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
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, 4 Feb 2005 11:58:23 +0100

>
> 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 ?
>

Usually this is caused by ignoring that apache run with another account and
do not find user configurations.

> 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
>

freddy77

[freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
- Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
- Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
  - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Frediano Ziglio, 02/05/2005
- <Possible follow-up(s)>
- RE: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, ZIGLIO, Frediano, VF-IT, 02/04/2005
  - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
    - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, James K. Lowden, 02/04/2005
      - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005