1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2002
    Rep Power

    odbc access unix

    have an access database that was being used on a windows server in conjunction with asp. And now i want to switch to a unix server and use jsp or php , would i have to make any changes to the database or could it remain exactly the same?What i mean to say would the odbc driver have to be registered on the unix machine in some way?
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power
    Do you mean you want to 1. run the Access database on a Unix server, or 2. you want to connect from the Unix server to the Access database on your Windows computer?

    Answers to each below:

    1. You cannot run Access without Windows. (well, you sort of can, using Wine, but it is not likely to work well). Fortunately, there are many other databases you can use on a Unix machine, and it is fairly easy to export data from Access to these other databases. (PostgreSQL is my favorite, but you can also use MySQL.

    2. If you install UnixODBC, then you can connect from your Unix server to any Windows datasource on the network. I recommend this only if you are absolutely unable to transport your database to a Unix database. It will become the one bottleneck that slows down your server more than anything else.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com

IMN logo majestic logo threadwatch logo seochat tools logo