by Sanoop kurian (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Mon 16th December 2002
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Connect to oracle No need of "ODBC"
API Declarations
Dim rs As ADODB.Recordset
'REFERENCE -MICROSOFT ACTIVEX DATA OBJECTS 2.1 LIBRARY
Set db = New ADODB.Connection
db.Provider = "MSDAORA"
db.Open "", "USER NAME", "PASSWORD"
Set rs = New ADODB.Recordset
rs.ActiveConnection = db
rs.Open "select * from <TABLE NAME>"
End Sub