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:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.12 OS:Microsoft Windows (Windows XP SP2)
Assigned to: CPU Architecture:Any

[18 Nov 2005 4:35] Juan Pablo Aviña Macias
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

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.
[21 Mar 2007 11:24] Tonci Grgin
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.
[21 Apr 2007 23:00] Bugs System
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".
[29 May 2013 6:19] Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.