Ted,

Have you thought about dropping back one or two minor versions to an

earlier ODBC driver?

Is there a MySQL forum where you can post your findings? I wonder if the

new version of the MySQL ODBC driver was adequately tested?

Is there a way to run ODBC in a DEBUG mode that might provide additional

clues?

Malcolm

----- Original message -----

From: "Ted Roche" <tedroche@tedroche.com>

To: profoxtech@leafe.com

Date: Mon, 10 Jan 2005 15:58:17 -0500

Subject: Re: VFP to MySQL 4.1.8 via MyODBC: "Could not determine the

driver name"

Update: spent a day or two trying every variation of SQLStringConnect()

from VFP. The bad ones gave me "Access Denied." The really bad ones

crashed VFP. How rude!

I was able to connect to the database using a *User* DSN from xCase and

manipulate data. Haven't figured out how to get it to work from VFP.

Ted Roche

Ted Roche & Associates, LLC

http://www.tedroche.com

[excessive quoting removed by server]