Query for 2 MSSQL server problem
| From: | Hikaru | 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....