Tony,
Thanks for the information. At least it's not a mysterious error but one
that is due to the C-code where apparently is forgotten to add the
64-bit platform. I assume it is an extra switch in the compiling stage
(at least if I remember correctly from my programming days).
I'll try the JDBC-driver, although I don't have experience with Java
other than as a plug-in in Mozilla/Firefox. Can you tell me where I can
find the MySQL-JDBC-some-version.rpm?
Joep
On Fri, 2005-10-14 at 09:13 +0100, Tony Bloomfield wrote:
> 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.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
