I have PH4.2.3, Apache and MSSQL Server 2000. I can connect to SQL server, and using
some stored procedure, query etc.
$dbalias = "MyServerName";
$db1 = @mssql_connect($dbalias, "sa", "");
if (!$db1) {echo "no connection1<br>"; exit();}
mssql_select_db('northwind', $db1);
$sp = mssql_init("CustOrdersDetail", $db1);
$pr = 10248;
mssql_bind($sp, "@OrderID", $Pr, SQLINT2, false);
$rs = mssql_execute($sp);
THIS IS OK
$db2 = @mssql_connect($dbalias, "sa", "");
if (!$db2) {echo "no connection2<br>"; exit();}
mssql_select_db('pubs', $db2);
$sp = mssql_init("byroyalty ", $db2);
$pr = 100;
mssql_bind($sp, "@percentage", $pr, SQLINT2, false);
$rs = mssql_execute($sp);
Also this is OK
BUT, when i try this lines (again)
$sp1 = mssql_init("CustOrdersDetail", $db1);
$pr1 = 10248;
mssql_bind($sp1, "@OrderID", $Pr1, SQLINT2, false);
$rs1 = mssql_execute($sp1);
I get this message:
Warning: MS SQL message: Could not find stored procedure 'CustOrdersDetail'. (severity 16)
How can i fix it this problem.
(In this time i'm using 3 databases (both SQL SERVER 2000) and many databases are remote connections)
Many thanks in your advance,
Regards,
Ali Çetintürk
http://www.alicetinturk.150m.com
cetinturkali@yahoo.ie