Lawrence B. Afrin, M.D. wrote: > David -- > > Ignoring, for the moment, the raging battle between the purists and practicalists as >to what distinguishes a "real" database :-) , there are at least > three ways I can think of to solve your problem: > > (1) Buy a Linux ODBC driver for Access. .. > (2) There's a product (sorry, can't remember who makes it or what it costs) for >Linux called an ODBC bridge that will let you set up an ODBC datasource > on your Linux box that talks to an ODBC datasource on a Windows box .. > (3) If you have a SQL Server 2000 available somewhere (SQL Server 7 may even be able >to do this, I can't remember), then your problem may be solvable > without having to purchase any additional third-party products.
I don't think any of these solutions will scale well into the CF MX age. The change to JDBC makes ODBC an undesired option. But maybe the third option is OK, if you make sure you have decent JDBC drivers for MS SQL, but I would recommend caution and investigation :) Jochem ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
