server with MySQL

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!

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.