Unisys Linked Server

The SQL Server system that FaxAction is running is required to have a link to the Unisys database through SQL Server’s linked server functionality. The linked server is required to support both the basic system and remote accounts functionality.

Please refer to the SQL Server Books Online for detailed information on how linked servers are configured and operate.

The Unisys linked server can be managed either through standard SQL Server functionality or through FaxAction Admin. When managed through Admin, the linked server id is specified in the custom stored procedure sp_fa_set_remote_system. The linked server id is usually FaxActionRemote.

To manage the linked server in Admin, press the Linked Server button in the Systems record for the appropriate system. The Linked Server button will only be displayed if the Unisys system type is selected. After the button is pressed, the following form is displayed:

The Product field specifies the type of database running on the remote system. This should be set to Oracle.

Provider contains the type of OLE DB provider that is used to communicate with the remote system. This should be set to MSDAORA. Note that SQL Server does NOT use ODBC to communicate with the Oracle database.

The Oracle service name, as configured on the FaxAction server, is specified in the Data Source field. This service must be configured with the Oracle connectivity tools to use the correct database and connect to the correct server. It is strongly recommended that the connection to the service be tested using an Oracle tool.

The name of the Oracle database user that SQL Server is to log onto the database as is contained in the User field.

The database user’s password is specified in the Password field.