about project
 

Re: about project
 

Easy Way to Connect Oracle from VB

Install Oracle Client on your system

'Connection Object for Oracle Database connection
Dim con As ADODB.Connection

'Recordset Object for Oracle Tables

Dim rst As New ADODB.Recordset

con.Open "Provider=MSDAORA;Data Source=OracleDataBase;User ID=OracleUserID; Password=OraclePassword;

rst.Open "Select * From OracleTableName"

Do While Not rst.EOF

'Do the Processing here Display etc

Msgbox rst("No")
Msgbox rst("Name")

rst.MoveNext

Loop

rst.close
con.close

set rst = Nothing
Set con = Nothing