On Friday 14 October 2005 01:24, J.L. Blom wrote:
> Hi,
> However when I want to test the database (File -> wizard -> Address Data
> Source -> Other(etc) -> Settings -> MYSQL (ODBC) -> Browse) I get
> perfectly "MySQL-test" which is the database I want.
I think the reason you can see the database is because OOo only reads the data
source names from you .odbc file, which is a simple text file so no problem.
> However, when I
> enter the correct user-name en click on the "test" button I get:
> " [unixODBC][Driver Manager]Can't open lib
> '/usr/lib64/libmyodbc.so' : /usr/lib64/libmyodbc.so: cannot open shared
> object file: No such file or directory".
> I can assure you that the library exists. I have the nagging feeling
> that this is a 64 bit problem as some other programs also have problems
The reason you can't access it is because OOo is a 32-bit app, and as far as I
know, the problem of apps loading dynamic libraries of different word sizes
has not been resolved. I also had it confirmed on another list that the
dlopen routine which accesses the files has only the one error message ('No
such file or directory') regardless of the actual 'error' condition that
exists.
The only way round it that I found was to drop ODBC, and use the JDBC-MySQL
driver instead, though the definition of the data source in OOo is rather
tricky.
--
Cheers,
TonyB
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
