OLE connection to SQL string: Provider=MSDataShape;Data Provider=SQLOLEDB is generating an error message

[MosheS Singer]

I want to use MSDataShape and I have seen many examples online

to make an OLE connection to SQL and the connection string should be ("Provider=MSDataShape;Data Provider=SQLOLEDB")

for example I just found on the following site Make sure to use the right Provider when creating shaped ADO Recordsets the aforementioned example.

I also installed the best OLE driver for SQL "msoledbsql_18.3.0.0x64.msi"

However, when I tried to make the connection to SQL 2014 Server, I got an error message:


System.Data.OleDb.OleDbException: 'Data provider could not be created.
Class not registered'


This exception was originally thrown at this call stack:
System.Data.OleDb.OleDbConnectionInternal.OleDbConnectionInternal(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection)
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionPoolGroup, System.Data.Common.DbConnectionOptions)
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, out System.Data.ProviderBase.DbConnectionInternal)
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions)
System.Data.ProviderBase.DbConnectionInternal.OpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory)
System.Data.OleDb.OleDbConnection.Open()
Tenants.ChovPopUp.POfPdtls(String) in ChovPopUp.vb
Tenants.ChovPopUp.ChovPopUp_Load(Object, System.EventArgs) in ChovPopUp.vb
System.Windows.Forms.Form.OnLoad(System.EventArgs)
...
[Call Stack Truncated]






Can someone suggest a solution how I can accomplish creating a connection without generating error messages?

Continue reading...