Re: Accessing oracle using a data control

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

Chris Jordan wrote in message ...
>Hi there,
>
>I have set up ODBC DSN in control panel for the Oracle 8.0.5 using
 Oracle's
>ODBC driver. I also was able to run
>odbctst.exe and check out that it worked. In Visual Basic 6.0, I tried to
>access oracle by using Data Control
>and setting its 'CONNECT' property to Oracle(the name of my oracle DSN).
>But 'oracle' is not listed there!!
>In the 'connect' dropdown box, I see only ACCESS, dbase, Foxpro,paradox,
>excel, and text!
>
>I can use this data control to work with an access database, but I would
>like to connect to oracle tables. And after setting up ODBC, I would have
>thought that my new oracle DSN would in fact show up in the 'connect'
>property of the DataControl in VB. But no such luck. How do I open Oracle
>using the data control?
>
>Much thanks,
>Chris
>
>
Received on Fri Nov 05 1999 - 00:00:00 CET