DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Database Connection String

Hybrid View

  1. #1
    Andrew Guest

    Database Connection String


    I'm creating an app that a company will use to connect to an Access database
    on a central server using ADO (REASON: Might be converted to SQL Server/Oracle).
    My question is what is the best, or most common, connection string use to
    point to the database? Is using a DSN popular or a registry entry or even
    an INI file? The users, and even the client, are not real savvy so I would
    like it to be a simple as possible.

    Thanks!

  2. #2
    Douglas J. Steele Guest

    Re: Database Connection String

    I'd avoid the DSN, because of the headaches deploying it. Go DSN-less, and
    store the connection string in either the registry or an INI, whichever
    you're more comfortable with.

    BTW, a good source of connection string information can be found at
    http://www.able-compute.com

    --

    Doug Steele, Microsoft Access MVP
    Beer, Wine and Database Programming. What could be better?
    Visit "Doug Steele's Beer and Programming Emporium"
    http://I.Am/DougSteele/


    Andrew <mclellan_a@nospanYahoo.com> wrote in message
    news:390dbc42$1@news.devx.com...
    >
    > I'm creating an app that a company will use to connect to an Access

    database
    > on a central server using ADO (REASON: Might be converted to SQL

    Server/Oracle).
    > My question is what is the best, or most common, connection string use to
    > point to the database? Is using a DSN popular or a registry entry or even
    > an INI file? The users, and even the client, are not real savvy so I

    would
    > like it to be a simple as possible.
    >
    > 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