Solved

MS SQL2005 Linked Server Setup for MySQL 7399

Posted on 2012-12-28
2
395 Views
Last Modified: 2013-01-04
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.
0
Comment
Question by:HemlockPrinters
2 Comments
 
LVL 13

Accepted Solution

by:
upalakshitha earned 500 total points
ID: 38728798
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38732415
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
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question