Page 1 of 1

recompiling php to use mssql extension

Posted: Thu Jul 22, 2010 11:27 am
by manouche
Hello all,

I have a Linux box with Redhat ES 3, using PHP 4.3.2. It will all be upgraded in another 6 months, but I need to get this problem resolved before then.

I want to use php to query an SQL Server 2005 on a Windows server. I have freetds installed and configured and can do command line querying.

I added the line: extension=mssql.so to the php.ini file.

Now, I believe I need to recompile php to use the extension. My question is whether I need to do a recompile on the existing install, or can I install it in another area and just move the mssql.so file into the current install?

Also, php was installed as an rpm. If I want to recompile, I assume I need a source rpm (version 4.3.2), but then how do I apply the current configuration information. I have all that information, collected from the phpinfo.php file. I would add ghis:

--with-mssql=/usr/local so that it knows about freetds

So, any tips would be great. Can I use an rpm to do what I want?

Re: recompiling php to use mssql extension

Posted: Sun Jul 25, 2010 11:34 am
by liljester
ive never been successful getting php to talk to mssql from linux. but to be honest, i really didnt try very hard because its a pretty easy feat with a windows server :P

Re: recompiling php to use mssql extension

Posted: Mon Jul 26, 2010 2:41 pm
by Doug G
You need to install freeTDS, then set up a ODBC connection to the mssql server in freeTDS. Then you should be able to connect using php_odbc.