RE: Scripting of adding a Database - CF8

2011-05-09 Thread Bobby Hartsfield
Everything you need is in the Admin API. Specifically... the datasource.cfc Here is a quick snippet for creating a SQL Server CF dsn. adminObj = createObject("component","cfide.adminapi.administrator"); adminObj.login(arguments.cfadminpassword); dbObj = createO

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Gerald Guido
Here it is My bad... http://cfmladminapi.riaforge.org/ HTH G! On Mon, May 9, 2011 at 11:47 AM, Gerald Guido wrote: > >>Have you looked into the CFAdmin API? You can do all this from code > using this API. > > + 1. > > I have to code to do that sitting around here some where. Not producti

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Russ Michaels
On Mon, May 9, 2011 at 4:47 PM, Gerald Guido wrote: > > >>Have you looked into the CFAdmin API? You can do all this from code > using > this API. > > + 1. > > I have to code to do that sitting around here some where. Not production > ready but it would give you a start in the right direction. >

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Gerald Guido
>>Have you looked into the CFAdmin API? You can do all this from code using this API. + 1. I have to code to do that sitting around here some where. Not production ready but it would give you a start in the right direction. G! On Mon, May 9, 2011 at 11:26 AM, Wil Genovese wrote: > > Have y

Re: Scripting of adding a Database - CF8

2011-05-09 Thread John M Bliss
Add database (SQL Server): SEE: http://msdn.microsoft.com/en-us/library/ms176061.aspx CREATE DATABASE [mydatabasename] Add datasource: SEE: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html On Mon, May 9, 2011 at 10:16 AM, Matthew Friedman wrote:

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Wil Genovese
Have you looked into the CFAdmin API? You can do all this from code using this API. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 9, 2011, at 10:16 AM, Matthew Friedman wrote: > > Does anyone no