Page 1 of 1

Am I screwed --- or --- Can I connect Unix+PHP to MS Access?

Posted: Mon Dec 02, 2002 11:54 am
by The Pie Man
I have got a PHP based website hosted on a Unix server which I have found out needs to connect to a remote MS Access db. I thought at first PEAR::DB would come to my rescue with the ADO package, but it looks like the ADO package needs to be run on a windows server. I would like to keep the site on a Unix machine for various reasons and am hoping there is something I am missing...

Does anyone know a way to connect to a MS Access db server from a PHP<->Unix setup?

Thanks for any help!

Forgot to mention

Posted: Tue Dec 03, 2002 8:59 am
by The Pie Man
I forgot to mention what makes this difficult. I don't have control of the Unix web server - it is hosted with RapidSite (ugh) and moving the site isn't an option. So I can't install anything (drivers and such) on the Unix server which would solve this problem.

Posted: Mon Dec 09, 2002 2:46 am
by pistolfire99
I dont have a solution for your problem but a suggestion. Why dont u simply export your DB to the Unix server database, I mean whatever they are running. This should make things easier. I cant think of anything else.

Posted: Tue Dec 10, 2002 6:46 am
by Rincewind
Why not use ODBC?
I'm not an expert, but that hit me as the obvious choice, of course that should give me a hint
that I overlooked something ;)
If ODBC is not an option, please tell me why, then I learn something too :)

Rincewind_the_Wizzard