I am trying to connect a VB application, Visual Studio 2017, using ADODB as connection, but it has several errors for different connection options. I have already checked the drivers for the ODBC data sources and there is the MySQL 64bit Driver ("MySQL ODBC 5.3 ANSI Driver" and "MySQL ODBC 5.3 Unicode Driver")
TRY 1:
Dim conn As New ADODB.Connection
Dim aux As String
aux = "Driver={MySQL ODBC 5.3 ANSI Driver}; server=localhost,3306; Database=db-teste; uid=root; pwd=123456; Option=3;"
conn.Open(aux)
ERROR FOUND: Data source name not found and no default driver specified '
ATTEMPT 2: After creating a new "User DSN" data source ("User DSN" tab of the data sources) with the name "ODBC-TEST Connection" and another System ODBC data source (under the "System DSN" tab) Connection_DB-TEST2 "and test both as follows, presented an error different from the previous one:
Dim conn As New ADODB.Connection
conn.Open("Conexao_DB-TESTE")
ERROR: The specified DSN contains an incompatibility of architectures between the Driver and the Application
I do not know what's wrong and I did not find other options. How do I connect to MySQL via ADODB?