Hi, folks. My first post here -- I'm a greenhorn to PHP and need some assistance with connecting to a remote server/database. I posted this message on another forum and have had no "nibbles," so I'm hoping someone here can help me.
I'm doing some programming in an academic setting with a mix of servers. I started out on an IIS server and now need to author some code in PHP on another server.
Server #1: My original ASP code references data in a couple of different MS Access databases. The ASP code and the databases are stored side-by-side in folders on the IIS server (security isn't a concern). That stuff needs to stay where it is because the ASP site is still used heavily.
Server #2: The new PHP development I'm undertaking is taking place on another server, but I need the PHP code I'm authoring to read the data stored over on the IIS server.
I've searched and found a lot of tutorials for PHP code that will read an MS Access database, but they all make the assumption that the PHP code can connect to the database locally:
http://aspn.activestate.com/ASPN/Co...P/Recipe/163447
http://www.w3schools.com/php/php_db_odbc.asp
http://www.experts-exchange.com/Web...Q_20973403.html
... etc. ...
Problem: I need a way to connect to the databases over on the IIS server either IP address or by servername (\frontpage.sc.edu). It may help for you to know that the .mdb file I'm after in this particular instance is
\d$\wwwroot\sfa\music\music_faculty.mdb
I have the ability to administrate the IIS server and can (actually already have) made a DSN for the above-mentioned database. FWIW, I'm actually more used to establishing DSN-less connections, but I don't mind going the DSN route.
While googling I found the fopen command and wondered if that might be a solution...?
Does anyone have any suggestions? If so, I'd sure like to hear them. Thanks!
