Our company has a db on a Windows box running IIS/MSSQL. There's a table full of site names & addresses that gets updated regularly. We have another system on a LAMP settup that's on a different domain but still inside of the corporate firewall. I'd like to run a query against the data in the MSSQL table on the LAMP system. Here's what I can't do though:
-Can't install mssql_connect because I don't have access to the linux box
-Can't use file() or fopen() for some reason. Whenever I try either function, the script runs for a minute or two and then times out.
-Can't schedule dumps/imports because again, I don't have access to the linux box
-Can't manually dump the MSSQL table because data gets updated regularly.
I was able to come up with a solution where I had a php page that submitted a POST form to a page on the windows box that in turn ran a query and returned the results in a comma-separated POST value back to the originating form. I then take those values and explode them into an array. While this worked as I was testing, I'm not sure how to implement this into an actual working page.
I suspect that there's either firewall or IIS settings that are preventing me from using file() or fopen() because I can use those with http://google.com
. I have no clue if that's the case though. Any help would be greatly appreciated!