Remote Connections to Database
Moderator: General Moderators
Remote Connections to Database
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.
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
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.
Instead you may want to create an interface on the Access server which allows the interaction you desire. Hopefully it's just reading.
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.