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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
The Pie Man
Forum Newbie
Posts: 2
Joined: Mon Dec 02, 2002 11:54 am

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

Post 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!
The Pie Man
Forum Newbie
Posts: 2
Joined: Mon Dec 02, 2002 11:54 am

Forgot to mention

Post 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.
pistolfire99
Forum Commoner
Posts: 58
Joined: Thu May 23, 2002 3:18 pm

Post 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.
Rincewind
Forum Commoner
Posts: 27
Joined: Thu Nov 21, 2002 11:15 am
Location: Norway

Post 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
Post Reply