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.
COURSE of the MONTH
12 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS SQL2005 Linked Server Setup for MySQL 7399
Posted on 2012-12-28
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active 2 days ago
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
Active 1 day ago
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3.
When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction
This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month12 days, 7 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.