I am having hard time figuring what's wrong with Crystal Reports for Enterprise. I have created a unx universe using Information Design Tool and publiched it to the repository. When I try to create a report using Crystal Reports for Enterprise, I am getting the following error
 <com.businessobjects.dsl.commons.exception.NestedException: ORA-12154: TNS:could not resolve the connect identifier specified
Cause of Error
ORA-12154: TNS:could not resolve the connect identifier specified
I tested the connection in IDT and it is working fine. I was able to create a Webi report on the universe and it is working fine. I am not able to figure why it is giving an error when I try to create a report by using Crystal Reports for Enterprise. I checked for TNS names on my machine and on the server. They are all correct.
The following is the deployment information.
Server: Windows Server 2008 R2 (64 bit, 8GB ram)
BOBJ Version: 4.0 SP6
Database: Oracle 11g (64 bit)