Database access without using CF admin

[DesignersRepublics]

Hi,

I'm using Coldfusion MX 7 and I've built a web app that actually creates an
user profile, then creates a mySQL database in c:\mysql\data as well as a table
in the newly created database. I need to automate the whole process and I would
like to be able to connect to my new database without using the Coldfusion
admin tool. I've read a lot of things on the net and they only work with
earlier releases of Coldfusion.

Is there a way to connect directly, or maybe modify a configuration file in
order to automatically set up this database connection?

Thanks for all your help

FJ

[dphillipsCFX]

Can you tell us what you have already looked at? This is possible to do since
most hosting companies have something like this setup for their customers.
Everyone has their own method though.

Dan Phillips
[email]dphillips@cfxhosting.com[/email]
CFXHosting.com
a division of Hosting.com

[DesignersRepublics]

Hi,

Actually I've read an article about a method which is deprecated in CF MX7,
like <cfquery connectstring="..." which doesn't work anymore...

I think there should be a way to update the neo-query.xml file that contains
the datasource definitions. Problem: the structure is really heavy.

Other ideas?

thanks,

Fred

[JRock]

I don't know if this would help, but I saw this DSN Less tutorial for MySQL and CF
[url]http://tutorial402.easycfm.com/[/url]

[ksmith]

CFMX7 allows you to programatically do any administrator function. You could
create a new DSN that way, when you add the new database and table. Take a
look in the CFMX7 Administrator's Guide for information on the adminAPI. There
are also articles and whitepapers showing examples.

HTH.

[DesignersRepublics]

Thanks for the help, it's greatly appreciated...