MySQL Forums
Forum List  »  Connector/ODBC

Re: SSMS Linked Server Connection Issue
Posted by: Bogdan Degtyariov
Date: December 06, 2021 01:32AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: SSMS Linked Server Connection Issue
December 06, 2021 01:32AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.