Post reply

Facing probelm in Linked server

  • March 10, 2005 at 8:06 am

    #92626

    Hi to all,

    Sorry to Re-post it Again: By mistake I  posted this probelem in DTS topics, And I guess this is the right place for this problem. PLz forgive for the mistake

    Coming back to the problem:

    I am trying to make a Linked server of Mysql running on the same machine having MS sql server.

    I am using the following script:

    sp_addlinkedserver @server ='192.168.1.11' ,

    @srvproduct = 'MSDASQL' ,

    @provider ='MSDASQL' ,

    @datasrc = 'demomatch' ,

    @location ='192.168.1.11' ,

    @provstr = 'Driver={MySQL ODBC 3.51 Driver}' ,

    @catalog = 'demomatch'

    go

    where 192.168.0.11 is my IP on LAN and demomatch is the database present in both Mysqland Ms Sql server.

    I can c the the new linked server made in the linked server list but when I click on the tables, I receive error:

    error 7399: ole db provider 'MSDASQL' reported an error. Data source name not found and no default driver specified

    Any help?

    Regards

  • March 11, 2005 at 5:33 am

    #546583

    don't use a linked server, configure it as an ODBC subscriber - but SQL Server does not work with mysql - there is a bug.

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

  • March 11, 2005 at 10:05 pm

    #546758

    Thx for that,

    Well Hilary I have also tried using ODBC subscriber.

    The SQL server reports as:

    publisher Agent :

     1. A snapshot of 5 artilces was generated.

      2. 1 transaction with 18 commands was completed   sucessfully.

    Dustributor Agent:

     1. 1 transaction with 18 commands was completed   sucessfully

    And then all the agents become Idle. I guess that Replicated data has been posted by MS Sql server . But I cannot see the updations in the MYSQL database. I have tested the The ODBC connection it is working fine, and I guess there is no problem with the connection. So Y the Mysql is unable to receive the updations.

    Any Comment.

    Regards. 

     

  • March 11, 2005 at 11:11 pm

    #546759

    I have updated the ODBC driver, got a new copy from mysql.com.

    HUH..........It's Strange I am facing error :

          The publisher agent fails: "Invalid Cursor type "

    So Me getting anxious

    Plz help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply