Re: How to create multiple datasources in applicat...

c__wright1 · ‎Dec 21, 2018

Thanks to everyone for their help. I hope you all have a Merry Christmas! The sample syntax was enough for me to resolve my issues. My final code: <cfscript> component { this.name = "DB1"; this.datasources = { DB1 = { database = "CUST", host = "CSVT000089EA.us.test.com\WWABC06", // port = "49503", driver = "MSSQLServer", username = "master_admin", password = "Password123" }, DB2 = { database = "INV", host = "CSVT000089EA.us.test.com\WWABCD06", // port = "49503", driver = "MSSQLServer", username = "user1", password = "Password456" } }; this.datasource = "DB1"; } </cfscript>

c__wright1 · ‎Dec 20, 2018

Sorry, I may have worded my question poorly. What I am looking to do is to create a variable for each database (on different database servers) that I can use in the stored procedure calls to the two databases. eg. <cfstoredproc procedure="CUS124.main.selectAlerts" datasource="Main_db1" returncode="yes"> <cfprocresult name ="alerts"> </cfstoredproc> <cfstoredproc procedure="SSQ56.dbo.selectStats" datasource="Main_db2" returncode="yes"> <cfprocresult name ="stats"> </cfstoredproc> My issue is that I am migrating from ColdFusion 10 where the DSNs were set in the ColdFusion administrator to ColdFusion 11 and need to create the DSNs in the application.cfc but I have not been able to figure out the syntax.

c__wright1 · ‎Dec 20, 2018

I am using ColdFusion 11 and having an issue creating data sources to more then one database. The application works when I have one data source in the application.cfc, but when I add a second data source the second one does not work and I receive an error "Datasource main_db2 could not be found". Can anyone provide me with sample code on how to set up two or more data sources using application.cfc ? Current code that works for one data source in application.cfc. // Application.cfc component { this.name = "DSNTest"; this.datasources = { main_db1 = { database = "CUS124", host = "C008945DE.us.int444.com\WWGRRD06", driver = "MSSQLServer", username = "abc123x", password = "password123" } }; this.datasource = "main_db1"; }

c__wright1

c__wright1

Activity

Re: How to create multiple datasources in applicat...

Re: How to create multiple datasources in applicat...

How to create multiple datasources in application....