Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2011
  • Last Modified:

ORACLE ODBC Instant Client 10 - trouble adding new connection

I have installed Oracle Instant Client 10 so I can create a new ODBC connection to a 10G server (currently using Oracle 9 ODBC drivers for other apps).  I am in ODBC Data Source Administrator > System DNS > clicking add...I select my new Oracle 10 Instant Client Driver, click finish.  The problem is: I am not able to select a TNS name from the drop down box.  If I click the drop down box there are 4 options that look like greek characters.  I should have my prod,test environments like I do for the Oracle 9 ODBC connection.  I changed my system variables to include the path where my Instant Client 10 was installed (which has a copy of tnsnames.ora file).  This fixed some errors I was having before this one but I still cannot select my prod environment with this new driver.
0
jennifer_merritt
Asked:
jennifer_merritt
  • 3
  • 2
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
I have not done much with the "Instant Client" (that is new with Oracle10).  I have set up some machines with the Oracle10 client that needed an ODBC connection to an Oracle10 database, but I just installed the full "Administrator" client even though I know that includes more than the minimum needed.  When I tried installing less than that though, I couldn't get the Oracle ODBC client to work.  We don't depend on ODBC for most of our work, this was just for a couple peripheral applications, so I'm not really an expert with ODB via an Oracle client (any version).
0
 
ram_0218Commented:
change your registry and change your local computer -> all_homes -> default home -> to the one that you just installed and run the odbc admin again.
0
 
jennifer_merrittAuthor Commented:
Ram 0218:

I still want to be able to use my old Oracle 9.0 ODBC connections is there a way I can use both 9 and 10? Also, what do you mean by 'change your local computer' ?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Mark GeerlingsDatabase AdministratorCommented:
I think that means: "change your ...default home -> to the one that you just installed".
0
 
jennifer_merrittAuthor Commented:
Tried changing the default home settings in the registry - had no effect.  Any other ideas how to get two different Oracle ODBC version drivers to work?
0
 
Mark GeerlingsDatabase AdministratorCommented:
Before you can use an Oracle10 ODBC driver you need to configure the tnsnames.ora file in the Oracle10 Oracle_home for your databases.  This does not happen automatically or by default.  One option would be to save a copy of the tnsnames.ora file from the new Oracle10 Oracle_home\network\admin directory somewhere else (or rename it) then copy the tnsnames.ora file from your Oracle9 Oracle_home\network\admin directory to this one.  The other option is to use Oracle's GUI wizard in for Oracle10 for configuring SQL*Net and set up the four databases that you want to connect to.  After either of these are done, you should be able to use the Oracle10 Oracle_home.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now