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] Thu Jun 9 16:25:58 -0700 2005 ------- Hi Marc, The contents of my ~/.odbc.ini is: ----------------------------------------------- cat ~/.odbc.ini [MySQL-adressen] Description = MySQL database adressen Driver = MySQL Server = localhost Database = adressen Port = 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt = [MySQL-BBG] Description = MySQL database Brassband Gelderland Driver = MySQL Server = localhost Database = BBG Port = 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt = [MySQL-video] Description = MySQL database videobanden Driver = MySQL Server = localhost Database = videos Port = 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt = [MySQL-kokenfoarried] Description = MySQL database kokenfoarried Driver = MySQL Server = localhost Database = kokenfoarried Port = 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt = ------------------------------------------------------- The most offending item is the first, the Adressen table. But what lib is used is not stated in ~/.odbc.ini, am I right? The output of the 'Describe table'-command in mysql: ------------------------------------------------------- mysql> use adressen; Database changed mysql> show tables; +--------------------+ | Tables_in_adressen | +--------------------+ | naw | +--------------------+ 1 row in set (0.02 sec) mysql> describe naw; +---------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------+------+-----+---------+----------------+ | volgnr | smallint(4) | | PRI | NULL | auto_increment | | voornaam | varchar(10) | | | | | | tussenvoegsel | varchar(7) | YES | | NULL | | | achternaam | varchar(15) | | | | | | adresnaam | varchar(50) | | | | | | straat | varchar(30) | | | | | | nummer | tinyint(3) | | | 0 | | | bis | char(3) | YES | | NULL | | | postcode | varchar(8) | | | | | | plaats | varchar(15) | | | | | | staat | varchar(15) | YES | | NULL | | | land | varchar(15) | | | | | | tel priv� | decimal(10,0) | | | 0 | | | mobiel | decimal(10,0) | YES | | 0 | | | tel werk | varchar(10) | YES | | NULL | | | e-mail | varchar(30) | YES | | NULL | | +---------------+---------------+------+-----+---------+----------------+ 16 rows in set (0.03 sec) ------------------------------------------------------------------------- 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]