Everything you need is in the Admin API. Specifically... the datasource.cfc
Here is a quick snippet for creating a SQL Server CF dsn.
<cfscript>
adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login(arguments.cfadminpassword);
dbObj = createObject("component","cfide.adminapi.datasource");
// Create the DSN
dbObj.setMSSQL ( name = arguments.newDataSourceName
, host = arguments.databaseServer
, database = arguments.newDataSourceDB
, port = arguments.newDataSourcePort
, username = arguments.newDataSourceUsername
, password = arguments.newDataSourcePassword
, selectmethod = "direct"
, disable = false
, disable_clob = false
, disable_blob = false
, sendStringParametersAsUnicode = true
);
</cfscript>
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-----Original Message-----
From: Matthew Friedman [mailto:[email protected]]
Sent: Monday, May 09, 2011 11:17 AM
To: cf-talk
Subject: Scripting of adding a Database - CF8
Does anyone now of a library - tag or tutorial on how to script the process
of adding a database to CF8.
I am looking to streamline a process of on boarding new clients with out
having to go into cfadmin site for each.
Thanks in advance.
Matt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344363
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
