[vinochan]

Is it possible to Connect to a Mysql database located in Server_A from Server_B using PHP. If yes please tell me

I've tried the following.. but no results
mysql_pconnect('remoteserver.com','USERNAME','PASS WORD') or print("connection problem");

thanks in advance

[Nico]

Yes, but you need a special server for this. I think they're pretty expensive. The server from the company where I work has that feature and we're paying 350 $/year.

[vinochan]

thank you nico_swd

If I have the special server you mentioned, is there any thing extra to be added to mysql_pconnect()

regards

vinochan

[Nico]

This may helps:

http://forums.digitalpoint.com/showthread.php?t=62526

[FiRe]

You dont need a "special server" just enter the domain like you have done. The only thing is it may need some configuration, for example if you have cpanel you have to add the ip your connecting from to the access list, in order to access the database.

[Nico]

Well, I got told that most servers don't support external database access. Would be good they would though, this way we wouldn't have to pay 350 $ for it.