FreeTDS Development Group

["Clark, Harry" <Harry.Clark AT knovalent.com>]

Thank you Daniel. I can run an ODBC query from PHP so I will settle for that. 
It seems there are at least 3 methods of PHP-MSSQL--ODBC, MDB2 and the MSSQL 
functions (on Linux as well as Windows??) I found some discussion that mixed 
up FreeTDS with "building PHP with MSSQL" which only meant loading the module 
dynamically (like most software does these days). Here is an article on 
Linux-MSSQL via ODBC. http://www.linuxjournal.com/article/6636 An article 
comparing all the methods would be useful (to us Linux wannabees)

-----Original Message-----
From:   freetds-bounces AT lists.ibiblio.org on behalf of Daniel Fazekas
Sent:   Mon 11/13/2006 2:53 PM
To:     FreeTDS Development Group
Cc:     
Subject:        Re: [freetds] Linux/MSSQL connect


On Nov 13, 2006, at 20:28, Clark, Harry wrote:

>> I'm trying to reach MSSQL 2000 from Linux (FC5). I have FreeTDS  
>> and unixODBC installed and can connect with tsql. isql gives
> Fixed that, error on the connection info. I can execute a query  
> from the cmd line on the Linux box. I want to use this in PHP. Do I  
> really need to rebuild PHP with the --with-mssql option?

If by "this," you mean via unixODBC, then no -- in that case, you'd  
use the ODBC php extension instead.
The mssql extension is for interfacing FreeTDS directly, without  
going through unixODBC as a middleman.

Even then, it should not be necessary to rebuild the whole of php.

> At minimum I need to specify extension=mssql.so in php.ini and find  
> a current mssql.so;

You just need to grab the source code of your system's PHP. Then go  
into the subdirectory of the extension you wish to build:
cd ext/mssql
phpize && ./configure && make

Finally, as root:
make install

and there's your mssql.so if everything went correctly.

--
fds




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

<<winmail.dat>>