[freetds] Linux/MSSQL connect
Harry.Clark at knovalent.com
Mon Nov 13 15:58:57 EST 2006
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)
From: freetds-bounces at lists.ibiblio.org on behalf of Daniel Fazekas
Sent: Mon 11/13/2006 2:53 PM
To: FreeTDS Development Group
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:
phpize && ./configure && make
Finally, as root:
and there's your mssql.so if everything went correctly.
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 3538 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20061113/57b6b0e3/attachment.bin
More information about the FreeTDS