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.
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).
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.
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).
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).