MySQL Bugs: #15042: [MySQL][ODBC 3.51 Driver][mysqld-4.1.13-nt] Table ‘odbc.xxx’ doesn’t exist

Bug #15042	[MySQL][ODBC 3.51 Driver][mysqld-4.1.13-nt] Table ‘odbc.xxx’ doesn’t exist
Submitted:	18 Nov 2005 4:35	Modified:	29 May 2013 6:19
Reporter:	Juan Pablo Aviña Macias	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	3.51.12	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
I'm trying to create a 'remote view' in Visual FoxPro 6, but when I get the list of tables in the database, and I select the desired table, y get an error:

[MySQL][ODBC 3.51 Driver][mysqld-4. 1.1 3-nt] Table ‘odbc.xxx’ doesn’t exist

where 'xxx' means the name of the table. I don't know why MyODBC change the name of the database with the user's name in the driver. 

My system:
Visual FoxPro 6.00.8961 (SP 5)
Windows XP Home SP2
MySQL ODBC Driver 3.51.12
MySQL Server 4.1.13-nt

Configuration of MySQL ODBC Driver:
Server: localhost
Database: neptuno
User: ODBC
Pasword:

How to repeat:
Try to create a remote view in Visual FoxPro from the 'New' button in the project manager or 'File' menu, then select the conection and when you try to select the table... 

Suggested fix:
This problem don't ocurr when you use the "CREATE SQL VIEW" command in Visual FoxPro, or when you use the Wizard.

Hi Juan and thanks for your report. We appologize for the delay, somehow this report got neglected...

As VisualFoxPro is not free I am unable to do tests. If you can, please do the following:
 - Upgrade to MyODBC 3.51.14
 - Write standalone test case
Please inform me of your result.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.