question

ecomma avatar image
ecomma asked

Error in creating linkedserver between MSSQLSERVER AND MYSQL

Am trying to create a connection between mysqlserver(version 5.2 community server) and MYSQL SERVER 2008R2.I install odbc drivers 5.2 for mysql and created the odbc connection called:MYSQL and productionName MYSQL. The provider string: DRIVER={MySQL ODBC 5.2 Driver};SERVER=localhost;PORT=3306;DATABASE=mydbname; USER=defaut;PASSWORD=mypassword;OPTION=3; I provider the default login credential i using in mysql workbench in the remote longin credential under the security tab. but i still get this error: The linkserver has been created but failed a connection test. Additional information: Name Pipes Provider:Could not open a connection to Sqlserver[53] OLEDB provider "SQLNCLI10:for linked server"MYSSQL_MSSQL_CONNECTION" retuned message "login timeout expired' "A network-related or instance specific error has occurred whilse establishing a connection to SQLSERVER. Server not found or accessible.
sql-server-2008mysqllinked server
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered
32-bit or 64-bit? Are you using the right drivers? Might be worth having a look at [ ConnectionStrings.com][1] [1]: http://www.connectionstrings.com/mysql#mysql-connector-odbc-5-1
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks @ThoasRuston.i did installed the right drivers.Now i get the link server created but connection to the mysqldb keep failing
0 Likes 0 ·
am using 32-bit,window 7.Both Mysql and MSSQL are installed on the same pc
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.