Connection to Oracle

Hi all ;)
I want to do a project with VB as front end and Oracle as Backend.
Please tell me how to connect to oracle database in VB
(if possible please give me an example)
Thanx in advance
- Satish
[238 byte] By [satish_sankoori] at [2007-11-17 16:58:44]
# 1 Re: Connection to Oracle
'put a reference to
'Microsoft Activex (highest number) Data Object Library
Dim cnn As ADODB.Connection
Dim strCnn As String
strCnn = "Provider=MSDAORA.1;Data Source=DW04_OLIM_PR.WORLD"
'where data source = your Oracle Server Name
cnn.Open strCnn, anAutenticatedUser, hisPassword
'...
Cimperiali at 2007-11-10 0:23:01 >