Preparing the federated server to access data sources through ODBC (Windows)
Federated servers that run on Windows must be able to access ODBC data sources. To prepare the federated server, you must verify the settings in the ODBC System DSN.
Procedure
Verify that the ODBC 3.x driver has been installed and
configured on the federated server. You are strongly recommended to
download and install ODBC driver manager from Microsoft and specified
ODBC driver from data source vendors.
The node name for the ODBC data source must be defined in the System DSN. See the ODBC driver documentation for the installation and configuration procedures.
The
node name will be used to create server. For example:
CREATE SERVER server_definition_name TYPE data_source_type VERSION version_number WRAPPER wrapper_name OPTIONS (NODE 'Data_Source_Name', CODEPAGE 'codepage_name',DBNAME 'database_name');See Register the server definitions for an ODBC data source for details about registering server definitions.
If you used the Microsoft ODBC Data Source Administrator window to configure the DSN, you can check this setting in the Control Panel. Ensure that ODBC data source is registered as a System DSN. Otherwise the federated server might not be able to find the DSN.