VB SQL ASP Oledb Connection Error

Question

I got an error An OLE DB Provider was not specified in the Connection String. I tried these Connection String also

Provider=SQLOLEDB;

Answer 1

Go to http://www.connectionstrings.com/sql-server/ and find correct string for your database.

If you use SQL Server Native Client 10.0 OLE DB Provider, add "Provider=SQLNCLI10.1"

Example,

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

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