Provider cannot be found(MSSQL/OLEDB)

Hi All,
    I just test on the writer, and it was configured with a tested MSSQL connection; but when I run sql with the connection, it shows "Provider cannot be found..."; I tested with both 32 and 64bit versions of this tool and got same results.
    Please help. thank you.

regards,
Bill

Our software uses "Microsoft ole db provider for sql server"

Most likely it is missing on your computer.

I think if you install Microsoft SQL Server Management Studio it will be installed for you automatically



Please keep us posted on your progress

Hi Mike, Thanks for your reply.
It works after adding "Provider=MSOLEDBSQL;" in the connection string. thanks.

seems I need to prepare the db table first in the target sql database, Is it possible to generate the database table automatically? 

I understand the issue and I have seen it a lot of times in the past

We will create a separate Wiki article to make life for our customers easier

Slight correction to the original post

Our software uses both ODBC and OleDb for working with MS SQL Server.

ODBC is used for testing connections and loading data using BCP
OLE DB Is used for editing data manually and running SQL script

As you are probably aware there are multiple clients of MS SQL Server available

When our software starts it looks for the highest available ODBC driver and it uses it
It also assumes that you have a matching  OleDB Provider for it (If you do not you get an error)

The logic is as follows:

GetListOfInstalledODBCDrivers 

  if DriverFound('ODBC Driver 17 for SQL Server') 
     BcpDLL   = 'MSODBCSQL17.dll'
     SQLODBC  = 'DRIVER={ODBC Driver 17 for SQL Server}'
     SQLOLEDB = 'Provider=SQLNCLI11.1'
 else 
  if DriverFound('ODBC Driver 13 for SQL Server')
     BcpDLL   = 'MSODBCSQL13.dll'
     SQLODBC  = 'DRIVER={ODBC Driver 13 for SQL Server}'
     SQLOLEDB = 'Provider=SQLNCLI11.1'
else
  if DriverFound('ODBC Driver 11 for SQL Server')
     BcpDLL   = 'MSODBCSQL11.dll'
     SQLODBC  = 'DRIVER={ODBC Driver 11 for SQL Server}'
     SQLOLEDB = 'Provider=SQLNCLI11.1'
else
   if DriverFound('SQL Server Native Client 11.0')
     BcpDLL   = 'Sqlncli11.dll'
     SQLODBC  = 'DRIVER={SQL Server Native Client 11.0}'
     SQLOLEDB = 'Provider=SQLNCLI11.1'
else
  if DriverFound('SQL Server Native Client 10.0')
     BcpDLL   = 'Sqlncli10.dll';
     SQLODBC  = 'DRIVER={SQL Server Native Client 10.0}'
     SQLOLEDB = 'Provider=SQLNCLI10.1'
else
if DriverFound('SQL Native Client')
     BcpDLL   = 'Sqlncli.dll';
     SQLODBC  = 'DRIVER={SQL Native Client}'
     SQLOLEDB = 'Provider=SQLNCLI.1'
  else
     BcpDLL   = 'ODBCBCP.DLL'
     SQLODBC  = 'DRIVER={SQL Server}'
     SQLOLEDB = 'Provider=SQLOLEDB.1'

So you may have a situation where you do not have a matching OleDB provider = You get an error

So back to my original suggestion.

if you install Microsoft SQL Server Management Studio the matching drivers  will be installed for you automatically
(Last time I did it, it worked)

Please keep us posted on your progress.