Error 7303 Linked Server Mysql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring microsoft sql server error 7303 mysql developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Msdasql Error 7303
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them;
Sql Error 7303 Linked Server Oracle
it only takes a minute: Sign up Linked servers - SQL2008 to MySql - error: 7303 - Data source up vote 0 down vote favorite 1 Problem: I use SQL Server 2008. We have here a linked server, linking
Sql Server 2005 Linked Server Mysql
to a MySql Database. But since today, when I click "test connection", it shows me this error: ( I can't post images yet): The test connection to the linked server failed. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MANTIS". OLE DB provider "MSDASQL" for linked server "MANTIS" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303) What should I do? It create linked server mysql was working yesterday. I thought about "data sources ( ODBC)". Yes, There is no DataSources for MySql ( it doesn't even show me the option to add a mySql odbc when I click ADD), but it was working yesterday !! I didn't find a reasonable solution from any post. mysql sql datasource share|improve this question edited Dec 21 '14 at 0:15 bummi 22.7k83462 asked Nov 28 '14 at 15:37 Rafael Piccinelli 12619 If it is solved why did you post ??? What you want to know ??? –Altius Nov 28 '14 at 15:42 What? it's not solved. it was working "yesterday". not today. –Rafael Piccinelli Nov 28 '14 at 15:44 Ahh Ok. Let me check. –Altius Nov 28 '14 at 15:46 did you try all the solutions available in Stackoverflow. Nothing is working? –Altius Nov 28 '14 at 15:54 Solved!! See edit on post... –Rafael Piccinelli Nov 28 '14 at 17:19 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote answer, taken from the question Restart server + Install MYSQL ODBC DRIVER 51 ( MySql connector ) Start - control panel > Administrative Tools > Data Sources (ODBC) > System DSN > ADD MySql ODBC 501 Driver share|improve this answer answered Dec 21 '14 at 0:14 community wiki bummi add a comment| Your Answer draft saved draft discarded Sign up
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us linked server mysql to sql 2012 Learn more about Stack Overflow the company Business Learn more about hiring developers or linked server mysql to sql 2008 posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a linked server to mysql database question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: http://stackoverflow.com/questions/27191909/linked-servers-sql2008-to-mysql-error-7303-data-source Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Add linked server from SQL-Server to MySQL: “Data source name not found” (Error:7303) up vote 0 down vote favorite I'm trying to link my SQL-Server 2005 on Windows Server 2008 R2 with MySQL 5.5.40 on a different computer. I have followed this guide: http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/ However, when i try to http://dba.stackexchange.com/questions/90539/add-linked-server-from-sql-server-to-mysql-data-source-name-not-found-error test the connection under "Linked Servers" as you can see in this screenshot: i'm getting this error: The ODBC data source was added as shown in above link as you can see here: What can be the reason for this? Note that the Server2008 is a 64bit OS, if that matters. sql-server mysql sql-server-2005 mysql-5.5 windows-server-2008-r2 share|improve this question edited Jan 29 '15 at 12:17 asked Jan 29 '15 at 11:08 Tim Schmelter 324317 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted The ODBC Connection needs to be a System DSN. The connection is made as the service account, not you, and so the service account doesn't know about your User DSN. From the article: Select the System DSN tab to configure a data source for the entire system. share|improve this answer answered Jan 29 '15 at 12:40 bmckuhen 491 Thanks, i've realized it already. But i've still problems to connect. Maybe you know why. I get "access denied" and "using password no" which indicates that the password defined in the ODBC data source is not even used in MySql. Do you have an idea why? Because if i click "Test" in the MySql
being completely proprietary, one of the nice connectivity features offered in SQL Server is the ability to query other servers through a Linked Server. http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/ Essentially, a linked server is a method of directly querying another RDBMS; this often happens through the use of an ODBC driver installed on the server. Fortunately, many popular databases provide this ODBC driver, giving SQL Server the ability to connect to a wide range of other systems. I've already written about how to connect Oracle and SQL Server. linked server In this post, I'm going to go through the steps necessary to connect SQL Server and MySQL. The first step is to fetch an appropriate MySQL Connector/ODBC 5.1 download. Drivers are available for a variety of OS‘s, but we're obviously focused on Windows or Window x64, which should correspond to the version of SQL Server installed. After you've linked server mysql downloaded and installed the driver, we have a few things to configure, so let's get started: Configure a MySQL DSN The first step is to configure a MySQL data source by running the ODBC Data Source Administrator. This step is technically entirely optional, but allows a simpler configuration in the SQL Server Linked Server settings. Instead of composing a complicated MySQL connection string, we can use a simple GUI application. Run odbcad32 If you're using Windows Server 2003, bring up a Run dialog box with Start→Run or WinKey+R. If you're using Windows Server 2008, use the Start Menu search box directly. In either OS, type in "odbcad32" and hit Enter. System DSN Select the System DSN tab to configure a data source for the entire system. If you only want to create the DSN for a specific user (such as your service account), use the User DSN tab. In either scenario, select the "Add…" button. Create New Data Source Scroll down in the Create New Data Source window and select "MySQL ODBC 3.51 Drive