DataSource

[iccsi]

I can use Application.Datasource to assign a datasource for the application.

I would like to know the web site can only has one datasource.

If my web site has more than one database on the different database server then am I able to assign the second datasource for the application or I need to assign every time if I have more than one datasource for the application,

Your help and information is great appreciated,

Regards,

Iccsi

[duncancumming · Accepted solution]

You can have multiple datasources in your application.  Create each one in your CF Admin > Datasources.  Then in onApplicationStart in your application.cfc, just create each one, e.g.

<cfset application.customerDSN = "Customer_Datasource">

<cfset application.supplierDSN = "Supplier_Datasource">

Which you can then refer to in your queries or stored procedures:

<cfstoredproc datasource="#application.supplierDSN#">

[iccsi]

Thanks a million for helping,

Regards,

Iccsi