MS SQL2005 Linked Server Setup for MySQL 7399
when I run the query: select * from openquery(TEST, 'select * from tb_alltypes')
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
i'm not an SQL guy. but please have a look here whether this has some thing helpfull you
http://support.microsoft.com/kb/314530
http://social.msdn.microsoft.com/Forums/eu/sqldatabaseengine/thread/73b84dec-d9c1-4a0d-9d1e-7c76646c909d
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/07fe6bf8-32a5-4d64-9819-5025ed5b3bd9/
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/74bec063-4057-4f52-bfd6-dad6352bdba2
http://support.microsoft.com/kb/314530
http://social.msdn.microsoft.com/Forums/eu/sqldatabaseengine/thread/73b84dec-d9c1-4a0d-9d1e-7c76646c909d
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/07fe6bf8-32a5-4d64-9819-5025ed5b3bd9/
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/74bec063-4057-4f52-bfd6-dad6352bdba2
I had to do these steps; on the sql box:
* install the mysql client odbc or oledb software (watch out if you have to install 32 or 64 bit!)
* if it was ODBC; I created a system DSN name in the appropriate ODBC tool (32 vs 64 bit); and use that name in the linked server config
* if it was OLEDB; I could just use the remote server name directly without the DSN
if you clarify your setup steps, we might be able to track down the issue
* install the mysql client odbc or oledb software (watch out if you have to install 32 or 64 bit!)
* if it was ODBC; I created a system DSN name in the appropriate ODBC tool (32 vs 64 bit); and use that name in the linked server config
* if it was OLEDB; I could just use the remote server name directly without the DSN
if you clarify your setup steps, we might be able to track down the issue
Premium Content
You need an Expert Office subscription to comment.Start Free Trial