Page 1 of 1

Remote Connections to Database

Posted: Mon Feb 06, 2006 11:35 am
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.

Posted: Mon Feb 06, 2006 12:41 pm
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.

Posted: Mon Feb 06, 2006 1:03 pm
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.

Posted: Mon Feb 06, 2006 1:08 pm
by feyd
You may need to look through all of those, as each could have its own restrictions that compound.