Solved

VB.NET 2010 ADO Connection String

Posted on 2011-02-24
1
810 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
1 Comment
 
LVL 8

Accepted Solution

by:
PagodNaUtak earned 500 total points
ID: 34968613
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now