Database access
Posted: Thu Jan 24, 2008 3:03 am
Ok, I've got a Microsoft Access database on a Windows XP machine. What I want to do is somehow query that database using PHP via a website that people can access from wherever.
I've looked at the ODBC connectors, and from what I understand, those only work if they're on the same machine as the database, so no good for web-based remote queries.
I can't change the database type, or even move the file somewhere else, so I'm assuming I need some kind of server running on the XP machine to make the database accessible, and to make things even more complicated, its behind a router on a LAN, so I'm assuming some port forwarding is required somewhere along the line.
I've read about this solution,
- Installing Microsoft SQL server express (free)
- Installing SQL Server Management Studio Express (free)
- Create a linked server using the MS access database file as the data source
And then I assume use some PHP code to talk to the SQL Server over the web somehow. Any thoughts?
Jason
I've looked at the ODBC connectors, and from what I understand, those only work if they're on the same machine as the database, so no good for web-based remote queries.
I can't change the database type, or even move the file somewhere else, so I'm assuming I need some kind of server running on the XP machine to make the database accessible, and to make things even more complicated, its behind a router on a LAN, so I'm assuming some port forwarding is required somewhere along the line.
I've read about this solution,
- Installing Microsoft SQL server express (free)
- Installing SQL Server Management Studio Express (free)
- Create a linked server using the MS access database file as the data source
And then I assume use some PHP code to talk to the SQL Server over the web somehow. Any thoughts?
Jason