I am using MySQL 5.0 with a MySQL ODBC connector version 5.0.0 and I can connect to a MySQL database through Foxpro 8 with a 'sqlconnect()' command. The connection returns a valid number and not '-1'. When I try to run a 'sqlexec()' command, I get an error:

Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources

The fact that I have a valid connection should mean I can execute 'sqlexec()' commands.

Does anyone know how to fix this?