How to add mssql extension into PHP4

[kenson]

Hi,

I would like to get some help from you. I need to build a system that PHP exec MSSQL store procedure statement. In order to do this i need to use mssql_bind. But i need to add extension into my PHP4. How can i do add extension (MSSQL)?

Note: I have done installed freeTDS (usr/local/freetds)

Or there is any way to exec MSSQL store procedure in PHP like ODBC?

Thanks for helping me.

[wildteen88]

What OS are you using? Windows, Mac or Linux (*nix)

if its Mac or Linux then you'll need to recompile PHP with the --with-mssql=[DIR] command.

[DIR] being the full path to the directory in which you have installed FreeTDS. Also make sure FreeTDS was compiled with the --enable-msdblib command. (Taken from [url=http://uk2.php.net/manual/en/ref.mssql.php]php.net[/url])

Then you'll need to uncomment/add the following line in/to the php.ini:
extension=php_mssql.dll

NOTE: if you are not using Windows then it'll be extension=php_mssql.so instead I believe.

However if you are using Windows then you don't need to bother with the above. Just uncomment/add the following line in/to the php.ini:
extension=php_mssql.dll