Link to home
Start Free TrialLog in
Avatar of Emilio Morimoto
Emilio Morimoto

asked on

Problem for Access MySql via ODBC on Windows 7 64-bit

Hello, Experts.

I have the following problem: I usually set up an ODBC connection on a machine running Windows 7 64-bit. I do the test successfully.

However, when I try to access via application (VFP-9), gives connection error.

It also returns an error when I run the command in interactive mode (SQLConnect).

Any ideas?

Translate from portuguese:

" Olá, Experts.

Tenho o seguinte problema: eu configuro normalmente uma conexão ODBC numa máquina com Windows 7 64 bits. Faço o teste com sucesso.

Porem, quando eu tento acessar via aplicativo ( VFP ), dá erro de conexão.

Também retorna erro quando executo o comando no modo interativo ( sqlconnect ).

Alguma idéia? "
Avatar of IanTh
IanTh
Flag of United Kingdom of Great Britain and Northern Ireland image

have you got the code thats using the odbc

I think the test is internal whereas your code is external

do you get anything else in event viewer
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Emilio Morimoto
Emilio Morimoto

ASKER

Sorry for the delay.

I did the replacement for the 32 driver and it worked. Thank you.

But let me add: it works also with an older driver 64 (MySql-connector-odbc-5.1.6-win64.msi)