Connection string

I would like to make it easy for users of my app to change database. Not
everyone knows all the necessary settings in a connection string, so is
there any way for me launch the database "Connection properties" window
(same as when generating a connection string in VS2005) from my application?

Regards Stig

Hi Stig,

Well, you still can but you'll have to parse/adjust connection string (just
google around and you'll find plenty of examples such as
http://groups.google.com/group/micr...c09b11eb6b489eb).
However, I would recommend using your code - with DbConnectionStringBuilder
derived classes and DbDataSourceEnumerator derived classes it shouldn't be
hard.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Stig-Arne Basberg" <sab@isystem.no> wrote in message
news:e59OrNw1GHA.1268@TK2MSFTNGP02.phx.gbl...
>I would like to make it easy for users of my app to change database. Not
>everyone knows all the necessary settings in a connection string, so is
>there any way for me launch the database "Connection properties" window
>(same as when generating a connection string in VS2005) from my
>application?
>
> Regards Stig
>
>

Thanks, I'll try that.

Stig

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:eh5Bngw1GHA.476@TK2MSFTNGP06.phx.gbl...
> Hi Stig,
>
> Well, you still can but you'll have to parse/adjust connection string
> (just google around and you'll find plenty of examples such as
> http://groups.google.com/group/micr...c09b11eb6b489eb).
> However, I would recommend using your code - with
> DbConnectionStringBuilder derived classes and DbDataSourceEnumerator
> derived classes it shouldn't be hard.
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
>
> "Stig-Arne Basberg" <sab@isystem.no> wrote in message
> news:e59OrNw1GHA.1268@TK2MSFTNGP02.phx.gbl...
>>I would like to make it easy for users of my app to change database. Not
>>everyone knows all the necessary settings in a connection string, so is
>>there any way for me launch the database "Connection properties" window
>>(same as when generating a connection string in VS2005) from my
>>application?
>>
>> Regards Stig
>>
>>
>
>