I am attempting to configure the connection between the IS46 and Oracle 8.1.7 on an AIX 4.3 machine using the Oracle JDBC.
I have configured a thin client connection correctly but would prefer the OCI8 client. I have correctly configured this on a number of other NT machines to get to the DB but cannot get the connection to work on the AIX machine.
I have tried using the tnsnames.ora ie:
as well as the Net8 approach ie:
The AIX machine is where the Oracle db is as well.
Any thoughts would be appreciated. Also does anyone have experiences as to which is the best driver to use?