Registering the Microsoft SQL Server wrapper

You must register a wrapper to access Microsoft SQL Server data sources. Federated servers use wrappers to communicate with and retrieve data from data sources. Wrappers are implemented as a set of library files

Procedure

Issue the CREATE WRAPPER statement from the command line and specify the default name for the Microsoft SQL Server wrapper.

For example:

CREATE WRAPPER MSSQLODBC3;

Remember: When you register the wrapper by using the default name, MSSQLODBC3, the federated server automatically uses the appropriate Microsoft SQL Server wrapper library for the operating system that your federated server is running on.

If the default wrapper name conflicts with an existing wrapper name in the federated database, you can substitute the default wrapper name with a name that you choose. When you use a name that is different from the default name, you must include the LIBRARY parameter in the CREATE WRAPPER statement.

For example, to register a wrapper with the name sqlserver_wrapper on a federated server that uses AIX®, issue the following statement:

CREATE WRAPPER sqlserver_wrapper 
  LIBRARY 'libdb2mssql3.a';

The wrapper library file that you specify depends on the operating system of the federated server.

What to do next

After you complete this task, you can register the server definition.

Feedback