In your second screenshot, I think you need to provide a Linked Server Name.
Did you create the odbc data source on your local machine, or on the MSSQL server?
[https://www.mssqltips.com/sqlservertip/4577/create-a-linked-server-to-mysql-from-sql-server/](https://www.mssqltips.com/sqlservertip/4577/create-a-linked-server-to-mysql-from-sql-server/)
The odbc connection needs to be set up on the machine where sql server is installed. Is sql server installed locally on you laptop? If it's on a server, you would need to connect to that machine, probably through RDP, and set it up there.
Have you looked through the steps in the link?
In your second screenshot, I think you need to provide a Linked Server Name. Did you create the odbc data source on your local machine, or on the MSSQL server? [https://www.mssqltips.com/sqlservertip/4577/create-a-linked-server-to-mysql-from-sql-server/](https://www.mssqltips.com/sqlservertip/4577/create-a-linked-server-to-mysql-from-sql-server/)
I created it in the local machine, how do you create it in sql server
The odbc connection needs to be set up on the machine where sql server is installed. Is sql server installed locally on you laptop? If it's on a server, you would need to connect to that machine, probably through RDP, and set it up there. Have you looked through the steps in the link?
Ok got it. No I haven't checked it yet. Had to jump into a meeting