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.