Microsoft SQL Server prerequisites

Before you can define and configure Datacap application databases for Microsoft SQL Server, ensure that the required software is installed on your system.

The following prerequisites must be installed and running on the appropriate computers in your Datacap system:
  • Datacap 8.0 or later:
    • Set up Datacap Server Service
    • Set up at least one Datacap Client station
  • Microsoft SQL Server version 2005 or later on the database server computer
  • Microsoft SQL Server 2008 Native Client on every Datacap computer that accesses the database server. The Native Client contains the SQL OLE DB provider driver that Datacap uses to connect to SQL Server. No further configuration is required.
Important: In order to avoid having to create a separate Database type or provider name in Datacap Application Manager for each of the newer Microsoft SQL Server drivers (MSOLEDBSQL17, MSOLEDBSQL18, MSOLEDBSQL19) released by Microsoft, it is required to install 32-bit Microsoft OLE DB Driver for SQL Server on the Datacap system running the Datacap application.