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 Native Client ODBC driver (SQLNCLI.DLL).
This is the new driver to be used with SQL
Server 2005.
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 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).