[mdb-dev] MDBtools + unixODBC + OpenOffice.org-1.1

[Luca C. <lu...@pc...>]

Hello,

I've the same problem as David Whiting, reported 2003/09/05 at 15:05, 
message title "mdbtools, unixodbc and openoffice.org".

Here what I did on my Debian testing/unstable, kernel 2.6.0-test9, 
apache-1.3.28 and php4-4.3.3, following the HOWTO at:
	http://www.unixodbc.org/doc/OOoMySQL.pdf

- apt-get install mysql-server > 4.0.13
- apt-get install unixodbc > 2.2.4
- apt-get install libmyodbc > 2.50.39
- tested MySQL and unixODBC working on OpenOffice.org
- added MDBtools to unixODBC:
   1) cat /etc/odbcinst.ini
	[MySQL]
	Description	= MySQL driver
	Driver		= /usr/lib/odbc/libmyodbc.so
	Setup		= /usr/lib/odbc/libodbcmyS.so
	CPTimeout	=
	CPReuse		=
	FileUsage	= 1

	[MSAccess]
	Description	= MDB Tools ODBC driver
	Driver		= /usr/lib/libmdbodbc.so.0
	Setup		=
	FileUsage	= 1
	CPTimeout	=
	CPReuse		=

   2) cat /etc/odbc.ini
	[MySQL-test]
	Description	= MySQL database test
	Driver		= MySQL
	Server		= localhost
	Database	= test
	Port		= 3306
  	
	[Tosi-general]
	Description	= Magazzino
	Driver		= MSAccess
	Database	= /home/luca/download/magazz.mdb
	Server		= localhost
	Port		= 5432

   3) cat /home/luca/.odbc.ini
	[Tosi-user]
	Description	= Magazzino
	Driver		= MSAccess
	Database	= /home/luca/download/magazz.mdb
	Server		= localhost
	Port		= 5432

- now I can add the 2 .mdb via "OpenOffice.org Data Sources" window, but
   I can't view tables, obtaining 2 differents errors:
   a) if I use above entry n.2) (named "Tosi-general"), I get this error
	SQL Status: 08001 > Error code: 1
	[unixODBC]Could not find DSN in odbc.ini
	The connection to the data source "Tosi-general" could not be
	  established.
      starting from a terminal, this is the line error
	Couldn't find DSN /home/luca/.odbc.ini in Tosi-general

   b) using above entry n.3) ("Tosi-user"), I don't have errors, but I
      can't see the tables and I don't have errors from OpenOffice.org,
      but from a terminal, this is the error
	Error at Line : syntax error near exec

- if I open the .mdb from "gmdb2" I can successfully see all the tables
   and values inside them, even the export function works (the same as
   from the command-line)

So, is there a possible solution?

Thx, bye,
Gismo / Luca