I don't think JDBC driver definitions are any better in CFMX-7. JDBC seems to perform a ton better when I am using it to access our iSeries AS400, but if you are using Access as a DB, why not just use an ODBC driver? Access is not exactly the most speedy database, so I wouldn't think it would be an issue for you...?
Chris -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 4:58 PM To: SQL Subject: JDBC nightmare Hi, I'm trying to install a JDBC DS under CFMX 6.1 It's really a mess! :-( I succeeded to define the compassTravel example as described in the docs, but cannot manage to install any other DS on any other Access database, even scupuleously copiing the path name with same upper and lower case. Apparently one need to give this line in JDBC URL: jdbc:pointbase:compasstravel,database.home=C:/inetsrv/wwwroot/cfdocs/get ting_started/db just to tell where the Acces C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd is. Why doesn't the Administrator just take C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd and does whatever needs to be done with it? Another thing is the "driver class" which need to be "com.pointbase.jdbc.jdbcUniversalDriver" How can I guess what are the other classes, and I suspect the other drivers available? My question, is this mess any better under CFMX 7, and is it worth upgrading? -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase RoboHelp from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=59 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2384 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
