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:
jdbc:oracle:oci8:@SID
as well as the Net8 approach ie:
jdbc:oracle:oci8:@(description=(address=(host=host)(protocol=tcp)(port=XXXX))(connect_data=(sid=XXXX)))
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?
Thanks