Visual LANSA Install can fail due to incorrect Native Client driver

Date:18 April 2012
Product/Release:Visual LANSA - V12 SP1
Abstract:Installing Visual LANSA on a 64-bit PC can fail due to incorrect Native Client driver
Submitted By:LANSA Technical Support

Description:

Installing Visual LANSA V12 SP1 on a 64-bit O/S can fail in the following situation:

  • Windows 64-bit Operating system
  • no SQL Server Native Client driver installed
  • Installing Visual LANSA V12 SP1 and selecting one of the following install types
    • Network Client install (Shortcuts to run Visual LANSA installed on another PC)
    • Client to a Slave Database Server
    • Client to an Independent Database Server

The install error is:

ODBC driver <SQL Server Native Client 10.0> for Data Source <LXLANSA> does not exist

The Visual LANSA install establishes that the SQL Server Native driver is not available and attempts to install it. However, the 32-bit version of the Native Client driver sqlncli.msi is incorrectly installed instead of the 64-bit version of the Native Client driver. This installation fails and the MSSQLNavCli_Install.log contains the message Microsoft SQL Server 2008 Native Client – Installation of this product failed because it is not supported on this operating system.

Solution:

The solution is to manually install the 64-bit version of the Native Client driver sqlncli_X64.msi from the following location on the V12 SP1 DVD

setup\Installs\MSSQLNAVCLI\sqlncli_X64.msi

The Visual LANSA V12 SP1 install can then be rerun.