Error creating Linked Server with MySQL

0

I am trying to create a Linked Server in SSMS to access a MySQL database. I installed and configured the driver to make this connection, it tested and it worked normally, but at the time of creating the linked server, I am getting the error below: >

  

AnexceptionoccurredwhileexecutingaTransact-SQLstatementorbatch.

    

CannotinitializethedatasourceobjectofOLEDBprovider"MSDASQL" for linked server "EC-DATABASE".

     

OLE DB provider "MSDASQL" for linked server "EC-DATABASE" returned message [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified ".

     

(Microsoft SQL Server, Error: 7303)

I am using SSMS (32bit) along with ODBC (32bit) and Windows Server 2012 R2 (64bit) OS. As it appears in the screenshot, I can usually test the connection to the database, but I can not create the linked server.

    
asked by anonymous 02.08.2018 / 17:06

0 answers