Is there a way to connect MySQL to a SQL DB using PHP and not using mssql_pconnect()?
I want to connect a MySQL server (a gs server from mediaTemple) to a MySQL server using PHP, I cannot use the mssql_pconnect() function because they don't support it for their gs server开发者_如何学Gos so I'm looking for an alternate route, I don't know if it's even possible.
What I want is to generate a connection on the MySQL server using PHP that will allow me to retrieve certain information from a View on a different server that's running SQL.
They probably don't support mssql_pconnect() because its for connecting to MSSQL and not MySQL, try using mysql_connect() or mysql_pconnect();
You should be able to establish 2 different database connections to 2 mysql servers simultaneously, as long as the host doesn't have some firewall rule that blocks the connection or some other safeguard like selinux.
精彩评论