Mike Townend wrote: > > Connection verification failed for data source: xl_ds_2119962272 > []java.sql.SQLException: SQLException occurred in JDBCPool while attempting > to connect, please check your username, password, URL, and other > connectivity info. > The root cause was that: java.sql.SQLException: SQLException occurred in > JDBCPool while attempting to connect, please check your username, password, > URL, and other connectivity info.
Can you get a more detailed error message? http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full > * When you change the name of the datasource, and Submit, it is > verified correctly (presumably having forced some code to execute) What if you don't change anything but submit again? > <!--- Create Cold Fusion Datasource ---> > <cflock name="serviceFactory" type="exclusive" timeout="10"> > <cfscript> > // Get a handle on datasources structure > objFactory = CreateObject("java", > "coldfusion.server.ServiceFactory"); > objService = objFactory.getDataSourceService(); > dsources = objService.getDatasources(); > > // Get a copy of the generic ds, configure, add to > datasources > local_ds = Duplicate(dsources['sample_ds']); > local_ds.name = "#cf_ds_name#"; > local_ds.url = Replace(ds_copy.url,"sample_ds",cf_ds_name); > local_ds.urlmap.datasource = "#odbc_ds_name#"; > local_ds.urlmap.connectionprops.datasource = > "#cf_ds_name#"; > local_ds.valid = "YES"; > > dsources["#cf_ds_name#"] = Duplicate(local_ds); > > objService.restart(); > > </cfscript> > </cflock> This looks correct to me. The ODBC DSN is a preexisting one or are you using cfregistry to create it on the fly as well? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
