| 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 | |
[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. Thanks, --Narges
[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.
Description: 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. Thanks, --Narges 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.