Testing the connection to the ODBC data source server
Test the connection to the ODBC data source server to determine if the federated server is properly configured to access ODBC data sources.
About this task
You can test the connection to the ODBC data source server by using the server definition and the user mappings that you defined.
Open a pass-through session and issue a SELECT statement on the ODBC data source system tables.
If the SELECT statement returns a count, your server definition and your user mapping are set up properly.
SET PASSTHRU server_definition_name SELECT count(*) FROM schema_name.table_name SET PASSTHRU RESET
If the SELECT statement returns an error, you should troubleshoot the connection errors
After you complete this task, you can register nicknames for the ODBC data source tables and views.