Error opening MySQL connection via ADODB

2

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?

    
asked by anonymous 02.06.2017 / 03:38

1 answer

2

I've solved it. I downloaded the previous version of the MySQL driver, Connector / ODBC 5.2.7, to 32 bits, and recreated the DSN in "ODBC Data Sources (32-bit)" in Windows Administrative Tools 10. Driver Link

    
02.06.2017 / 15:19