Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Brazil
    Posts
    56

    Unanswered: Replication SQL 2000 to MYSQL

    Hello Guys,

    I'm trying to configure a Transactional Replication from SQL 2000 to MySql using MyODBC.

    The problem:

    When I try to add a new Subscriber, I receive the following message:

    'ODBCMYSQL' could not be enabled as a subscriber because the ODBC driver for this data source does not provide sufficient functionality. Contact the vendor to obtain an updated ODBC Driver.

    Error 2132: [SQL-DMO]The DSN is not a valid SQL Server Subscriber
    Diogo Hudson Dias
    DBA - SQL 6.5/7.0/2000
    ASBACE - ATP

  2. #2
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: Replication SQL 2000 to MYSQL

    You can't make MySQL replicate SQL Server. Replication only works MySQL to MySQL.

  3. #3
    Join Date
    Sep 2002
    Location
    Brazil
    Posts
    56

    SQL to MySql

    But,
    I'm Trying to replicate SQL 2000 Database to MySql 5
    Diogo Hudson Dias
    DBA - SQL 6.5/7.0/2000
    ASBACE - ATP

  4. #4
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: SQL to MySql

    Sorry about that. I have not set up heterogenous replication with SQL Server, but I do know that it will fail if Queued Updating or Immediate Updating are selected, it will fail. That is the extent of my knowledge on the subject.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •