Frank M. Kromann wrote:
This sounds like your MSSQL connections are getting mixed up. If the two databases are on the same server and the same sql login has access to both databases you can query everything from a single conenction. You just have to qualify the tables/procedures with <database>.<user>.table to the server knows where to look. If you need two different connections and the host/user and passwords are the same you must tell mssql_connect to force a new connection. Set the optional forth parameter to true.
To be a little more clear the scenario is as follows connect and use DB1 to get data for Stored Procedure connect and use DB2 via Stored Procedure getting data that can be used to get more data from DB1........and this is the one that fails. Frank, I have tried your suggestions unfortunately without success. -- Regards, Alf Stockton www.stockton.co.za Q: How many Harvard MBA's does it take to screw in a light bulb? A: Just one. He grasps it firmly and the universe revolves around him. My email disclaimer is available at www.stockton.co.za/disclaimer.html -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
