To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516
------- Additional comments from [EMAIL PROTECTED] Tue May 24 13:32:31 -0700 2005 ------- In short: yes, I installed v 3.51.11, but it didn't help. In extenso: Originally I had v. 3.51.07 of the ODBC-driver, so I replaced it by 3.51.11 So now in /usr/lib I have the new version installed: /usr/lib/libmyodbc3-3.51.11.so /usr/lib/libmyodbc3.la /usr/lib/libmyodbc3.so /usr/lib/libmyodbc3S-3.51.11.so /usr/lib/libmyodbc3S.la /usr/lib/libmyodbc3S.so /usr/lib/libmyodbc3_r-3.51.11.so /usr/lib/libmyodbc3_r.la /usr/lib/libmyodbc3_r.so /usr/lib/libodbc.so /usr/lib/libodbc.so.1 /usr/lib/libodbc.so.1.0.0 /usr/lib/libodbccr.so.1 /usr/lib/libodbccr.so.1.0.0 /usr/lib/libodbcextras.so.1 /usr/lib/libodbcextras.so.1.0.0 /usr/lib/libodbcinst.so /usr/lib/libodbcinst.so.1 /usr/lib/libodbcinst.so.1.0.0 /usr/lib/libodbcinstQ.la /usr/lib/libodbcinstQ.so /usr/lib/libodbcinstQ.so.1 /usr/lib/libodbcinstQ.so.1.0.0 and in /usr/lib/unixODBC: /usr/lib/unixODBC/libmyodbc3-3.51.07.so /usr/lib/unixODBC/libmyodbc3.la /usr/lib/unixODBC/libmyodbc3.so /usr/lib/unixODBC/libmyodbc3_r-3.51.07.so /usr/lib/unixODBC/libmyodbc3_r.la /usr/lib/unixODBC/libmyodbc3_r.so /usr/lib/unixODBC/libodbcdrvcfg1S.so.1 /usr/lib/unixODBC/libodbcdrvcfg1S.so.1.0.0 /usr/lib/unixODBC/libodbcdrvcfg2S.so.1 /usr/lib/unixODBC/libodbcdrvcfg2S.so.1.0.0 /usr/lib/unixODBC/libodbcminiS.so.1 /usr/lib/unixODBC/libodbcminiS.so.1.0.0 /usr/lib/unixODBC/libodbcmyS.so.1 /usr/lib/unixODBC/libodbcmyS.so.1.0.0 /usr/lib/unixODBC/libodbcnnS.so.1 /usr/lib/unixODBC/libodbcnnS.so.1.0.0 /usr/lib/unixODBC/libodbcpsql.so.1 /usr/lib/unixODBC/libodbcpsql.so.1.0.0 /usr/lib/unixODBC/libodbcpsql.so.2 /usr/lib/unixODBC/libodbcpsql.so.2.0.0 /usr/lib/unixODBC/libodbcpsqlS.so.1 /usr/lib/unixODBC/libodbcpsqlS.so.1.0.0 /usr/lib/unixODBC/libodbctxt.so.1 /usr/lib/unixODBC/libodbctxt.so.1.0.0 /usr/lib/unixODBC/libodbctxtS.so.1 /usr/lib/unixODBC/libodbctxtS.so.1.0.0 /usr/lib/unixODBC/liboplodbcS.so.1 /usr/lib/unixODBC/liboplodbcS.so.1.0.0 /usr/lib/unixODBC/liboraodbcS.so.1 /usr/lib/unixODBC/liboraodbcS.so.1.0.0 Trough /etc/unixODBC/odbcinst.ini I think I activated the correct version: [MySQL] Description = ODBC Driver voor MySQL Driver = /usr/lib/libmyodbc3.so Setup = /usr/lib/libodbcmy3S.so FileUsage = 1 CPTimeout = CPReuse = [MySQL ODBC 3.51 Driver] DRIVER = /usr/lib/libmyodbc3.so SETUP = /usr/lib/libmyodbc3S.so UsageCount = 1 Result of this all is the same... ====================================================== Off this topic, but maybe releated: Curiously enough I discovered that the problem doesn't show up with *all* my MySql databases: several of them show the field names in the forms wizard. But then, when I try to use the form to acces the database, it shows it as read-only, while the user has all rights to the database granted, and in the forms wizard I didn't choose a read-only version. On yet another database the form is according to the title bar is also read-only, but it is in fact possible to create a new record *IN THE FORM*. But when trying to save this new record to the database, the forms complaints ----------------------------------------------- SQL Status: HYT00 Error code: 1136 Column count doesn't match value count at row 1 ----------------------------------------------- while all the columns are filled, with as the one exception an autofill field, which in the form field is recognized as such. Is the exact SQL-statement generated for a save to the database reproducable? ============================================================================= hope this helps a little... kind regards, jehojakim --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
