Re: visual basic and oracle

From: Alexis Rios <alexr_at_coqui.net>
Date: 1999/04/16
Message-ID: <eiy0kMEi#GA.265@cppssbbsa03>#1/1

Add the reference Microsoft ActiveX data object 2.0 or higher to your project

Private cn as new ADODB.Connection
Private s as string

Private Sub ConnectToOracle()

    s = "User Id=SYSTEM;Password=MANAGER;Data Source=ServiceName"     With cn

        .ConnectionString =  s
        .ConnectionTimeOut = 3
        .CursorLocation = adUseClient
        .Provider = "MSDAORA"
        .Open

    End With
End Sub

Brian Marston <bmarston_at_arches.uga.edu> wrote in message news:7e1n4k$6vl$1_at_ash.prod.itd.earthlink.net...
> Hello everyone,
>
> Is there any way to connect visual basic to an oracle database? I know
 you
> can connect MS Access to Visual Basic.
>
> Thanks
>
> Brian
>
> bmarston_at_arches.uga.edu
>
>
>
Received on Fri Apr 16 1999 - 00:00:00 CDT