Skip to Content.
Sympa Menu

freetds - Re: [freetds] Linux/MSSQL connect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Clark, Harry" <Harry.Clark AT knovalent.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Linux/MSSQL connect
  • Date: Mon, 13 Nov 2006 15:58:57 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page