module1.bas

This project solves the purpose of creating vb6 application using oracle database in back end. It sh

Attribute VB_Name = "Module1"
    Global USCon As ADODB.Connection
    Global USRec As New ADODB.Recordset
    
Sub CnConnect(USDbase As String, USPass As String, USUser As String, USString As String)
    Set USCon = CreateObject("ADODB.Connection")
    USCon.ConnectionString = "Provider=OraOLEDB.Oracle;" & _
    "Data Source=" & USDbase & ";" & _
    "User ID=" & USUser & ";" & _
    "Password=" & USPass & ";" & _
    "PLSQLRSet=1;"
    USCon.Open
    Form1.Show
End Sub