?
Solved

VB.NET 2010 ADO Connection String

Posted on 2011-02-24
1
Medium Priority
?
817 Views
Last Modified: 2012-05-11
I have a scenario that appears from my research to be a common issue but have yet to find a solution.  The scenario is:

1. I have a VS2010 VB.NET Application
2. Within this project I have added a datasource and this has created an xsd designer object
3. The ConnectionString created is a Application Scope setting (this is I understand not optional and cannot be a user scoped setting)
4. The ConnectionString setting refers to a database on my development server

This application is not an 'internal' company application but one that will be distributed to many clients, each of which have their own networks, servers etc.

The problem comes in that the ConnectionSetting is read only so how, when I deploy the application, and it is installed on a client network can the client select the database to connect to.

This does seem to be a fundamental requirement of distributing applications but I cannot find anywwhere a solution other than to not use the datasource objects and use my own code to connect to data sources and have unbound controls.

Is there a solution to this problem or alternative strategies/methods for connecting to a datasource and using strongly typed datasets with bound controls?
0
Comment
Question by:BorisMatthews
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

by:
PagodNaUtak earned 2000 total points
ID: 34968613
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question