create new coldfusion datasources using CFML

[A3gis]

Hi,
I am trying to find a way with Coldfusion MX 6.1 to create a datasource
programmatically via CFML. I think it may've worked under older versions by
just adding the DSN on the server's ODBC panel, but that doesnt register with
CFAdmin anymore and therefore becomes unusable to a CF site (thanks to lack of
connectionstring in cfquery now).

I am therefore wondering if anyone has a way to do this? we have a system that
periodically archives off a portion of it's database to a new database with a
date-based name, and it would be nice if the scripts that do this could also
build the datasource for us, thus making the process 100% automated.

Regards,
Lars

[MikerRoo]

You could upgrade to MX 7 and then use the Admin API for this :D

Or check out the service factory for 6.1.

Good cf.Factory intro is at:
[url]http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=10[/url]

[A3gis]

Champion, that's the ticket :)
Cheers!