Hi,
-->Machine A
-->Operating System Windows 2000 Advanced Server
-->Database MS SQL Server 2000
-->Machine B
-->Operating System Windows 98
-->Web Server PWS
-->Server side program PHP
Using ADODB I am able to connect Database in Machine A (SQL Server) from Machine B (PHP) and retreive data but I am not able to execute Stored Procedures.
To make the picture more clearer here is the code I used to connect and retreive data:
<?php
$dbc = new COM("ADODB.Connection");
$dbc->Open("Provider=SQLOLEDB; Data Source=smita; ".
"Initial Catalog=Intranet_testbed; User Id=sa; Password=sa");
$rs = $dbc->Execute("select * from Intranet_User_Master");
while (!$rs->EOF)
{
echo $rs->Fields["Login_name"]->value . "<BR>";
$rs->MoveNext();
}
$rs->Close();
$rs = null;
$dbc->Close();
$dbc = null;
?>
please help me as I have got stuck here for a long time
Thanks in advance
--Fiyaz.
