Looking for dialog to browse available connections

[Jerry Shea]

Can anyone point me to a dialog box which will allow me to browse for an
ADO.NET (or ODBC) connection?

The user would select the provider (ODBC data source), the server, database
etc. Dialog would construct the connection string.

Thanks

 

[William \(Bill\) Vaughn]

Is this designed to look for the connections managed by the SQL Connections
dialog or simply search for available servers? If the latter, you can use
SQLDMO to search for SQL Servers on the net.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Jerry Shea]

What I really want is to enable a user to choose an arbitary datasource;
they might choose the MS Access provider and an access .mdb, the SQL Server
provider or an Oracle provider for example.

 

[William \(Bill\) Vaughn]

There is no common "registry" that lists all of the various data sources.
Many providers have their own mechanisms to expose servers of their own
kind. For example, SQL Server publishes its presence on the net and SQLDMO
knows how to look for these servers. The JET/Access engine has no such
mechanism, but you could do a search for .MDB files or construct a registry
yourself after having located target DBMSs.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________