Re: Accessing oracle using a data control

Chris,

[Quoted] 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 [Quoted] 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 - 20:40:47 CET