Enumerate providers on System / Understanding providers and dataproviders

C

Chuck Vance

Hi ng,
when I use ADO.NET 2.0 System.Data.Common.DbProviderFactories-Class to enumerate the providers it get:
Odbc Data Provider
OleDb Data Provider
OracleClient Data Provider
SqlClient Data Provider

But how can I get the names used in Connection-String such like "provider=MSDAORA;...". ?

Chuck
 
M

Mary Chipman [MSFT]

You can find it in the documentation for the .ConnectionString
property of the connection object or the builder class, e.g.,
OleDbConnectionStringBuilder or OleDbConnection.ConnectionString. If
all else fails, connectionstrings.com has a wide selection.

-Mary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO.NET 2.0 - Connection user interface... 2
enumerate odbc data sources 4
DbConnectionStringBuilder 2
OLEDB Provider database connectivity 2
AD.Net and Oracle Provider 2
How to generate "plain" SQL with OleDb or Odbc providers, in db in 1
(.NET 2.0) Adding your own DataProvider to the DbProviderFactory model. 1
Provider-independent data access, again 2

Top