We use Allround Automations' PSD for our Oracle work. It handles all the connection strings and the like for us, so I am not well versed in what we need to do to connect to the Oracle DB using a TNS file. I am on Win7 64bit machine. The following things are setup:
- I have an environment variable setup (TNS_ADMIN) that points to our tns file
- I have the oracle driver setup inside 0xDBE
- I have my TNS entry setup (it works for other tools that don't use JDBC)
Whenever I try to connect to the DB I get 'java.sql.SQLException: IO Error: Unknown host specified' errors.
Is there someone able to give me the information I need to connect? Is there any further information that I need to provide?