locked
Linked Server with MySQL RRS feed

  • Question

  • Hi,

    I have a problem , I created a linked server to mysql with following parameters:

    New linked server: ServerName

    Server Type: Other data Source: Microsoft OLE DB Provider for ODBC Drivers.

    In the Provider String:

    Driver={mySQL ODBC 3.51 driver};Server="ip";Port=3306;Option=17923;Stmt=;Database="database";Uid=root;Pwd="pwd"

    And I created a ODBC with mysql, and connection worked sucessfully!

    The connection worked corretly until I' ve running a transact query in sql query analyzer, thats connects to MySQL and...

    when I try to connect in SQL Server 2000 standard Ed. in linked Server, the following message appears to me now, and before this I was able to connect!

    Server: Msg 7399, Level 16, State 1, Line 11
    OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
    ODBC: Msg 0, Level 19, State 1
    SqlDumpExceptionHandler: Process 169 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
    OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x8000ffff:  The provider reported an unexpected catastrophic failure.

    The query just make a select in MySQL, but I think that broke something...

    What I have to do?

    reply to my email: daniel.sarnes@antilhas.com.br

    Thanks a lot!

    Wednesday, November 8, 2006 6:15 PM

Answers

  • I am not familiar with MySql. But if you create a linked server object inside MySql that points to SQL Server, you need to contact MySql to see if that is supported scenario.
    Tuesday, November 14, 2006 8:12 PM

All replies