The easy way is to use the mssql functions in PHP. You can see how to
configure PHP with these in the online manual: http://www.php.net/mssql.
You need to download and install FreeTDS (http://freetds.org).
You can also use the online manual to get samples on how to execute stored
procedures and retreive the return values.
> Jeson Hi , this is Nabil from PHP list, i wonder if u could help with
> I have a stored procedure on a remote Microsoft (stupid) SQL server..
> and I have to connect to it remotely and I have only permission to
> those specific procedure , and I only got the returned value...
> My server that I will connect from is Linux, apache with MySQL database,
> my code ofcourse PHP....
> How can i connect to microsoft SQL server from my php linux server..???
> think ODBC is not excisted in Linux...
> ( I reserve to myself to be wrong)...
> Please help me if I can , how can I connect to that server , and
> them, and get the return values...
> One of the stored procedures that i got a copy from the remote
> is :
> Waiting for any comment ....
> CREATE PROCEDURE ChangePasswd
> @login varchar(32) ,
> @oldpass varchar(16),
> @newpass varchar(16)
> declare @chkpass int
> set @chkpass = (select count(*) from subaccounts where [EMAIL PROTECTED] and
> [EMAIL PROTECTED])
> if @chkpass<>0
> update subaccounts set [EMAIL PROTECTED] where [EMAIL PROTECTED] and
> [EMAIL PROTECTED]
> select '0' as err
> select '1' as err
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php