Hi all,
I've been doing some research into connecting to an Access database from a
php script running on a Linux box, and found that iODBC was one way to go.
However, the HOW-TO ( from www.iodbc.org )and most other correspondance I
can find on the topic, relate to connecting from Linux to a Windows server
and pointing a DSN entry on the Linux server to the DSN entry for the
database on the Windows box.
However, what i want to be able to do is connect to my Access database, which is
sitting on my local filesystem in mounted windows directory. I dont have
any other servers etc, so i want to just to set up a DSN that points to the Access database in its mounted directory, and uses the odbc drivers from iODBC to query it.
So firstly, is this possible ? And if so, could someone please give me some detailed instructions on how the DSN and iODBC needs to be set up, in order to query the Access database (hosted on a linux server) from a linux server.
I'd appreciate any help you can give.
Thanks
Matt
