Cannot use sqlite with Openoffice-bin 2.2: bad libodbc.so.1

[rollingstone]

amd64

I gives me "Could not load teh program library libodbc.so.1 or it is corrupted. The ODBC data source selection is not available" When I try to Browse to the db in
the oocalc db connection dialog.

* app-office/openoffice-bin 2.2.1
* dev-db/unixODBC 2.2.12
* dev-db/sqliteodbc 0.70
* dev-db/qt-unixODBC 3.3.8

/etc/unixODBC/odbcinst.ini
[SQLite]
Description=SQLite ODBC Driver
Driver=/usr/lib64/libsqliteodbc.so
Setup=/usr/lib64/libsqliteodbc.so

/etc/unixODBC/odbc.ini
[mysqldb]
Description=My SQLite
Driver=SQLite
Database=/tmp/sqldb.db

Any ideas?
Thanks

[DaggyStyle]

amd64

I gives me "Could not load teh program library libodbc.so.1 or it is corrupted. The ODBC data source selection is not available" When I try to Browse to the db in
the oocalc db connection dialog.

* app-office/openoffice-bin 2.2.1
* dev-db/unixODBC 2.2.12
* dev-db/sqliteodbc 0.70
* dev-db/qt-unixODBC 3.3.8

/etc/unixODBC/odbcinst.ini
[SQLite]
Description=SQLite ODBC Driver
Driver=/usr/lib64/libsqliteodbc.so
Setup=/usr/lib64/libsqliteodbc.so

/etc/unixODBC/odbc.ini
[mysqldb]
Description=My SQLite
Driver=SQLite
Database=/tmp/sqldb.db

Any ideas?
Thanks

have you tried revdep-rebuild?

[Dinini]

Warning, I haven't played with odbc on unix 64bit for several years, this may be wrong.

Possibly a stupid question, shouldn't [mysqldb] actually be [mysqlitedb] ? (i configured it that way when I used unixodbc in a different distribution)

amd64

I gives me "Could not load teh program library libodbc.so.1 or it is corrupted. The ODBC data source selection is not available" When I try to Browse to the db in the oocalc db connection dialog.

openoffice-bin is a 32bit program, you can't directly access lib64 shared libraries (which is what you have compiled). I think you may need to compile openoffice (64bit) so that your connection will work.

[rollingstone]

Thanks. I will try to rebuild openoffice later. For now I use koffice.