Microsoft SQL Server

  1. Make sure that ODBC data source is defined on database client and database server systems, with the correct ODBC driver. Note that Genero FGL provides different types of SQL Server drivers:

    • On Microsoft® Windows® platforms:

      • Use an SNC (dbmsnc*) driver either with the Microsoft ODBC driver for SQL Server, or with the Microsoft SQL Native Client driver:
        • For Microsoft ODBC 17 (MSODBCSQL17.DLL), use dbmsnc_17.
        • For Microsoft ODBC 13 (MSODBCSQL13.DLL), use dbmsnc_13.
        • For Microsoft SQL Native Client 11 (SQLNCLI11.DLL), use dbmsnc_11.
        • For Microsoft SQL Native Client 10 (SQLNCLI10.DLL), use dbmsnc_10.

          Resource: msdn.microsoft.com.

        Important: Configure your ODBC data source to use the appropriate Microsoft SQL Server driver.

    • On Linux® platforms:

      • With the SNC (dbmsnc*) driver, use the Microsoft ODBC for SQL Server on Linux client (msdn.microsoft.com):
        • For Microsoft ODBC 17 (libmsodbcsql-17.so), use dbmsnc_17.
        • For Microsoft ODBC 13 (libmsodbcsql-13.so), use dbmsnc_13.

        Minimum Microsoft ODBC for SQL Server on Linux version: 13.0.

      • With the FTM (dbmftm*) driver, use the FreeTDS ODBC client (www.freetds.org).

        Minimum FreeTDS version: 1.00.

      • With the ESM (dbmesm*) driver, use the Easysoft ODBC driver for SQL Server (www.easysoft.com).

        Minimum Easysoft version 1.5; Version 1.9 is strongly recommended.

  2. On Windows platforms, the PATH environment variable must define the access path to database client programs (ODBC32.DLL). On UNIX platforms, check database client software documentation for environment settings (LD_LIBRARY_PATH, ldconfig).
  3. On Windows, check the SQL Server Client configuration with the Client Network Utility tool. Verify that the ANSI to OEM conversion corresponds to the execution of applications in a CONSOLE environment.
  4. Make sure the database client locale is properly defined. On UNIX platforms, check that the client character set parameter of the ODBC data source corresponds the locale used by the application (LANG/LC_ALL).
  5. On Windows, you can make a connection test with the Microsoft Query Analyzer tool. On UNIX, see client software documentation for available SQL command tools (isql command line tool for example).