Hey there, was wondering if there's any way to create DSNs via a template, WITHOUT enabling RDS.

Yer aware you can just set them up in Application.cfc, yeah?

I am not! I'll check for some examples. But can a template be built that's not specific to an application?

I don't understand what you mean by "template"? You mean... like some code in a file?

Right. I apologize, not an expert. But I had a template that used the Admin API to create DSNs independently, if that makes sense. We've upgraded to CF 21 and it no longer works, because I believe RDS needs to be enabled. Which we don't want to do. So wondering if there's another way to do it.

OK cool I'm with ya. "template" is a bit of an old-skooly term for "a .cfm file with some code in it". Wasn't too sure that was what you meant. Trying to find you some good examples for setting 'em in Application.cfc... wherever the code needs to go, the data structure will be the same.

I mean, that IS what I meant - a CF page that can create DSNs independently. Is there a better way to refer to that than template?

So do you have like a mult-tenanted application or something, so lots of application roots (and accordingly lots of Application.cfcs) and want them... all... to have the same set of DSNs?

So as part of my process, I just run a page that allows me to create DSNs, completely independent of anything else.

gotcha

Obviously the DSN won't verify at that point, but I'm not concerned with that.

In your situation I'd perhaps have one Datasources.cfc, and in that have a method that is

getDatasourceConfig

. And that returns the struct that an Application.cfc needs to create its DSNs on the fly. And you just reuse that Datasources.cfc. Does that make sense?

And if this needed to be a cfc file, or if it was just best practice that it was, that's fine. I think we mostly use cfms, but it's a mix.

So like in yer Application.cfc you have something along the lines of

component {
    this.datasources = Datasources::getDataSourceConfig()
}

(Static method there, but you could also go `new Datasources().getDataSourceConfig()

Is there a way to create it in the administrator without RDS, or is that not even really necessary?

Really these days you don't want to create them in admin.

So your suggestion would be to create them on a per-application basis, within application.cfc?

Indeed you might wanna look @ cfconfig. Makes all this stuff really easy and transparent. I'm not an expert in using it though (ping @bdw429s)

Okay, let me see if I can find a good example of that. I appreciate the guidance.

I can't find a good reference for "these are the settings you need for different kinds of DSNs". However this is this stackoverflow Q&A: https://stackoverflow.com/questions/16588539/create-datasource-in-application-cfc

Okay. And I was actually looking at that first link earlier. I'll investigate further, since that seems to be the way to go. Thank you.

NP fella.