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.