Oracle ODBC Driver Configuration Error

Sort:
You are not authorized to post a reply.
Author
Messages
JonA
Veteran Member
Posts: 1162
Veteran Member
    I'm trying to set up my my ODBC connection for Crystal on a new pc (Windows 7, Oracle version 12.1.0) but I'm getting this error:

    Testing Connection
    SQLState=08004
    [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

    When I compare the ODBC driver config and tnsnames.ora file to my current pc (Windows XP, Oracle version 11g) they look identical. And my connection test is successful on this pc.

    Any ideas?
    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
      Problem solved! It was my user security settings in Windows 7. Our DBA didn't give me the details but if anyone else runs into a similar issue I can ask.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      You are not authorized to post a reply.