System information

CONFIGURING AND ADMINISTERING COLDFUSION 9

Using the ColdFusion Administrator

Last updated 2/21/2012

// Login is always required. This example uses two lines of code.

adminObj = createObject("component","cfide.adminapi.administrator");

adminObj.login("admin");

// Instantiate the data source object.

myObj = createObject("component","cfide.adminapi.datasource");

// Create a DSN.

myObj.setMSSQL(driver="MSSQLServer",

name="northwind_MSSQL",

host = "xx.x.xxx.xx",

port = "1433",

database = "northwind",

username = "sa",

login_timeout = "29",

timeout = "23",

interval = 6,

buffer = "64000",

blob_buffer = "64000",

setStringParameterAsUnicode = "false",

description = "Northwind SQL Server",

pooling = true,

maxpooledstatements = 999,

enableMaxConnections = "true",

maxConnections = "299",

disable_clob = true,

disable_blob = true,

disable = false,

storedProc = true,

alter = false,

grant = true,

select = true,

update = true,

create = true,

delete = true,

drop = false,

revoke = false );

</cfscript>

The following example adds the same SQL Server data source, but uses the argumentCollection attribute to pass all

method arguments in a structure: