Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 335
	Members: 0
	Total: 335

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

Oracle ODBC Driver Configuration Error

1 Replies

0 Subscribed to this topic

22 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.