OCI.dll

Hi there,

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...

any thoughts?

Bill

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.

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:
user
password
192.168.0.1:1521rcl
schema_name