Women in Technology

Hear us Roar



Article:
  ColdFusion MX on Mac OS X, Part 3
Subject:   Access Problem
Date:   2002-10-16 12:14:00
From:   anonymous2
Hi,
First of all Thanks soooo much for this Dick, the installation wasn't easy for me - but i got to learn a bit more than i had known about UNIX commands and in the end it worked - which is great. I've set CF to work with mysql on my powerbook, which is working great. But i can't seem to get the Access driver to work. Do I have to create an ODBC to JDBC connection? or is their an existing driver that would work?


I know access isn't made for Mac but i would like to use the examples from the Ben Forta books - which use access files - any suggestions would be much appretiated. Thanks Again - Looking forward to part 4!
Jimmy

Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • Access Problem
    2002-10-16 19:19:00  dicklacara [View]

    There is a way to do this -- I just converted a large MS-Access db to Sybase ASE, using CFMX on Mac OS X.

    However, it is a bit involved -- MS-Access runs only on win machines. The reason that noone has written a MS-Access driver for Linux, Unix, OS X, etc is that most all the logic of MS-Access is in the ODBC Driver, itself.

    This means that you need to run win (real or emulated) to run MS-Access.

    Then, you need 3rd-party software to interface non-win CFMX to the win MS-Access.

    It is beyond the scope of this forum -- I plan to cover MS-Access and FileMaker in a later article.

    Patience -- there is so much that we can now do, it is hard to prioritize.

    Dick