Linking to a Remote MS SQL Server from MySQL

[dpdoug]

We have a Web server in Houston running a Linux box with MySQL. Is there any way to connect to a SQL Server database running on a web server in Chicago so that the web site hosted in Houston can query the MS SQL Server database in Chicago, in case the product is not available in Houston?

(I know PHP has connection functions for MSSQL Server)

I hope my question is clear.

Thanks

David

 

[QatQat]

If you are trying to link to MSSQL using MySQL as you would do with MS Access the answer is no.

MySQL is a database server and not a personal db application as Access.


Bye

Qatqat

Life is what happens when you are making other plans.

 

[vbkris]

(I know PHP has connection functions for MSSQL Server) - The only way out...


Known is handfull, Unknown is worldfull