Home Forums SQL Server 2005 Administering Linked server querying XML Column of MYSQL DB RE: Linked server querying XML Column of MYSQL DB

  • July 9, 2009 at 9:57 am

    #1022512

    I fixed it

    @server = N'MySqLLinkedserver',

    @srvproduct=N'mysqldb', @provider=N'MSDASQL',

    @provstr=N'Driver={MySQL ODBC 3.51 Driver};

    Server=myserver.com;UID=myuser;PWD=mypassword;Database=mydatabase;Option=3;'

    By changing option=8

    Regards

    Reddy