jennifer_merritt
asked on
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.
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).
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.
ASKER
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' ?
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' ?
I think that means: "change your ...default home -> to the one that you just installed".
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.