DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ODBC

  1. #1
    Intern Guest

    ODBC


    Does anyone know how to create an ODBC connection through VB code.

    my goal is to have 5 ODBC connections create the first time a program runs,
    but I honestly have no clue where to begin.

    Thanks



  2. #2
    Chris Ross Guest

    Re: ODBC

    You are talking about DSN configuration? The easiest way to set up ODBC DSN
    settings is to set them up on your machine first, ensure they work, then
    export the registry settings to a reg file that you can deploy with your
    app, (either in P&D Wiz, or Visual Installer). You can find the registry
    keys for ODBC DSN settings at -
    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

    Watch out for different OS's though... NT's setting may be different than
    95, or 98, etc. Also, if the client PC has a name conflict with a DSN that
    you are trying to set up, the registry file you are deploying may overwrite
    the existing values on the client.

    Hope this helps...

    Chris Ross


    Intern <ledzepplin1979@yahoo.com> wrote in message
    news:3948ccf0$1@news.devx.com...
    >
    > Does anyone know how to create an ODBC connection through VB code.
    >
    > my goal is to have 5 ODBC connections create the first time a program

    runs,
    > but I honestly have no clue where to begin.
    >
    > Thanks
    >
    >




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