Hi Everybody,
I want to execute stored procedures of MS SQL Server from PHP. As per my knowledge I can do it in two ways a) Using mssql_* functions b) By creating objects of ADODB.Connection and ADODB.Command. But in both the ways I was not able to.
Then to make mssql_* functions work I tried the suggestions given by Zois
[Author: Zois (proxy.globalsoft.com.cy)
Date: 2001-11-06 04:03:23
I was having the same problem yesterday.
But i solve it.
I use Php-4.0.6-win32.zip (4.8M😎extract it and put it to C:\php.
I copy php.ini-dist to C:\windows and rename it to php.ini
Then make the changes :
doc_root = c:\Inetpub\wwwroot
extension_dir = c:\php\extensions
extension=php_gd.dll
And everything was OK.
Try it with php_gd.dll and not with
php_mssql.dll just to check it
]
But now if I set the value of doc_root = c:\Inetpub\wwwroot I am getting a CGI Error (The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are🙂 then if I comment it the mssql_xxx functions are not working and program is not throwing any error even.
My aim is to execute SQL Server 2000 Stored procedures from PHP.
Configration details:
1) OS is windows 2000 Advanced server running MS SQL Server 2000.
2) PHP running on machine where OS is windows 98 and web server is PWS.
Please help me.
Thanks in advance.
Regards,
Fiyaz.