Can I recieve a list of ODBC data sources to use with ADO?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Can I recieve a list of ODBC data sources to use with ADO?

Hybrid View

  1. #1
    Pat Smith Guest

    Can I recieve a list of ODBC data sources to use with ADO?


    Any help is greatly appreciated.

    I am trying to write a small app that will help streamline the process for
    creating and running a few Oracle Stored Procedures. Before the user can
    do the create or run, they will need to be connected to the database. These
    actions will need to be available for multiple databases, so I wanted to
    offer a drop down list of the available ODBC data sources local to the user's
    PC(preferebly only the Oracle ones). I saw that there was some raw ODBC
    API calls that I could make, but I thought I would ask if there was a simple
    way I have not found yet.

    I may have more questions later about getting ADO to create and run my stored
    procedures, but for now this is my first hurdle.

    Thanks in advance for any help,
    -Pat

  2. #2
    Paul Clement Guest

    Re: Can I recieve a list of ODBC data sources to use with ADO?

    On 17 Nov 2000 14:15:29 -0800, "Pat Smith" <patrick.smith@mail.com> wrote:


    Any help is greatly appreciated.

    I am trying to write a small app that will help streamline the process for
    creating and running a few Oracle Stored Procedures. Before the user can
    do the create or run, they will need to be connected to the database. These
    actions will need to be available for multiple databases, so I wanted to
    offer a drop down list of the available ODBC data sources local to the user's
    PC(preferebly only the Oracle ones). I saw that there was some raw ODBC
    API calls that I could make, but I thought I would ask if there was a simple
    way I have not found yet.

    I may have more questions later about getting ADO to create and run my stored
    procedures, but for now this is my first hurdle.

    You can pull this information from the Registry:

    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

    Code for Registry access:

    http://www.planetsourcecode.com/xq/A...s/ShowCode.htm


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center