[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
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 Jun 7 04:56:18 -0700 2005 --- Hi jehojakim, Can you please have a look in the file ~/.odbc.ini , what lib is used? What fieldname do you have in the table? can you please provide the output of the mysql command DESCRIBE TABLE . Thanks & Bye Marc - 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]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516 User clu changed the following: What|Old value |New value Assigned to|clu |msc --- Additional comments from [EMAIL PROTECTED] Tue Jun 7 03:29:45 -0700 2005 --- seems to be a problem with the unix-odbc? clu->msc: can you help further? - 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]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
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]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
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 02:54:41 -0700 2005 --- clu->jehojakim: may you try out, what fs has written & acknowledge? does this fix the problem? thx - 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]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
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] Wed May 11 03:56:51 -0700 2005 --- for the record: there were some issues reporting the same problem (I don't have the issue numbers at hand) on Windows. There, the reason was a defective ODBC driver (if I remember correctly, 3.51.10 was bad, 3.51.11 was good). - 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]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
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] Mon May 2 06:15:02 -0700 2005 --- Data source is MySql, v 4.0.21 - sorry, should have mentioned that in the first place. It's a very simple one-table database. There are 16 fields in the table. Connection wih Thunderbird or a OOo 680.1.9.95 spreadsheet doesn't have the problem. kind greetings, 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]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516 User clu changed the following: What|Old value |New value Assigned to|msc |clu Keywords| |needmoreinfo --- Additional comments from [EMAIL PROTECTED] Mon May 2 05:31:30 -0700 2005 --- clu->jehojakim: 1. to what kind of data source do you connect - what driver do you use? 2. have you the same effect with an other data source (not your odbc source)? thx - 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]
