User Guide

ManualsBrandsMacromedia ManualsOtherCOLFUSION MX 7

Table Of Contents

Administrator API 41

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:

// Login is always required. This example uses a single line of code.

createObject("component","cfide.adminapi.administrator").login("admin");

// Instantiate the data source object.

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

// Required arguments for a data source.

stDSN = structNew();

stDSN.driver = "MSSQLServer";

stDSN.name="northwind_MSSQL";

stDSN.host = "10.1.147.73";

stDSN.port = "1433";

stDSN.database = "northwind";

stDSN.username = "sa";

// Optional and advanced arguments.

stDSN.login_timeout = "29";

stDSN.timeout = "23";

stDSN.interval = 6;

stDSN.buffer = "64000";

stDSN.blob_buffer = "64000";

stDSN.setStringParameterAsUnicode = "false";

stDSN.description = "Northwind SQL Server";

stDSN.pooling = true;

stDSN.maxpooledstatements = 999;

stDSN.enableMaxConnections = "true";

stDSN.maxConnections = "299";

stDSN.enable_clob = true;

stDSN.enable_blob = true;

stDSN.disable = false;

stDSN.storedProc = true;

stDSN.alter = false;

stDSN.grant = true;

stDSN.select = true;

stDSN.update = true;

stDSN.create = true;

stDSN.delete = true;

stDSN.drop = false;

stDSN.revoke = false;