Connect to an Oracle DB Using ADO
Version Compatibility: Visual Basic 6
Simple connection string for Oracle DB. First you need configure tnsnames.ora file. Also you need a reference to ADO in your vb project. Change the user name, password and service name to what you are using.
Instructions: Copy the declarations and code below and paste directly into your VB project.