Skip to main content
Known Participant
January 29, 2008
Question

Connect to Database

  • January 29, 2008
  • 1 reply
  • 387 views
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.
    This topic has been closed for replies.

    1 reply

    Inspiring
    January 29, 2008
    iirc, dynamic dsn has been removed from CF.
    you must create a cf dsn using cf administrator, or the admin API.

    ---
    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com
    FloridaAuthor
    Known Participant
    January 29, 2008
    you must create a cf dsn using cf administrator, or the admin API.


    cf administrator one way we do it. What is admin API?