MySQL 5 linked server on windows server 2008 and mssql2008

• bleifert

  SSC Rookie

  Points: 25

  More actions

  May 13, 2009 at 11:12 am

  #204927

  I'm attempting to setup a connection from sql2008 to mysql 5.

  mysql 5.1 odbc x64 driver installs fine.

  Datasource creates and tests successfully

  I can connect from the sql query browser on the 2008 server to the mysql server

  when I go into mssql and attempt to setup the linked server I get the error at the bottom of this post.

  all the connection info is in the odbc connector so I'm only specifying linked server name, produt name, data source, and catalog.

  Any help would be appreciated.

  TITLE: Microsoft SQL Server Management Studio

  ------------------------------

  The linked server has been created but failed a connection test. Do you want to keep the linked server?

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MONITORINGDB".

  OLE DB provider "MSDASQL" for linked server "REDACTED" returned message "[Microsoft][ODBC Driver Manager] Invalid connection string attribute".

  OLE DB provider "MSDASQL" for linked server "REDACTED" returned message "[MySQL][ODBC 5.1 Driver]Access denied for user 'USERREDACTED'@'IPREDACTED'(using password: YES)". (Microsoft SQL Server, Error: 7303)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476