0
I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL Server 2008 (Virtual Machine, 64-Bit). I would to create a New System DNS in the ODBC Data Source Administrator Menu. Furthermore I enter the Connection Data from the MYSQL Server (IP-Adress, User, Password, etc.) and hit "Test". After I hit "Test" I get a few seconds later "No Response" and the Mysql Connector Window crashes. Do you know any solution or anything that I can do, to solve this issue? Thanks in Advance.
/edit: After some testing I get finally an error Message with the Result:
Connection Failed: [08S01] [MySQL][ODBC 5.1 Driver] Lost connection to MySQL server at 'reading initial communication packet', system error: 0
Does this help?
triplus
Posted 2015-01-05T14:47:54.547
Reputation: 1
After some testing I get finally an error Message with the Result: – None – 2015-01-05T15:18:52.247
Could you please include things that you tried for solving this issue? Are you sure about firewall exception? – Renju Chandran chingath – 2015-01-24T16:08:28.197
@triplus It seems you found a solution on your own. Great! Please put that as an answer and not as an edit in your question and accept your own answer.
– agtoever – 2015-01-29T11:21:12.437