Denny and I were looking into this and yes it should work. I tried to get Sun drivers to do it and that did not work. It needed and ..dll or something.
Type 4 drivers are the best one to get. let us know if you have any problems or errors. Dan On 7/27/06, Greg Hamer <[EMAIL PROTECTED]> wrote: > > I am trying to confirm is anyone has ever succeeded using CF on *nix to > connect to Microsoft Access? (Bonus points if it is on Solaris :) > > NOTE: I do not want any taunts or teasing for asking about this. I am > not > considering doing this. I do, however, have a friend who due to > bureaucratic rigmarole would benefit it they can get a CF/Solaris/Access > configuration working while they transition to other databases. > > I see that there are JDBC drivers for Access > (Jackcess<http://jackcess.sourceforge.net/faq.html>, > MDB Tools <http://mdbtools.sourceforge.net/>, and Jakarta > POI<http://jakarta.apache.org/poi/>). > So I figure that this should be doable since: > > - ColdFusion is Java (since version MX/6) > - Java talks to data files using drivers, e.g. JDBC or a JDBC-to-ODBC > bridge > - .MDB is a dumb file format > > I am asking because before my friend puts in more time on this, it would > be > nice to know if anyone in the CF community has succeded in getting a > CF/*nix/Access configuration working. > > OFF LIST REPLIES ARE OK BY ME. > > Thanks, > > g > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247948 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
