Hi,
i have the following problem,
i need to connect to a ms-access database with a linux server.
the background:
my boss wants me to design a new manganment system for our firm, using php, perl and mysql on a linux server.(linux server is ready to use!)
beside this, we have a finance program depending on ms-access, in which all our costumers are logged.
to manage this it connects to the access database using a local ODBC interface on each machine.
the main spec of the project is to build a database system that keeps the finance program database in use. that means i need to connect to this database, without buying any new hard or software! (e.g.MS-SQL Server)
to solve the problem i have been searching the internet for some kind of driver, without luck. i seems to be unpossible to get those to databases connected.
till now i have 3 ideas how this could work but i'm not sure i would.
i was thinking about cloning the access database in the mysql database and keep it uptodate through a java applet checking the ms-access for changes, anytime a database request i done.
<< this seems to be realy slow. >>
how about using the applet to get just the primary key, from the access database and insert it to the mysql db.
<< but this seems to be to complicated, depending on synchronizing the applet and the php page and on programming the select statements. >>
why can't i connect directly to the local odbc interface from the server? this would be simpliest to manage.
<< but this seems not to be working as well as a solution. >>
PLEASE HELP! any suggestions, statements what what the best solution is!?
many thanks in advance
yours christian
