PHP/MSSQL Linked Server question
OK, so I have my application running on IIS/PHP and MSSQL. There is an external Enterprise system which I needed data from, and it was easy enough to make another MSSQL connection to it to grab the data.
Then I decided I wanted to do joins across the databases. So I created a Linked Server to the other database using Enterprise Manager, and if I use the Query Tool I can access the data in the linked server just fine.
Problem is the mssql_query function doesn't appear to want to access the linked data - I keep getting esoteric errors from mssql (which I can post if people think it would be helpful in figuring this out).
Does anyone have any experience trying to do joins across 2 databases with one of them being a linked server using PHP?
Then I decided I wanted to do joins across the databases. So I created a Linked Server to the other database using Enterprise Manager, and if I use the Query Tool I can access the data in the linked server just fine.
Problem is the mssql_query function doesn't appear to want to access the linked data - I keep getting esoteric errors from mssql (which I can post if people think it would be helpful in figuring this out).
Does anyone have any experience trying to do joins across 2 databases with one of them being a linked server using PHP?