View source for Application-Specific Datasources

__FORCETOC__
Railo 4.1 and ColdFusion 11 added the ability to create Application-specific datasources (DSNs) within an Application.cfc file, bypassing the need to register the DSN on the server. The information below shows how you can get started using this new feature in either CFML engine.

==Railo 4.1+ Application-Specific Datasources==
The easiest way to get started is to have Railo's Web Administrator create the connection string for you. To do this, first create the DSN within your Railo Web Administrator and scroll to the bottom. You'll see the code to insert into your Application.cfc at the bottom of the page.<br>[[File:Rail-dsn-conn-string.png]]<br><br>
After copying the code into your Application.cfc, you can remove the DSN from your Railo Web Administrator, and your site will still be able to use the datasource.

More information and examples of how to use this feature are available here: [http://blog.getrailo.com/post.cfm/railo-4-1-explicit-datasources-in-application-cfc Railo Blog - Railo 4.1: Explicit Datasources in Application.cfc]

==ColdFusion 11+ Application-Specific Datasources==
In ColdFusion 11 application-specific datasources are defined by manually creating a connection string that includes the driver, host, databse, username, password, and any connection options needed. For example, you could add code like this to your Application.cfc to create a MySQL datasource:
<syntaxhighlight lang="cfm">
this.datasources.dsn1={"database"="regression","host"="mysqlserver.hostek.com", "driver"="MySQL5", "username"="mysqluser", "password"="ChangeTh1s!"};
</syntaxhighlight>

More info can be found in the '''Enhancements made in ColdFusion 11'' section of this wiki: [https://wikidocs.adobe.com/wiki/display/coldfusionen/Application+variables ColdFusion Application Variables]

The ColdFusion Blog also has some examples for your reference: [http://blogs.coldfusion.com/post.cfm/application-datasources-in-coldfusion Application datasources in ColdFusion]