Hello!
As most people here, I've got a question. I'm part of a team that is supposed to rebuild a working web application to fit a certain provider's system. It's an application built in PHP, and it depends heavily on MySQL. Here's the trouble: The provider systems don't support MySQL.
In an 'extreme' case we might opt to have the ISP make ODBC links available, but if there's any other way to rebuild without installing anything new, we're supposed to go with that...
The server runs Win2k with IIS/5.0, PHP installed & working.
The question boils down to this:
How can someone connect to a database and execute a query on an IIS/5.0 running having nothing else but PHP and Access drivers installed?
I'm looking for an PHP equivalent of this piece of ASP:
oConn = Server.CreateObject("ADODB.Connection");
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" + Server.MapPath("\\pathto\\anaccessdatabase.mdb"))
sSQL = "SELECT * FROM Table";
oRS = oConn.Execute(sSQL);
Any suggestions are welcome...
