Re: Using Visual Basic and Connecting to Oracle

From: Jim Harrison <jim_at_colway.freeserve.co.uk>
Date: 2000/04/24
Message-ID: <8e2db3$cqr$1@newsg3.svr.pol.co.uk>#1/1

Glenn,

I'd recommend using MS ADO (Project->References->Microsoft ActiveX Data Objects 2.0 Library).
To connect to your database include a connection object (add this to your main form)...

Global gadoCo As New ADODB.Connection Then create a recordset (in your class or basic modules):

Private adoRs As New ADODB.Recordset Then use it:

    adoRs.Open "SELECT * FROM tab"
    adoRs.MoveNext
    txtTextBox.Text = adoRs.Fields!<FieldName>

Have fun!

--
Jim Harrison
Colway Software and Design
www.colway.freeserve.co.uk

Received on Mon Apr 24 2000 - 00:00:00 CDT