Skip to main content
uncle_jessy
uncle_jessy
Participant
September 23, 2010
Question

JDBC driver, multiple oracle homes, tns issue

  • September 23, 2010
  • 2 replies
  • 1402 views

Environment:  Win 2003 Server 32 bit; Coldfusion 8; oracle db; IIS; Sequelink 5.4

I'm having a JDBC driver problem on 32bit.  I've  installed two oracle clients on the box, one 10g and recently an 11g.  With the  new 11g install, I've still wanted my datasources to all point to 10g  for now and I've changed the environment path to have the 10g path  first.  Everything is good except for my coldfusion data sources, they  will only now connect to 11g.  When verifying 10g data sources I get

[Macromedia][SequeLink  JDBC Driver][ODBC Socket][Oracle][ODBC][Ora]ORA-12154: TNS:could not  resolve the connect identifier specified

So I add a 10g service to the 11g tns names and the datasource connects just fine.  It's a work around but not a good one.  The main issue is that the JDBC driver seems to be pointing to my 11g tns for everything and that is the problem.

    This topic has been closed for replies.

    2 replies

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    September 23, 2010

    You mention Sequelink and your message refers to ODBC Socket.

    When you create this datasource in CF, are you using ODBCSocket as the DSN type? IS that because perhaps you're on CF Standard and don't have Oracle listed as a driver type option?

    In that case, you may want to consider getting an Oracle JDBC driver, then using the "Other" DSN type when creating a DSN in the CF Admin.

    There are various resources walking through how to do this:

    http://blog.razuna.com/2008/01/25/configure-the-jdbc-driver-for-oracle-on-coldfusion-8-standard-edition/

    http://kb2.adobe.com/cps/183/tn_18344.html (though see comment in above entry about a concern using the "thin" driver referred to in this technote)

    http://www.technicallychris.com/2006/09/04/configuring-oracle-for-coldfusion-mx-standard/ (this offers a useful follow up tip to the technote)

    Hope that helps.

    /charlie

    /Charlie (troubleshooter, carehart. org)
    uncle_jessy
    uncle_jessyAuthor
    Participant
    September 27, 2010

    Very helpful!  Thanks for the answer.


    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    September 27, 2010

    Glad to have helped. Thanks for the feedback. If you feel that it answers your question, note that there's a mechanism (in the web interface, at the link for the message shown below, if you're reading this by email) where you can mark the question as answered. That could help some folks viewing the message in the forum. Thanks.

    /Charlie (troubleshooter, carehart. org)
    Owainnorth
    Owainnorth
    Inspiring
    September 23, 2010

    Remotest of chances this'll work, but it's a trick I picked up installing the Oracle ODAC.

    Create the environmental variables ORACLE_HOME (if it doesn't already exist) pointing to the Oracle home directory and TNS_NAMES, which points to the directory containing the tns_names.ora you wish to use.

    Like I say probably won't work, but ODAC looks for %TNS_NAMES%\tns_names.ora, don't know if CF will try the same.

    O.

    uncle_jessy
    uncle_jessyAuthor
    Participant
    September 23, 2010

    Thanks but that isn't successful. I'm curious if I need to add the Oracle JDBC Driver for Data Direct and if so, how.

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