Database: Oracle DB Connection (VB6)

In our OJT (on-the-job training) in Davao Light, we learned and acquired a lot of knowledge, particularly an enhanced knowledge on the Visual Basic 6 language, and the introduction of the Oracle database (PL/SQL developer). In our junior years, we were exposed to two database applications, namely mySQL and MS Access. In this entry I will share a snippet of the connection 'code' we used in most of our codes and programs.

First of all, we are using the PL/SQL Developer version 6.0.5.926 (it's the counterpart of mySQL's query browser and admistrator in Oracle DB).

Second, I would like to repeat once again, that we are using VISUAL BASIC 6 here. And one should take note of the following references (references, is found in Project):

• Microsoft DAO 3.51 Object Library (DAO350.dll)
• Oracle Data Control (oradc.ocx)
• oraOLEDB 1.0 Type LIbrary (oraOLEDB.dll)
• Microsoft ACtiveX Data Objects 2.5 Library (msado25.tlb)
  

Oh, one last thing to point out: the following code is placed in a MODULE, not a FORM.

Here's the code: