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:
Dim Cn As ADODB.Connection Dim CP As ADODB.Command Dim Rs As ADODB.Recordset Dim Conn As String Dim QSQL As String

Code: