Changing connection string in VB for .Net 2.0

drfunfrock · Post by **drfunfrock** » Fri 14 Jul 2006 09:04

I tried to make a dialog to change the connection string in my application settings but this member of My.settings ist readonly. What is the way to change the connection string? Is it possible to use the dialog that popups in Visual Studio?

Alexey · Post by **Alexey** » Fri 14 Jul 2006 11:03

Please describe what exactly you need or what is the problem.

drfunfrock · Post by **drfunfrock** » Fri 14 Jul 2006 11:18

I want to change the ConnectString in My.settings at runtime. The string is build by a wizard when you add a new datasource.

Alexey · Post by **Alexey** » Fri 14 Jul 2006 11:47

You are right, My.Settings.ConnectionString is read-only.
What is the purpose of changing it?

drfunfrock · Post by **drfunfrock** » Fri 14 Jul 2006 11:54

I want to change the database server and user at runtime thats the purpose, without compiling my application.

Alexey · Post by **Alexey** » Fri 14 Jul 2006 12:23

Dataset doesn't have connection information. It is stored in the TableAdapter.