PHP ODBC/ACCESS and Unix Servers

[Maynard]

Hi there,

We host our website on a UNIX server, but want to query an ACCESS database. This requires PHP to use ODBC. Is this possible on a UNIX server?

Sorry for simple question!

Maynard

[jatar_k]

I don't know but maybe this page can give you some pointers.

PHP Unified ODBC functions [ca.php.net]

[bcolflesh]

Also look at:

www.unixodbc.org

If you want your *nix box to connect to an ODBC data source - you're going to be much better off importing your data into mysql (or PostgreSQL, etc) in the long run though - what's keeping you on Access?

[Maynard]

What's keeping us with Access is portability. Various users need to input/access data and use a variety of storage formats eg floppies and CD-Roms.