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

Emilio Morimoto
Emilio Morimoto used Ask the Experts™
on
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? "
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
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
VFP requires 32 bit ODBC driver. Install it and try again.
Emilio MorimotoProgramador

Author

Commented:
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)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial