MSSQL returned: Invalid object name
| From: | Alf Stockton | Date: | Fri, 23 Mar 2007 14:38:38 +0000 |
| Subject: | MSSQL returned: Invalid object name | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-27595@lists.php.net to get a copy of this message | ||
I have a php script where I need to access tables in two different MSSQL databases.
The scenario is ..... access 1st database to retrieve data that will be used when calling a StoredProcedure within the 2nd database which will return data with which one can access the 1st database to retrieve more data.
If I do both calls to the 1st database by hardcoding info from 2nd database all works well but if I access 1st, call StoredProcedure then attempt to do a select back on the 1st I get :-
MSSQL returned: Invalid object name 'EarnRate'
EarnRate is an existing table in 1st database.
Please help.
--
Regards,
Alf Stockton www.stockton.co.za
Q: What do you call a principal female opera singer whose high C
is lower than those of other principal female opera singers?
A: A deep C diva.
My email disclaimer is available at www.stockton.co.za/disclaimer.html