Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 55
	Members: 0
	Total: 55

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Oracle ODBC Driver Configuration Error

1 Replies

0 Subscribed to this topic

24 Subscribed to this forum

Sort:

Author

Messages

JonA

Veteran Member

Posts: 1163

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: 1163

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.