OLEDB ODBC connection string component, does it exist?

[Guest]

We have internal software that knows how to do some work on a ADO.NET
Dataset. We are looking for a component that can visually walk the user
through setting up either an OLEDB or ODBC connection string. Ideally, but
not required, it would also be great if it passed back a DataSet or DataTable
of the data.

We are capable of coding this ourselves but I first want to see if there are
any commerical products that do this? Or perhaps there exists a submitted
project with code that illustrates an easy way to do this? I have scoured
and have not seen anything so far.

Any advice?

Thanks alot!
Dan

 

[Mary Chipman [MSFT]]

If you are planning an upgrade to ADO.NET 2.0, there are connection
string builders for all of the .NET data providers. For more
information, see
http://msdn2.microsoft.com/en-us/library/ms254947.aspx. If upgrading
is possible, perhaps the article will give you some ideas on how to
proceed building your own.

--Mary