Re: Accessing oracle using a data control

Thanks Brian. it worked like a charm!

Chris

Brian W. Chester <bwchester_at_home.com> wrote in message news:3pGU3.826$Zu4.18346_at_news1.rdc1.mb.home.com...
> Chris,
>
> It has been a long time since I looked at VB but I just tested the
> connection on VB6.0 SP3 as follows:
>
> For DataControl choose the categorized tab and go to Data then set:
> Connect ODBC
> DatabaseName null
> DefaultCursorType 1 - ODBCCursor
> DefaultType 2 - UseJet
> RecordType 1 - Dynaset
>
> When you click on the RecordSource property you will be asked to log on to
> the Oracle database. Once logged on you will be presented with every
table
> and view in the database. Scroll through and find the one you want.
>
> Hope it works for you.
>
> Brian
>
Received on Fri Nov 05 1999 - 21:31:40 CET