Forums
Lawson Business Intelligence/Reporting/Crystal
Oracle ODBC Driver Configuration Error
Author
Messages
JonA
Veteran Member
Posts: 1162
5/12/2016 2:07 PM
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?
JonA
Veteran Member
Posts: 1162
5/12/2016 6: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.