Datasource Creation from Command line

[YelloMonke]

Hello,

We have plenty of data sources needed for our application and creating a sum of those with similar information takes some time. Is there any way to create them from the command line so I could maybe automate the creation process and make the process faster?

Thanks

[dave_cozens]

That probably depends on the database platform...

[YelloMonke]

We have MS SQL Server and we use MS JDBC driver to access it.

Thanks

[dave_cozens]

I've had a quick google and can't imemdiately find anything, but I'd be stunned if microsoft didn't have CLI to create datasources on a microsoft OS.

Failing that if you can create an authenticated CF user I'm certain that the admin interface to create datasources can be exposed as a CFC but I don't recall the details.

Also, I'm pretty sure that cfquery type="dynamic" may help, since it lets you specify a whole load of connectivity detail...

I'm being a bit vague, because I'm cooking right now. Google is your friend though...

[Stefan_K_]

Maybe this helps ....

Adding Datasources without CFAdmin:
http://www.creative-restraint.co.uk/blog/index.cfm?mode=entry&entry=7B83C13D-EEF8-5BAE-8195007923F93...

[YelloMonke]

Stefan,

That almost does it. I also found this one:
http://infinitewebdesign.com/journal/designers/archives/2006/01/03/dynamic-datasources-in-coldfusion...
Which explains how to create a JDBC datasource

Somehow I am getting an error message stating " Current user is not authorized to invoke this method"
I logged in as admin and not sure why I am getting this message, any ideas?

[YelloMonke]

Please ignore my last message, turns out that adminapi.login wasn't being called properly, the question now is how I could create datasources for 2 other CF instances, any ideas?

[YelloMonke]

I posted a new topic for this Question here:

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=7&threadid=1210437&ente...