Connection string

[Stig-Arne Basberg]

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

 

[Miha Markic [MVP C#]]

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...+group:*adonet*&rnum=2&hl=sl#2c09b11eb6b489eb).
However, I would recommend using your code - with DbConnectionStringBuilder
derived classes and DbDataSourceEnumerator derived classes it shouldn't be
hard.

 

[Stig-Arne Basberg]

Thanks, I'll try that.

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...+group:*adonet*&rnum=2&hl=sl#2c09b11eb6b489eb).
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/

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