make Oracle 10g compatible with 81

25 pts.
Tags:
Oracle 10g
Oracle 10g administration
Oracle 8.1.4
Oracle Compatibility
 Can Oracle 10g be made compatible with 8.1?  I've installed 10g then 8.1.  When I try to connect to an 8.1 database, i get the error:

"[MERANT][ODBC Oracle 8 driver]Driver's SQLSetConnectAttr failed.[MERANT][ODBC Oracle 8 driver]Optional feature not implemented.{MERANT][ODBC Oracle driver][Oracle 8]ORA-12154: tns:could not resolve the connect identirier specified"

 

Thanks!



Software/Hardware used:
Oracle - P6 and RMS

Answer Wiki

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

Discuss This Question: 4  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
  • carlosdl
    Providing more details could help the community understand the situation. "I've installed 10g then 8.1" Are you referring to the server or the client software ? What is the operating system ? Do you really need to have the 2 versions installed ? "When I try to connect to an 8.1 database" Where are you trying to connect from ? an application ? If so, what language ? Can you connect from an Oracle application such as SQL*Plus ?
    69,835 pointsBadges:
    report
  • Rweilandusace
    I'm on the client side. I've asked our support group if I can run 10g, but I suspect I'll have to use 8.1. I think P6 requires 10g. I'm new at this, so I don't know the answers to the rest of your questions with certainty.
    25 pointsBadges:
    report
  • Rweilandusace
    I'm Running Access to connect.
    25 pointsBadges:
    report
  • carlosdl
    "I’ve asked our support group if I can run 10g" What did they answer ? The existence of two different versions of the client software is probably causing the error. What is "P6" ? Whatever it is, if it requires Oracle 10g, that requirement most likely refers to the database version, not the client software.
    69,835 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