Issue 32868 - Cannot edit MySQL tables
Summary: Cannot edit MySQL tables
Status: CLOSED WONT_FIX
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: christoph.lukasiak
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2004-08-12 05:46 UTC by dongcalmada
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dongcalmada 2004-08-12 05:46:32 UTC 
Everytime I open tables on Data Sources panel (after successfully logging in),
all tables are shown read-only. I, therefore, cannot update, insert, delete records.

But I can enjoy all my privileges using MySQL client and iodbctest (which uses
the same .odbc.ini). With iodbctest, I can do all I can on MySQL client.

I even tried a work-around macro published on OOoForum (touted to resolve this
'readonly' problem), but to no avail.

Here are applications/packages installed:

OpenOffice 1.1.2
MySQL-server 4.1.3-0, etc.
MyODBC 3.51
iODBC

- end of issue -
Comment 1 Frank Schönheit 2004-08-25 14:17:05 UTC 
correcting priority according to
http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority
Comment 2 christoph.lukasiak 2004-09-13 15:44:53 UTC 
mine
Comment 3 christoph.lukasiak 2004-09-13 15:54:17 UTC 
clu->dongcalmada: this seems to be a known bug in the MyODBC 3.5 driver (do not
fit to odbc standard) - may you try to create a new data source connection from
type: MySQL (not ODBC! - also in the listbox by choosing database type) - in
core it is odbc too, but it ignore some invalid responses from the driver - this
should work: can you acknowledge that?
Comment 4 christoph.lukasiak 2004-12-08 13:21:10 UTC 
no respond - problem seems to be fixed