MySQL ODBC Driver 3.51

[RandyRiegel]

I just started a project which uses MySQL backend. Everytime I try to connect to a remote view, via the designer or code VFP crashes. This happens on VFP6SP5 and VFP8SP1. If I download an older driver from mysql.com it works fine. Has anybody else had any trouble using this driver with VFP?

Randy

 

[Mike Gagnon]

No, I use that driver on a daily basis, I don't encounter this problem.
Can you post your code, maybe there is something there.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Randy,

You need to find out if the problem is in VFP (either yur code or something in the environment), or in the driver.

To find out, try using the driver with another ODBC client --a data source in Word's mailmerge, or an import source in Access, in Crystal Reports, or something similar.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[RandyRiegel]

I can't get it to work on anything. Two different machines same problem. How are you setting it up in ODBC settings? User or machine DSN? I get an error when trying word mail merge about "Not being able to determine driver".

 

[RandyRiegel]

If I create a machine or user DSN it will connect to the database and let me choose the table. I can click on the test button when creating the DSN and it says connection successful. But if I try to use it in anything I get:

"Could not determine driver name so could not lookup setup library"

Any ideas? I downloaded and installed this on two machines with same problems. Am I not setting something up correctly?

Randy

 

[Mike Gagnon]

Randy,

In order to create a "proper" ODBC connection, you have to logged in as an administrator.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[RandyRiegel]

I am configuring it as an administrator. And like I said, it tests fine when in the "ODBC Data Source Administrator". It just won't work in my applications.

Randy

 

[RandyRiegel]

I think it is a MyODBC 3.5.1 driver problem. I was looking in MySQL forum also, and another person is getting the SAME EXACT symptoms as me but with other programs (Visio, Excel, etc.) They test out fine in administrator but do not work when actually put to use. Mabey there is something wrong with the currently download.

Randy

 

[tatin]

Hey, I have realized that the connection string for MySQL ODBC Driver 3.51 is different from those of previous drivers. I think that may be your problem. For Example 2.50 takes user passwords as PWD=yourpassword and 3.51 takes it as PASSWORD=yourpassword.

Check out this site:

http://www.connectionstrings.com/