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 sort of SQL Server drivers:
    • The SNC driver is based on the SQL Server Native Client ODBC driver (SQLNCLI*.DLL). The version of the SQL Server Native Client must match the ODI driver.
    • The FTM driver is based on the FreeTDS ODBC driver (libtdsodbc.so). This driver can be used if you want to connect to SQL Server from a UNIX™ machine.
    • The ESM driver is based on the EasySoft ODBC driver (libessqlsrv.so). This driver can be used if you want to connect to SQL Server from a UNIX machine.
  2. On Windows™ platforms, the PATH environment variable must define the access path to database client programs (ODBC32.DLL). On UNIX/Linux 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/Linux 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/Linux, see client software documentation for available SQL command tools (isql for example).