Install shield SQL Connection Provider

Question

Installshield executes SQL scripts file, Installshiled use OLEDB provider. I want installshield to use SQLCLIENT provider.

due to OLEDB I get error.

1: ADO Error: Number: -2147467259 Description: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error. Source: Microsoft OLE DB Provider for SQL Server SQL State: 08001 Native Error: 18 MSI (s) (AC!D0) [16:30:38:084]: Product: XXX -- Error 27502.Could not connect to Microsoft SQL Server ''. [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error. (18)

I searched solution for this error and some user used SQL Client instead of OLEBD it worked. How to force installshield to use SQLCLIENT provider?

It's been many years since I used InstallShield but I used to perform database installation tasks using a .NET custom action, which used SqlClient. The reference to ADO in the error suggests the out-of-the-box provider is unmanaged. — Dan Guzman
Thank you. I have switched to .net managed assembly custom action. — dilipkumar katre

Saalim Aslam Saalim Aslam · Accepted Answer · 2018-08-27T12:20:15

Go to Direct Editor --> ISSQLDBMetaData --> Change AdoDriverName to SQLNCLI11 in install shield project for youe installer.

Install shield SQL Connection Provider

1 Answers