Bug #11291 'VIEWS' not working while connecting to MySQL in Linux from MS Access ODBC
Submitted: 13 Jun 2005 16:01 Modified: 28 May 2013 10:50
Reporter: narges Email Updates:
Status: Closed Impact on me:
Category:Connector / ODBC Severity:S2 (Serious)
Version:MySQL 5.02 OS:Any (Unix/Linux)
Assigned to: CPU Architecture:Any

[13 Jun 2005 16:01] narges
I am running Windows 2003 Access, MyODBC 3.51.11 on PC to connect to a database in MySQL 5.02 in Unix. I can link tables from a MySQL database to Ms Access.

There are some 'view tables' in the MySQL database. When I look at them from Access and double click on those tables in Access, it shows the original tables not the views.


How to repeat:
-create a view table in your database (in MySQl 5.02 server in Linux).

      Example :
                 create view item_view as (select * from items where unit='GSE')

-Make a connection via MyODBC 3.51.11 in MS Access to the server and try to open
the view table (item_view).

- You would  see the original table (items) and not the view table (item_view).

Suggested fix:
Apparently the SQLs written in MySQL server for the view tables can not be translated/run in MS Access connected to the MySQL server via MyODBC.
[15 Jun 2005 7:38] Vasily Kishkin
I was not able to reproduce the bug on mysql 5.0.7. Could you please upgrade your version of mysql ?
[15 Jun 2005 17:12] narges
Dear Vasily Kishkin,

Do you think it is a problem with MySQL server. I checked the view tables by connecting to the server via JDBC in DBvisualizer and the views worked. So I 
thought there is some thing wrong with ODBC and etc.
Let me know if you still think that we have to upgrade our server.

[20 Jun 2005 8:04] Vasily Kishkin
I would like to say the bug might be fixed in 5.0.7. Could you please set up new version of mysql server and try to reproduce the bug ?
[20 Jul 2005 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".
[28 May 2013 10:50] 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.