ColdFusion MX on Mac OS X, Part 3
Subject:   Windows to Mac port
Date:   2002-11-13 17:51:32
From:   dicklacara
Response to: Windows to Mac port

My first encounter with CFMX was as a member of the prerelease beta team. I signed up because I thought that Mac OS X was likely a part of the beta. It was not.

When I expressed my disappointment, some Macromedia beta members (particularly Jesse Noller) expressed the opinion that a CF 'Nix product could probably be made to run without too much effort.

I asked about porting a Windows version (I did not have Linux). The answer was that because of file system differences, os facilities (such as the registry), script files, organization, etc. it would take a lot more work and was a lot less likely to be successful.

The Linux port was the recommended approach.

My impression is that you could spend a lot more $ and hours trying to port a win version that may not work -- Linux is virtually free.

As to the need to run MS-Access on any non-windows platform:

This is a common request.

Here's the short answer: No, MS-Access runs *solely* on the windows platform.

No one has developed a driver to interface MS-Access because all the logic of MS-Access is in the ODBC driver, itself -- they would be converting MS-Access to the other platform. I don't know if MS will not allow this, of if they just have made it too expensive -- but it is not available.

It should be noted that MS-Access is a poor choice for a production online database, for lots of reasons. It was not designed for that purpose; and as few as 1 concurrent user can lockup a MS-Access database, requiring a lot of fiddling to get it going again.

That said, because of its ubiquity, MS-Access is an excellent vehicle to use to create an online db with a more robust RDBMS. Also, to periodically create a copy of an online db for offline use.

With that in mind, there is a way that you can interface CFMX on a non-windows (Mac OS X, Linux, Unix, etc.) platform with MS-Access databases on a (real or emulated) windows platform.

The procedure for doing this is too complex to cover here, and it is not free.

At the end of Part 4 there will be a poll of the next topics tha`t are available. Interfacing MS-Access databases is one of these topics.

So, if the interest warrants, it will be covered in the near future.