multiple servers

[chrisleon]

I have php running on one server. I access data from the SQL database all the time. I would like to access data from another SQL database on another server on my network. Can PHP do this? If so, how?

I have tried ADO and ODBC, but it gives errors about the servers not being in a relational database listing. I was not sure if it could find the SQL server across the network.

thanx

[Roger_Ramjet]

If you mean MS SQLServer then you should be using mssql connect . Lots of good advise in the user notes there, mostly about the dlls you'll need to replace.

[chrisleon]

I looked that up earlier, but it did not answer my question.

I am running PHP on a box.

I want to access MSSQL data on another box.

Is this possible?

[Roger_Ramjet]

Yes. Just read the manual and follow the instructions. Pay particular attention to the user notes at the bottom as they will answer many of the problems you could encounter.