To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=73636
Issue #|73636
Summary|Cannot create tables with ODBC
Component|Database access
Version|OOo 2.1
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|hesu2
------- Additional comments from [EMAIL PROTECTED] Thu Jan 18 12:16:38 -0800
2007 -------
I'm using Base in OOo 2.1 on XP professional with an ODBC connection
to a Mimer (9.2.5B) database.
I can edit existing tables, but I cannot create new tables. I get an
error dialog.
+ Error while saving table design
+ [Mimer][ODBC Mimer Driver][Mimer SQL]Syntax error, '(' ')' assumed missing
This is followed by ~50 small squares interspersed with a few question marks.
(I'll attach i picture).
Turning on the logging functionality of the RDBMS I found that all column types
were replaced by NATIONAL VARIABLE CHARACTER without any size arguments (hence
the missing parameters).
I've tested creating tables both with "Use Wizard to Create Table" and "Create
Table in Design View..."
This seems to be very fundamental.
---------------------------------------------------------------------
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]
