• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Connect to oracle No need of ODBC

Connect to oracle No need of ODBC

Connect to oracle No need of "ODBC"

API Declarations


Dim rs As ADODB.Recordset
'REFERENCE -MICROSOFT ACTIVEX DATA OBJECTS 2.1 LIBRARY



Rate Connect to oracle No need of ODBC

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

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