Skip to main content
Known Participant
October 7, 2010
Question

hi, how to add datasource or dsn in coldfusion 9?

  • October 7, 2010
  • 2 replies
  • 2656 views

I was using  a coldfusion 8 a year ago. But I use a coldfusion 9 now. I get an error when I create a new database.

what is used instead  the underlying code? changed, think it might be  for adobe purchased Coldfusion

request.sqlexecutive.datasource[..]=...

class = "macromedia.jdbc.MacromediaDriver";

jdbc:macromedia:sqlserver://#urlmap.host#:#urlmap.port#;databaseName=#attributes.db#;SelectMethod=#urlmap.selectMethod#;sendStringParametersAsUnicode=#urlmap.sendStringParametersAsUnicode#";

An example: what I need to use instead macromediaDriver? Adobe did?

    This topic has been closed for replies.

    2 replies

    AdamPresley
    Participating Frequently
    October 7, 2010

    Read this link, posed by Joshua. http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html

    There is sample code there. Read it.

    tclaremont
    Inspiring
    October 7, 2010

    Do you have access to the ColdFusion administrator control panel, or is this a hosted site where that is not possible?

    Participating Frequently
    October 7, 2010

    The functions you were using before were undocumented, and I think in the latest updater for CF9 blocked as it provided a security hole.

    The CF administrator has an API now.  See the examples in this documentation.  http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html