January 21st, 2004, 09:58 AM
I've just been added to a java project that involves connecting to an Oracle Database. But my purpose is not coding, I just need to gain access to the Oracle Database and view the table attributes.
At any rate, I downloaded Toad and SQL Navigator, but both don't work. They both keep saying "Unable to load OCI.dll". Now I don't want to install Oracle on my machine as i'm just supposed to view the files...
January 21st, 2004, 10:47 AM
If you already have installed oracle in your server then you need to install only oracle client in your machine, this client side software provides the tools to create a connection with database of your server as well as SQL*Plus to run any queries.
I dont know about the TOAD, but the installation of TOAD is not sufficient itself you need to configure something, go though the documentation of TOAD.
January 21st, 2004, 11:20 AM
I have a viewer in my signature that uses the Oracle thin client. All you need is a jre. You will need to know the IP/host_nameort:SID and you will be able to do all the things you need.
Here is a connection example: