Get list of OleDb providers with C#
-
Hi All, I am currently working on a part of my project (using windows forms in C#.Net) which involves creating connection string based on values. I have a simple form where the user can specify the type of database (SQL Server, Access etc.) and then give specific connection information based on the database type selected. One thing I would like to be able to do is to allow the user to specify the OleDb provider when using an access database. I can easily allow free text entry for the provider but it would be much more user friendly if I could give the user a drop down of available providers for selection. So... Does anybody know have I could retrieve such a list? Thanks ...Oh, and before anybody wants to complain, I have had no luck with google
Life goes very fast. Tomorrow, today is already yesterday.
-
Hi All, I am currently working on a part of my project (using windows forms in C#.Net) which involves creating connection string based on values. I have a simple form where the user can specify the type of database (SQL Server, Access etc.) and then give specific connection information based on the database type selected. One thing I would like to be able to do is to allow the user to specify the OleDb provider when using an access database. I can easily allow free text entry for the provider but it would be much more user friendly if I could give the user a drop down of available providers for selection. So... Does anybody know have I could retrieve such a list? Thanks ...Oh, and before anybody wants to complain, I have had no luck with google
Life goes very fast. Tomorrow, today is already yesterday.
Hi I`m searching for the same thing. The only thing i have found is using SQL function EXEC master..xp_enum_oledb_providers