Query for 2 MSSQL server problem

From: Date: Fri, 25 Aug 2000 07:32:44 +0000
Subject: Query for 2 MSSQL server problem
Groups: php.db 
Request: Send a blank email to php-db+get-2362@lists.php.net to get a copy of this message
Dear all, There is tableA in MS-SQL server A, and tableB in MS-SQL server B. I want to do is "select count(*) from serverA.tableA, serverB.tableB where serverA.tableA.id = serverB.tableB.id" i put this statement as a stored procedure on serverA and run it (using Query Analyzer), it works, but when i using PHP3 to connect to serverA, and execute the same sproc, it fails...... I use Sybase's Openclient to connect to MS-SQL 7.0 Can anyone tell me how to do that? is it able to do that through PHP??? Thanks....

« previous php.db (#2362) next »