Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2007
    Posts
    4

    Unanswered: Reading from a MS access database on a unix box

    I'm running php on a unix server and I have the need to query a jet database file. The file is local on my unix server. I don't want to connect remotely to a windows server, I want to open the file locally and run queries against it. I can do this from php on a windows machine, but I'm having trouble finding a way to do it on unix.

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Doesn't MSAccess require an ODBC connection setting up for it?

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    doesn't php have a mechanism for reading ODB files
    ...of course you could always export the data to say a MySQL database, using something like dbtools, or do the process manually in PHPMyDAmdin or MyQL Query Browser
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jun 2007
    Posts
    4
    Quote Originally Posted by aschk
    Doesn't MSAccess require an ODBC connection setting up for it?
    That's why I can easily do it on windows but not unix.

  5. #5
    Join Date
    Jun 2007
    Posts
    4
    Quote Originally Posted by healdem
    doesn't php have a mechanism for reading ODB files
    ...of course you could always export the data to say a MySQL database, using something like dbtools, or do the process manually in PHPMyDAmdin or MyQL Query Browser
    That's the whole point of the app, I want to have my users upload their jet databases and my app will merge it into a big mysql database.

  6. #6
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    In which case you need to find a JetSQL driver for use on unix so that you may set up an ODBC DSN...

  7. #7
    Join Date
    Jun 2007
    Posts
    4
    exactly.... but thus far I'm not seeing that such a thing exists. Was hoping someone here could point me in the right direction.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •