Regarding Oracle connectivity issues

pts.
Tags:
Database
DB2
Oracle
SQL
Windows
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB object of VB, which Oracle will it try connecting to?? Does it use the tnsnames.ora corresponding to Oracle version selected in the Home Selector? The Problem i am facing is that it always tries to connect to Oracle 7i though i have selected the Oracle 9i in the Home Selector. Kindly advice.

Answer Wiki

Thanks. We'll let you know when a new response is added.

So I am assuming you have 2 tnsnames, one in each Oracle_Home directory. Have you tried just opening a sqlplus connection and see if you could connect to the Oracle9i db. I would also try opening sqlplus from the Start->Run so as to also see which one it brings up…the 7 or 9 version.

I have a feeling this has something to do with which Oracle home it is using. Hope this helps, if not, let me know what you found from the suggestions above.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Randym
    Check in the registry (HKEY_LOCAL_MACHINESOFTWAREORACLE) for a Local paramter. If you don't have to specify the host in SQLPlus, then you likely do and it is set to the name you have set up in your tnsnames file for your 7i database. Also, if you are using VB6, are you using ODBC to connect? If so, it is likly trying to use the tnsnames file in your C:orant path and not from the network folder of the c:ora9 path (I think this may depend on the order you have it set up in your PATH environment variable).
    1,740 pointsBadges:
    report
  • Vabene
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/regarding-oracle-connectivity-issues/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following