ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
5 days, 20 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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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…
INTRODUCTION:
While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses
Course of the Month5 days, 20 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
707 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.