PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/12/2016 2:28 PM by  JonA
Oracle ODBC Driver Configuration Error
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
JonA
Private
Private
Veteran Member
(2766 points)
Veteran Member
Posts:972


Send Message:

--
05/12/2016 10:07 AM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    05/12/2016 2:28 PM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.