An OLE DB Provider was not specified in the ConnectionString. 'Provider=SQLOLEDB;

Question

i trying to run query using C#, i am getting the following problem

An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;

my code

string strConString = System.Configuration.ConfigurationManager.ConnectionStrings["WorkflowConnStr"].ConnectionString.ToString(); 
string sqlstr = "select * from table"        
OleDbConnection myConnection = new OleDbConnection(strConString);
try
     {myConnection.Open();}
catch (Exception err) 
     { System.Diagnostics.Debug.WriteLine(err.Message); }

OleDbCommand myCommand = new OleDbCommand(sqlstr, myConnection);
OleDbDataReader reader = myCommand.ExecuteReader();

web.config

<add name="WorkflowConnStr" connectionString="Data Source=Server;Initial Catalog=DBName;user id=usr;password=password" providerName="System.Data.OleDb.OleDbConnection"/>

any suggestion ?

Create a `Test.UDL` and get a valid connection string from that file. — Hassan, Apr 21 '14 at 07:40

score 8 · Accepted Answer · answered Apr 21 '14 at 07:38

8

Try adding this to your connection string,

Provider=SQLNCLI10.1

So it would be;

<add name="WorkflowConnStr" connectionString="Data Source=Server;Initial Catalog=DBName;user id=usr;password=password;Provider=SQLNCLI10.1" providerName="System.Data.OleDb.OleDbConnection"/>

answered Apr 21 '14 at 07:38

Mez

4,666
4
29
57

SQLNCLI10.1 is for SqlServer2008 and SQLNCLI11 for SqlServer2012 according to [this](http://stackoverflow.com/a/1499065/521554) link. – LosManos Aug 19 '15 at 09:45

score 1 · Answer 2 · edited Jul 03 '18 at 13:34

1

Use SqlConnection instead of OleDbConnection.

edited Jul 03 '18 at 13:34

Robert Columbia

6,313
15
32
40

answered Jul 03 '18 at 11:24

Malek Tubaisaht

1,170
14
16

An OLE DB Provider was not specified in the ConnectionString. 'Provider=SQLOLEDB;

2 Answers2

Linked