Re: SSMS Linked Server Connection Issue

[Bogdan Degtyariov]

Two things:

1. If you have a DSN already created you can just give the connection string like this:

DSN=my_dsn_name

2. if you want to specify the driver name using DRIVER= it must be done in the curly brackets {} like this:
DRIVER={MySQL ODBC 8.0 ANSI Driver};....

Using parentheses () is incorrect because the system ODBC driver manager treats them as part of the driver's name.