>>First, the CompassTravel example you're referring to isn't an Access database. It's a Pointbase database. Pointbase is a Java database server intended for embedded applications. JRun has included it for some time for sample applications; it's better for this purpose because it will work on any platform. There is an Access version of the CompassTravel database in the same directory, but you can't use the Pointbase driver to connect to it.
Ah ok, this is why I got confued, I thought I had a JDBC connection to the ACCESS file, And when I tried to modify it for another Acces file, of course, it didn't work. >>Second, if you want to connect to an Access database, you can use the "Microsoft Access" option within the CF Administrator. This will handle all the ugly JDBC URL and driver class stuff for you. All you have to do is point it to the Access file you want to use. Under the covers, this uses a product called SequeLink to connect to an ODBC datasource that CF creates for you. SequeLink is a JDBC-to-ODBC bridge. Ah ok, another thing with is not explained in the docs, I thought this would just create an ODBC connection. >>There is also another Access driver that doesn't use ODBC - it's listed within the CF Administrator as "Microsoft Access with Unicode". I'm not sure when this was introduced into CFMX, though - I think it was CFMX 6.1. Yeah, and this one is a JDBC type 3 or 4 driver, ok. >>Third, if you want to use other JDBC drivers, you can typically find out the appropriate JDBC URL and driver class syntax from the documentation that comes with those drivers. Ok, if I can find where they are ;-) I suppose some of them come with CF? Thank anyway, this is becoming more clear for me. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
