Requirements for Connecting to Instances of SQL Server Express LocalDB

InstallShield 2015

Project: This information applies to the following project types:

Basic MSI
DIM
InstallScript
InstallScript MSI

If you want your installation to support connections to instances of SQL Server Express LocalDB, the target system must have the SQL Server Native Client 11 ODBC driver. To ensure that it is present on target systems, you can include the Microsoft SQL Server 2012 Native Client prerequisite in your installation. You also must configure your project to use the driver.

To include the appropriate SQL Server Native Client prerequisite in your project for connecting to instances of SQL Server Express LocalDB:

1. For Basic MSI and InstallScript MSI projects: In the View List under Application Data, click Redistributables.

For InstallScript projects: In the View List under Application Data, click Prerequisites.

2. In the list of redistributables, select the appropriate Microsoft SQL Server 2012 Native Client check box.

The InstallShield prerequisite is launched only if the conditions that are defined in the InstallShield prerequisite file (.prq) are met. To see the list of conditions, click the SQL Server Native Client prerequisite in the Redistributables view or the Prerequisites view, and then review the details that are listed in the details pane on the right. You can hide or show the details pane by clicking the Show Details button in these views.

To configure your InstallShield installation project so that your installation uses the SQL Server Native Client 11 ODBC driver:

1. In the View List under Additional Tools, click Direct Editor.
2. In the Tables explorer, click the ISSQLDBMetaData table.
3. In the ISSQLDBMetaData column, find the MSSQLServer row.
4. Replace the value of the AdoDriverName column with the following:

sqlncli11

At run time, the installation uses the SQL Server Native Client 11 ODBC driver when connecting to a SQL Server Express LocalDB database.

See Also