I installed MySQL 5.1 odbc 64-bit, 32-bit, mariadb driver to no avail, keep getting the same error.
Cannot initialize the data source object of OLE DB provider 'MSDASQL" for linked server MARIADBLINKED
OLDE DB Provider "MSDASQL" for linked server "MARIADBLINKED" returned message
"Microsoft" [ODBC Driver Manager] Data source name not found and no default driver specified".
(Microsoft SQL Server, Error: 7303)
I googled all the resolution and tried but still getting the same error.
ODBC MariaDB connection was successful.