connecting vb to oracle 8i db

[rushtosri]

Hello

I'm new to Oracle and VB. I've just started learning these. Can anyone tell me how to connect Oracle db to vb?? Plz point me to some good resources on the net which gives me these details and other stuff related to this.

Thankx in advance..
With regards,
Shri

 

[Jero43]

Under Project... References... Include Oracle InProc Server

Private Session As OraSession
Private Database As OraDatabase
Private Dynaset As OraDynaset

Private Sub OracleThingo()
Set Session = CreateObject("OracleInProcServer.XOraSession&quot
Set Database = Session.OpenDatabase(&quot;<DatabaseName>&quot;, <Username> & &quot;/&quot; & <Password>, 0&)
Set Dynaset = Database.CreateDynaset(&quot;Select * From Cars&quot;, 0&)
End Sub