Connect to an Oracle DB Using ADO

Category:
Database
Type:
Snippets
Difficulty:
Beginning
Author:
Enkhbayar

Version Compatibility: Visual Basic 6

More information:
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.

Declarations:

Code: