> How does CFMX create DSN's differently to CF5 ? > I presume it uses a JDBC bridge as creating DSN's in control panel > doesn't work, but if you do this then go and create it via CFADMIN it > already knows where the database file is. > Is is posisble to probgramatically create CFMX DSN's, or is there an XML > file somewhere you can work with ? >
Right... DSN are in jrun-resources.xml and neo-query.xml. Make sure that they don't get out of sync or otherwise you're gonna wind up with a right old mess. >From the hand of Steven Erat : "On start up it reads jrun-resources.xml, finds the (top-most) node (#1) for a datasource, and updates neo-query with that data. When you edit the datasource from the admin, those modifications will cause the top-most node (#1) to be removed and a new node (#3) to be written, while leaving the previous bottom-most node (#2) which makes it node #1 for that datasource. In other words it reads from the top and writes to the bottom. If the ! new node data is good, then you'll run for as long as CF is up, but when you restart, the top node (#1(#2)) will be read and used, not #3. If there was only one node for a datasource, then it would do the right thing... remove it and rewrite it, but instead there are multiple nodes being shuffled." Incidently, you should be able to get access to the DSN via the serviceFactory too, but don't ask me how and it might be more hassle than its worth... :o) Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
