Publishing to ODBC Subscribers

You must set up ODBC subscriptions by administering the publisher (that is, by using the push subscription model). You cannot set up ODBC subscriptions by administering a subscriber (the pull subscription model). For ODBC subscribers, the subscribing database has no administrative capabilities regarding the replication being performed.

    To publish to an ODBC subscriber
  1. From Control Panel, run the ODBC administration application and add the subscriber's data source name (DSN) as a system DSN.

    For more information about adding system DSNs, see the online Help for the ODBC administration application.

  2. Using SQL Enterprise Manager, configure the newly added system DSN as a subscribing server to the publishing server by choosing the New Subscriber button from the Replication - Publishing dialog box.

    The New Subscriber dialog box appears.

  3. From the New Subscriber dialog box, choose the ODBC Subscriber button.

    Complete the New ODBC Subscriber dialog box that appears.

    Note Only system DSNs are listed in the New ODBC Subscriber dialog box.

    For more information about completing the New ODBC Subscriber dialog box, see the online Help for SQL Enterprise Manager.

  4. While using SQL Enterprise Manager to create or edit a publication, perform a push subscription to the subscriber by choosing the Subscribers button from the Edit Publications or Edit Article dialog box. Complete the dialog box that appears.

    For more information about push subscribing, see the Microsoft SQL Server Administrator's Companion.

Note Replication creates tables on the ODBC subscribers by using quoted identifiers (for example, "authors" rather than authors). Some database query tools do not support objects created using quoted identifiers. Verify that your query tool supports quoted identifiers if you cannot view replicated tables.