This content has been marked as final. Show 7 replies
That probably depends on the database platform...
We have MS SQL Server and we use MS JDBC driver to access it.
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...
That almost does it. I also found this one:
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?
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?