Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CE 10 Affecting TNS Listener on Oracle 8

Status
Not open for further replies.

IanWaterman

Programmer
Jun 26, 2002
3,511
GB
CE & CR 10 on XP Pro

Installed CR10 last week and could run reports against an Oracle 8 database no problem.

Simply for training purposes I installed CE10 on same machine. Now whenever I try to connect to Oracle I get the error TNS No Listener. I get the same problem with Toad (an Oracle SQL analyser tool)

I have tested the listener at the command prompt and all is OK. I have even tried creating an ODBC Oracle connection this all connects without any problems.

When I try to use the ODBC connection within Crystal I get the same TNS listener error.

Any suggestions as to what the installation of CE10 has done to my TNS listener, or more specifically why Crystal Reports/Toad can nolonger find it?

Thank you

Ian
PS Also posted on Crystal Enterprise Forum
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top