For the past 5 years I been using DSN connections to connect to Oracle in my Cold Fusion. Is there any other way to connect in Cold Fusion MX 7 without using DSN?


<CFQUERY NAME="query_name" DATASOURCE="db_name">

SQL statements

</CFQUERY>


Maybe instead of System admins creating DSN, I can create the DSN in a Cold Fusion template?

Please advise.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.