Skip to main content
A
Anonymous
January 6, 2012
Question

Use of Macromedia JDBC Drivers is restricted

  • January 6, 2012
  • 1 reply
  • 2530 views

We are building a new CF9 server. We installed the developer version and things appeared to work OK. When we set our single-server license (single server, not Enterprise) we get this message when trying some of our queries against a SQL Server database (did not try against Oracle, we only use SQL Server for this application).

Error Executing Database Query.

Use of Macromedia JDBC Drivers is restricted. Drivers can only be used with Macromedia server products. Please check that your license supports the requested driver.

One of the other threads here indicates that JDBC drivers are only enabled for the Enterprise version. Another thread however seems to indicate that we would need to reinstall and make sure that the correct drivers were selected during the install process. This part *did* work during the developer period (which I believe enables all Enterprise features).

Can standard version support JDBC? If not, can we use something else than JDBC? We don't want Enterprise.

    This topic has been closed for replies.

    1 reply

    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    January 6, 2012

    First, yes, CF Standard supports JDBC. All CF database connections, regardless of version or license, use JDBC. The difference between Standard and Enterprise with regard to JDBC drivers is limited to the bundled Oracle driver included with Enterprise, Developer and Trial - this is not available for Standard.

    Second, there's no relevant option for which JDBC drivers you get during the install process, regardless of version. There is an option for the JDBC-ODBC bridge, SequeLink, but that's not relevant to this.

    Now, to fix your problem. First, make absolutely sure you're not using the Oracle driver! I know you said you're not, but better safe than sorry.

    After that, the easiest approach would probably be to just completely uninstall CF and reinstall it with the correct license - at least, that would be the quickest without doing additional digging. However, I'm sure with a bit of tinkering you can fix your problem without uninstalling - I'm just not sure on the direction and amount of time that tinkering would take.

    Alternatively, you could open a support ticket with Adobe, although honestly it would probably take you less time to just uninstall and reinstall CF.

    Dave Watts, CTO, Fig Leaf Software

    Dave Watts, Eidolon LLC
    A
    Anonymous
    January 6, 2012

    Oops - I was wrong about the database usage.

    I looked under the Cold Fusion Administrator > Data Services > Data Sources:

         We have one SQL Server

         We also need to access 3 Oracle databases from this instance.

         Plus 4 Apache Derby Embedded with names that look like they are example built-in databases for the CF instal.

    Is there a way we can do that (e.g., a different driver) that doesn't require the Enterprise version? Perhaps ODBC Socket? I don't see anything oracle-ish under the Driver options in "Add New Data Source"

    Thanks.

    A
    Adam Cameron.
    Inspiring
    January 6, 2012

    Just grab some other Oracle JDBC driver from somewhere.  Maybe one of these ones: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.

    --

    Adam

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices