Mike's Notes
Google Search - AI Mode (Gemini) was used to find the sample code for adding a data source using the ColdFusion Administrator API.
Speed is king
My strength is architecture and problem-solving, not coding (slow writer and too many typos), so 99.9% of the coding is now supplied via Google Search - AI Mode (Gemini). Then I test everything. About 100X faster. 😎😎😎😎😎😎😎
Data sources
data/
- couchbase/
- db2/
- derby/
- h2/
- hsqldb/
- mariadb/
- msaccess/
- 32/ (32-bit)
- 64/ (64-bit)
- mssql/
- oracle/
- pg/
- 18/ (version 18)
- sqllite/
- sybase/
- virtuoso/
Other issues to explore later
- The advanced arguments (such as connection pool limits or timeout settings) for these specific drivers.
Future testing
- Install loki-01 on 9cc/
- Run the Data Engine (dat) to create all data sources
- Test data sources.
Here is a detailed example copied from the ColdFusion Cookbook. It is written by Jeremy Petersen and was last updated in 2007.
How do I programmatically create a new datasource?
The short answer is to use the ColdFusion Administrator API.
The following is taken directly from the ColdFusion documentation:
You can perform most ColdFusion MX Administrator tasks programmatically
using the Administrator API. The Administrator API consists of a set of
ColdFusion components (CFCs) that contain methods you call to perform
Administrator tasks. For example, you use the setMSQL method of
datasource.cfc to add a SQL Server data source.
Resources
- https://www.blog.ajabbi.com/2026/04/cfml-64-bit-and-32-bit-datasource.html
- https://www.coldfusioncookbook.com/entries/How-do-I-programmatically-create-a-new-datasource.html
References
- Reference
Repository
- Home > Ajabbi Research > Library >
- Home > Handbook >
Last Updated
18/04/2026
Add a data source using Coldfusion Administrator API
Mike is the inventor and architect of Pipi and the founder of Ajabbi.
Google Gemini is cool.
The ColdFusion server stores data source configurations in specific XML files located within its installation directory. The exact location depends on your version and installation type (Server vs. J2EE configuration). [1, 2, 3, 4, 5]
Configuration File Locations
Most modern Adobe ColdFusion versions (including ColdFusion 2021 and 2025) store these settings in the following files:
- Main Datasource File: neo-datasource.xml.
- Legacy/Alternative File: neo-query.xml (often used in older versions like ColdFusion 7). [1, 2]
Default File Paths
The absolute path varies based on how ColdFusion was installed: [6]
- Server Configuration (Standard): {cf_root}/cfusion/lib/ (e.g., C:\ColdFusion2021\cfusion\lib\neo-datasource.xml on Windows).
- JEE / Multiserver Configuration: {cf_webapp_root}/WEB-INF/cfusion/lib/.
- Central Config Server (CCS): If using a [Central Config Server](https://helpx.adobe.com/coldfusion/using/central-config-server-coldfusion.html), settings are stored in <CF_Instance_Home>/bin/ccsstore/ and replicated across nodes. [1, 2, 3, 7]
Important Notes
- Encryption: While you can see the DSN names and server addresses in these XML files, passwords are encrypted and cannot be read in plain text.
- Editing: It is highly recommended to manage datasources through the ColdFusion Administrator (found under Data & Services > Data Sources) rather than editing the XML files directly to avoid corruption.
- API Access: You can also manage these settings programmatically using the [ColdFusion Administrator API](https://helpx.adobe.com/coldfusion/kb/database-connections-handled-coldfusion.html). [1, 8, 9, 10, 11, 12]
References
- [1] [https://stackoverflow.com](https://stackoverflow.com/questions/10722821/location-of-coldfusion-connection-string-settings)
- [2] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/kb/purpose-location-xml-configuration-files.html)
- [3] [https://helpx.adobe.com](https://helpx.adobe.com/ph_fil/coldfusion/configuring-administering/data-source-management-for-coldfusion.html)
- [4] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/kb/purpose-location-xml-configuration-files.html)
- [5] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/installing/installing-the-server-configuration.html)
- [6] [https://www.bennadel.com](https://www.bennadel.com/blog/2358-parsing-traversing-and-mutating-html-with-coldfusion-and-jsoup.htm#:~:text=The%20path%20varies%20on%20your%20own%20CF,or%20if%20you%20went%20multi%2Dinstance%20or%20not.)
- [7] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/using/central-config-server-coldfusion.html)
- [8] [https://www.reddit.com](https://www.reddit.com/r/coldfusion/comments/167r5fg/where_to_start/)
- [9] [https://medium.com](https://medium.com/@cfmike/retrieve-coldfusion-datasource-passwords-4c1064b91548)
- [10] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/configuring-administering/data-source-management-for-coldfusion.html)
- [11] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/kb/create-datasource-coldfusion.html)
- [12] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/kb/database-connections-handled-coldfusion.html)
To use the ColdFusion Administrator API to add a datasource, you use a set of ColdFusion components (CFCs) located in the /CFIDE/adminapi/ directory. This allows you to manage server settings programmatically without using the web-based Administrator interface. [1, 2, 3, 4]
Prerequisites
- Enable RDS: Some versions or configurations may require enabling the RDS service in Security > RDS within the ColdFusion Administrator.
- Administrator Password: You must have the server's administrator password to authenticate. [1, 5, 6, 7]
Basic Steps and Example Code
The following cfscript example demonstrates how to log in and create a Microsoft SQL Server datasource using the datasource.cfc (or Data Sources.cfc in some versions). [5, 8]
// 1. Authenticate with the Administrator API
adminObj = createObject("component", "cfide.adminapi.administrator");
adminObj.login("yourAdminPassword"); // Replace with your actual admin password
// 2. Instantiate the Data Source object
// Note: Use "datasource" or "Data Sources" depending on your CF version
dsObj = createObject("component", "cfide.adminapi.datasource");
// 3. Define the datasource details
// For SQL Server, you use the setMSSQL method
dsObj.setMSSQL(
name = "MyNewDSN",
host = "127.0.0.1",
port = "1433",
database = "MyDatabaseName",
username = "dbUser",
password = "dbPassword",
description = "Datasource created via Admin API"
);
// 4. (Optional) Verify the connection
isVerified = dsObj.verifyDsn("MyNewDSN");
if (isVerified) {
writeOutput("Datasource successfully created and verified!");
} else {
writeOutput("Datasource created but failed verification.");
}
</cfscript>
Common Methods for Different Drivers
The datasource component provides specific methods for different database types: [4, 9, 10]
- SQL Server: setMSSQL()
- MySQL: setMySQL5() or setMySQL()
- [Oracle](https://www.oracle.com/): setOracle()
- Derby: setDerbyEmbedded()
- Other JDBC: setOther() (used for custom or thin drivers) [4, 5, 6, 8, 11, 12, 13]
Alternative: Per-Application Datasources [14]
In ColdFusion 2021 and later, you can also define datasources directly in your Application.cfc without using the Admin API. This is often preferred for modern application deployment as it keeps configurations within the application code. [14, 15, 16, 17, 18]
component {
this.name = "MyApplication";
this.datasources["myDSN"] = {
driver: "MSSQLServer",
host: "localhost",
database: "mydb",
username: "user",
password: "pass"
};
this.datasource = "myDSN";
}
References
- [1] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/kb/create-datasource-coldfusion.html)
- [2] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/configuring-administering/coldfusion-administrator-api-reference.html)
- [3] [https://helpx.adobe.com](https://helpx.adobe.com/coldfusion/kb/create-datasource-coldfusion.html)
- [4] [https://www.coldfusioncookbook.com](https://www.coldfusioncookbook.com/entries/How-do-I-programmatically-create-a-new-datasource.html)
- [5] [https://coldfusion.adobe.com](https://coldfusion.adobe.com/2016/10/configuring-data-sources-using-admin-api-in-coldfusion/)
- [6] [https://coldfusion.adobe.com](https://coldfusion.adobe.com/2016/10/configuring-data-sources-using-admin-api-in-coldfusion/)
- [7] [https://www.youtube.com](https://www.youtube.com/watch?v=3WR6WL3uN3U&t=2)
- [8] [https://www.coldfusioncookbook.com](https://www.coldfusioncookbook.com/entries/How-do-I-programmatically-create-a-new-datasource.html)
- [9] [https://www.coldfusioncookbook.com](https://www.coldfusioncookbook.com/entries/How-do-I-programmatically-create-a-new-datasource.html)
- [10] [https://querytool.com](https://querytool.com/help/configuring-a-database-connection#:~:text=The%20way%20you%20configure%20an%20ODBC%20Datasource,general%20comments%20about%20how%20this%20is%20done.)
- [11] [https://coldfusioncentral.com](https://coldfusioncentral.com/coldfusion-datasource-templates/)
- [12] [https://www.petefreitag.com](https://www.petefreitag.com/blog/creating-derby-datasource/)
- [13] [https://www.petefreitag.com](https://www.petefreitag.com/blog/creating-derby-datasource/)
- [14] [https://www.cfguide.io](https://www.cfguide.io/coldfusion-administrator/data-services-data-sources)
- [15] [https://www.bennadel.com](https://www.bennadel.com/blog/4220-moving-mysql-to-a-per-application-datasource-in-coldfusion-2021.htm)
- [16] [https://stackoverflow.com](https://stackoverflow.com/questions/79324143/coldfusion-datasource-could-not-be-found)
- [17] [https://coldfusion.adobe.com](https://coldfusion.adobe.com/2022/03/the-struct-keys-in-this-datasources/)
- [18] [https://learncfinaweek.com](https://learncfinaweek.com/course/index/section/Security/item/Session_Identifier_Protection.html#:~:text=ColdFusion%2010%20added%20several%20new%20configuration%20items,by%20applying%20the%20settings%20in%20Application.%20cfc.)
To use the ColdFusion Administrator API with tag-based syntax, you must first authenticate using administrator.cfc, then call the specific driver methods in datasource.cfc.
1. Authentication (Required First)
Before adding any datasource, you must log in to the API session. [1]
<cfset adminObj.login("yourAdminPassword")>
<!--- Instantiate the datasource object for subsequent calls --->
<cfset dsObj = createObject("component", "cfide.adminapi.datasource")>
------------------------------
2. Database-Specific Tag Examples
Microsoft SQL Server
Uses the setMSSQL method.
name = "MyMSSQL_DSN",
host = "127.0.0.1",
database = "Northwind",
username = "db_user",
password = "db_password"
)>
PostgreSQL
Uses the setPostgreSQL method.
name = "MyPostgres_DSN",
host = "localhost",
database = "sales_db",
username = "postgres",
password = "password"
)>
MySQL
Uses setMySQL5 (for MySQL 5.x and later, including MariaDB).
name = "MyMySQL_DSN",
host = "://example.com",
database = "inventory",
username = "admin",
password = "secretpassword"
)>
Oracle
Uses setOracle. Note that Standard edition users often use the "Other" method with an Oracle thin driver.
name = "MyOracle_DSN",
host = "oracle_server",
service_name = "ORCL",
username = "system",
password = "password"
)>
MS Access (32-bit vs. 64-bit)
Both use the setMSAccess method, but the behaviour depends on the server's ODBC configuration and the ColdFusion bitness.
- 32-bit: Requires the 32-bit Microsoft Access Database Engine.
- 64-bit: Requires the 64-bit Microsoft Access Database Engine.
name = "MyAccessDSN",
database = "C:\data\mydb.mdb"
)>
Sybase
Uses the setSybase method.
name = "MySybase_DSN",
host = "sybase_host",
database = "production",
username = "sa",
password = "password"
)>
DB2
Uses the setDB2 method.
name = "MyDB2_DSN",
host = "db2_server",
database = "SAMPLE",
username = "db2admin",
password = "password"
)>
------------------------------
3. Verification (Recommended)
After adding a datasource, it is best practice to verify the connection immediately.
<cfif isVerified>
<p>Connection Successful!</p>
<cfelse>
<p>Connection Failed. Check credentials or server availability.</p>
</cfif>
References
- [1] [https://www.coldfusioncookbook.com](https://www.coldfusioncookbook.com/entries/How-do-I-programmatically-create-a-new-datasource.html)
.jpg)
