How to retrieve data from Oracle 8.5i database running on NT Server 4.0
Posted on 2011-09-08
I inherited an old server box running some software that is Oracle based. I need to pull that data out of Oracle and dump it into a database or spreadsheet. My issue is, I have no idea how to connect to the Oracle database. My other issue is, I know absolutely nothing about Oracle.
I did a little bit of research and attempted to download some tools to make the connection but I keep getting road blocks, I've tried 2 pieces of software
The Oracle Instant Client - I receive this error
TSN:PROTOCOL ADAPTER ERROR
DbVisualizer Free - I receive this error
Io Exception: Invalid connection string format, a valid format is: "host:port:sid"
I can locate my tnsnames.ora file on the Oracle server and get the information from there. My hang up seems to be with this driver that is needed that both of these applications want, and setting that up.
If there is an easier way to do this, I'm all ears. Any help is greatly appreciated!!