MSSQL Procedures
| From: | Nabil Attar | Date: | Sat, 14 Jun 2003 11:43:25 +0000 |
| Subject: | MSSQL Procedures | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28611@lists.php.net to get a copy of this message | ||
Jeson Hi , this is Nabil from PHP list, i wonder if u could help with the
following:
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 execute
those specific procedure , and I only got the returned value...
My server that I will connect from is Linux, apache with MySQL database, and
my code ofcourse PHP....
How can i connect to microsoft SQL server from my php linux server..??? i
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 execute
them, and get the return values...
One of the stored procedures that i got a copy from the remote administrator
is :
Waiting for any comment ....
/////
--==========================================================================
=======
CREATE PROCEDURE ChangePasswd
@login varchar(32) ,
@oldpass varchar(16),
@newpass varchar(16)
AS
declare @chkpass int
set @chkpass = (select count(*) from subaccounts where login=@login and
password=@oldpass)
if @chkpass<>0
begin
update subaccounts set password=@newpass where login=@login and
password=@oldpass
select '0' as err
end
else
begin
select '1' as err
end
Go
--==========================================================================
=======
////