Unable to connect to Oracle database

[Dano]

I just d/l'ed Query Reporter today but am unable to connect to my company's Oracle database. What should I enter in the "Database" field in the connection popup. I am able to successfully connect using Oracle's SQL Developer and Instant Client.

Thanks in Advance
D. Scates

 

[Marco Kalter]

If you are using the Oracle Instant Client, then you must set the PATH environment variable to include the instant client directory, as well as the TNS_ADMIN environment variable.

 

[jbullock]

I am similarly unable to reach a remote Oracle database configured as a service, when through SQL Developer I can. I have a valid tsnames.ora with both the PATH set to the InstantClient directory, and TNS_ADMIN pointing to the location for tsnames.ora (SQL Developer picks up the service information from tsnames.ora successfully, and did not before TNS_ADMIN had the correct value.)

I *am* having exactly the same access problem with another Eclipse-based client tool.

Glad to assist with diagnostics. Looking for guidance on what to go after.

Thanks,

jbullock

 

[Marco Kalter]

What exactly goes wrong? Any error messages?