Solved

MS SQL2005 Linked Server Setup for MySQL 7399

Posted on 2012-12-28
2
376 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 142

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

705 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now