Jackcess looked the coolest, but it seems it needs a 1.5 JRE. I don't think POI does access, but I could have missed it.
I didn't check if mdbtools had "write" in the 0.6 pre release, if so, that could be an option, using cfexecute maybe? Not sure if it's a command line engine or not... Simplest would be to find an acceptable MS machine, and link to it via ODBC, I reckon. If that's an option. It wouldn't take much horsepower ;-). A linux solution would be more fun, of course. ** I agree with Dave about keeping ODBC as an option. And about assuming the best (maybe even when proven otherwise ;) about comments. It's hard sometimes to keep things segregated, or turn a cheek, I know. CF-TALK seems to be a rather random assortment of individuals spread across the spectrum, which I enjoy. Well moderated, with plenty of even keeled folk, so I don't worry if someone takes offense, we're all entitled to it. Best to not let it get out of hand though. It's also a high traffic list, so clarity is important (I try, but quite often think: "doh, I could have said that better" "I hope it still made sense". heh) Somehow those two are linked. Traffic and the need for clarity. Hmm. Someday I'll look into the phenomenon. Anyways... isn't nifty stuff nifty? Yeah, that's the ticket... :Denny 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:248110 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
