1. Make sure MDAC 2.1 or later installed (this provides the
OLEDB provider for Oracle
2. Make sure (Oracle) Net8 client is installed that
the connection to the Oracle 8i database server is
tested from this client eg. using PL/SQL on that
client machine
3. In the ADO code, specify the ADODB connection string as
= "Provider=OraOLEDB.Oracle;User ID=user;Password=password;
Data source=net8_connect_string_in_tnsnames_ora;"
eg.
= "Provider=OraOLEDB.Oracle;User ID=user;Password=****;
Data source=<your oracle server hostname>;"