Remote Connections to Database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cfytable
Forum Commoner
Posts: 29
Joined: Thu May 12, 2005 3:36 pm

Remote Connections to Database

Post by cfytable »

I have a webspace account with a web host where I host a PHP application. I have another unaffiliated server with a dedicated IP address that runs an Acccess database. Is it possible in my PHP code at the webhost to specify the IP address of the remote server and connect to the Access database, for use with my web application? Any help[ would be appreciated.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

if your webhost supports ODBC connections, it may be possible, provided your Access server responds to outside conneciton requests. For security reasons, it's generally not recommended.

Instead you may want to create an interface on the Access server which allows the interaction you desire. Hopefully it's just reading.
cfytable
Forum Commoner
Posts: 29
Joined: Thu May 12, 2005 3:36 pm

Post by cfytable »

Thanks for the reply--that's very helpful. If I do make the configuration on the Access server side, which makes sense, would that be something that would be controlled via IIS, the firewall, or something else entirely? In other words, where would I need to specify the equivalent of "accepting incoming connections" from the webhost server? Thanks again for your help.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

You may need to look through all of those, as each could have its own restrictions that compound.
Post Reply