Establishing a JDBC connection should be as easy as falling off a log. You go to the dsn area, give the thing a name and pick your dsn type. For Access I would pick MS Access with Unicode Support. Then the dialog pops up and I would select the file location via the java applet tree (almost the same as in older CF versions). At that point you can press 'save' and you should be done, assuming no password/login issues to the .mdb file.
On 8/27/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>Are you doing this to add a dsn programmatically to extend your CFX? > > Well, the first step would be at least to have a couple of JDBC > connections in my system, so I'm just using > the CF Administrator to define a couple of them on some databases I have. > > I've been able to create one on the compassTravel example in the docs, > because they explain EXACTY what to do, > but when I try to adapt to another Acces file, the verify step tells me > that it cannot find the file. > > Now talking about CFX_JDBCinfo, I doubt I could do it in the same tag, > since all the JDBC environment is in JAVA, > and the ODBC is in C. I'm looking for an ODBC to JDBC bridge in C, but I > doubt it exists. > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216591 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
