Help with setting up DSN without CF Admin

[Ofeargall]

Is it possible to set up a DSN without access to the CF Administration panel? Can I write this into a .cfc or is there some code I can run in a .cfm that will achieve this for me? I'm having trouble getting my host to set up the DSN I'm using and would like to know if there is any other way to achieve this.

I have all my DSN parameters (I{ address, username, Passw, etc...), and it's working just fine on my local version of the site but I set it up through Administration.

Thanks in advance.

[ilssac · Accepted solution]

Nothing that doesn't requre support from your ISP.

There is an administrator API that you can progamatically add DSN and other Administrator settings.  But this API would need to be opened to you by your ISP and they maybe unwilling to do so.  But it never hurts to ask.

[Ofeargall]

So, can I connect to my DB with a DSN-less connection in CF8?

[ilssac]

I'm afraid not, that feature has been deprecated.

[Ofeargall]

Rats.