Created attachment 66570 [details] Screen dump The connection is pooled by ODBC and exists
Fred : DUP of bug 54457 ? Alex
Does it crash ? Alex
On which env are you? Could you rename your LO directory profile and try again? (see http://wiki.documentfoundation.org/UserProfile)
Hi Fred, Any change that you help with the quesions, or is the problem resolved in the mean time? Thanks - Cor
Hello Cor, No and I have those problems not on my Windows version. I have also 3 rows instead of all the rows in the table and also that problem doesn't occur on the Windows machine. I think LibreOffice Base is not ment to run on a Apple. But I am open for suggestions..... Thanks Cor and have a Nice Christmas and a Happy New Year. Fred Bakker On 15-12-12 16:25, bugzilla-daemon@freedesktop.org wrote: > Cor Nouws <mailto:cno@nouenoff.nl> changed bug 54456 > <https://bugs.freedesktop.org/show_bug.cgi?id=54456> > What Removed Added > CC cno@nouenoff.nl > > *Comment # 4 <https://bugs.freedesktop.org/show_bug.cgi?id=54456#c4> > on bug 54456 <https://bugs.freedesktop.org/show_bug.cgi?id=54456> from > Cor Nouws <mailto:cno@nouenoff.nl> * > Hi Fred, > Any change that you help with the quesions, or is the problem resolved in the > mean time? > Thanks - Cor > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. >
(In reply to comment #5) ... > But I am open for suggestions..... Could you give a try to a newer version like 3.6.4? (3.6.1 is getting old) If you still reproduce this, could you rename your LO directory profile (see my previous comment https://bugs.freedesktop.org/show_bug.cgi?id=54456#c3) ? Finally, could you also give your Java version? (Base is very dependent on Java)
Hello, On the Apple I have Version 3.6.4.3 (Build ID: 2ef5aff), so that is the last version. How can I see which version of Java (run-time I supose) I have ? ODBC doesn't give that problem on the Apple, but with ODBC, I still get strange behavior. like: While I have: 267 records in the database table and I think it is also a Java problem. I don't have this problem on the Windows machine. I did use the normal installation of a downloaded .dmg Also it could be strange to have different versions of Java. I have also NetBeans 7.3 Beta on this machine. Julien I work also on a Dutch version of OS X version 10.8, so it is hard to find the directory's and I didn't find a user profile on the place you mentioned. Hopefully it gives you some ideas about this problem. I give computerlessons to 55 Plus (elderly) people and I would like to give them an alternative for Windows Office, also with Base in place of Access. By the way I have installed Version 3.6.4.3 (Build ID: 2ef5aff) on Windows and the problem is solved I think, so you can close the bug 54456, because the problems with the strange screen are gone on both machines. You all are very helpfull to try to solve this problem and I would like help you all to make LibreOffice a good alternative. Thanks in advance Fred Bakker On 15-12-12 18:33, bugzilla-daemon@freedesktop.org wrote: > > *Comment # 6 <https://bugs.freedesktop.org/show_bug.cgi?id=54456#c6> > on bug 54456 <https://bugs.freedesktop.org/show_bug.cgi?id=54456> from > Julien Nabet <mailto:serval2412@yahoo.fr> * > (In reply tocomment #5 <show_bug.cgi?id=54456#c5>) > ... > > But I am open for suggestions..... > Could you give a try to a newer version like 3.6.4? (3.6.1 is getting old) > If you still reproduce this, could you rename your LO directory profile (see my > previous commenthttps://bugs.freedesktop.org/show_bug.cgi?id=54456#c3 <show_bug.cgi?id=54456#c3>) ? > > Finally, could you also give your Java version? (Base is very dependent on > Java) > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. >
Fred Bakker: So trying to understand your feedback. - You had some problem with Windows but with last version they're gone. - You still have problems with MacOs but don't know where to find LO directory profile - Moreover, you don't know how to see Java version. So first, I update platform to Macos All. About profile, the important thing is this one: "For Mac users: /Users/<user name>/Library/Application Support/libreoffice/3/user Important: These folders are hidden, you need to enable the option from your operative system to see hidden folders in order to see them." About Java, just launch LO then go to Menu Options, then LibreOffice/Java and take a look to the version used. Don't hesitate to come on IRC #libreoffice on freenode.net and talk about this behaviour.
Hello, Yes, that is correct; I don't have the ODBC problem anymore, also the connection with a MySQL database did work. I did try the command below "/User......" I got this: First I treid to do cd Second I did ls of Library which was found and you can see what's inside The last one was a ls of a part of the mentioned path, but there is no LibreOffice inside. At the Java subject I found this and I suppose that this is what you are looking for. Which I found under "Preferences" and not under Options, but the heading is Options, so it's ok. I did connect and found http://download.documentfoundation.org/libreoffice/stable/3.5.2/win/x86/LibO_3.5.2_Win_x86_install_multi.msi which is not the correct one (I was downloading 3.6.4), but I got this message there Object not found! The requested URL was not found on this server. The link on the referring page <http://libreoffice.nl.portalux.com/download:p:mac> seems to be wrong or outdated. Please inform the author of that page <http://libreoffice.nl.portalux.com/download:p:mac> about the error. If you think this is a server error, please contact the webmaster <mailto:ftp@documentfoundation.org>. Error 404 download.documentfoundation.org <http://download.documentfoundation.org/> Sun Dec 16 19:44:22 2012 Apache And I did already give the webmaster a message about that. What is the purpose of freenode.net, because there is already a LibreOffice.org ? Greetings and thanks in advance Fred Bakker On 16-12-12 12:41, bugzilla-daemon@freedesktop.org wrote: > Julien Nabet <mailto:serval2412@yahoo.fr> changed bug 54456 > <https://bugs.freedesktop.org/show_bug.cgi?id=54456> > What Removed Added > OS All Mac OS X (All) > > *Comment # 8 <https://bugs.freedesktop.org/show_bug.cgi?id=54456#c8> > on bug 54456 <https://bugs.freedesktop.org/show_bug.cgi?id=54456> from > Julien Nabet <mailto:serval2412@yahoo.fr> * > Fred Bakker: > So trying to understand your feedback. > - You had some problem with Windows but with last version they're gone. > - You still have problems with MacOs but don't know where to find LO directory > profile > - Moreover, you don't know how to see Java version. > > So first, I update platform to Macos All. > About profile, the important thing is this one: > "For Mac users: > > /Users/<user name>/Library/Application Support/libreoffice/3/user > > Important: These folders are hidden, you need to enable the option from your > operative system to see hidden folders in order to see them." > > About Java, just launch LO then go to Menu Options, then LibreOffice/Java and > take a look to the version used. > > Don't hesitate to come on IRC #libreoffice on freenode.net and talk about this > behaviour. > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. >
Fred: you're mixing Win and MacOs elements. You must seperate both subjects to make it clear. 1) On Windows If you have still some remaining problems. Try a clean install, ie: - uninstall LO - clean your Windows registry with free tool (like ccleaner) - rename or delete (if you didn't customize anything) your LO directory profile Before Vista: \Documents and Setting\<user name>\Application Data\libreoffice\3\user From Vista: %appdata%\libreoffice\3\user - install last 3.6.4 version On Windows, what's your Java version (you can go to "add/uninstall softs" to know it) 2) On Mac It seems you have several versions. So idem: - uninstall every LO versions - rename or delete your LO directory profile /Users/<user name>/Library/Application Support/libreoffice/3/user - install last 3.6.4 version On Windows, what's your Java version Last thing: please, answer by adding a comment to the bugtracker here https://bugs.freedesktop.org/show_bug.cgi?id=54456 and not by answering the email automatically sent by bugzilla And again: distinguish the problems and actions you did on 2 platforms.
I don't have the problems in the Windows version anymore. I still have the silly problem of just 3 records instead of 187 record and just alone on the Apple iMac. Even with the 4.0.0 version !! At LODev-Advanced-Java I have 1.6_0_37 as Java Runtime version fro Apple Inc. Again: I don't have problems anymore with the Windows version.
Fred: thank you for your feedback and your patience. Alex/Roman: it seems it's a Mac Only bug, would you have some time to give it a try?
In what way Julien ? I am not in a hurry and I have other tools to go around.
(In reply to comment #12) > Alex/Roman: it seems it's a Mac Only bug, would you have some time to give > it a try? @ Alex: Can you please take this one? You are much more into Base than me ... ;-) Thank you!
@All : On the Mac, ODBC problems are not new, they have been around since the release of OOo 3.3.x, and consequently, since the creation of the LO project. https://bugs.freedesktop.org/show_bug.cgi?id=46237 It is not a Java problem. As LO is 32bit only on Mac, the user requires a 32bit driver. However, if you are using a recent version of OSX, which Fred doesn't mention, then you are stuck. OSX 10.7 and 10.8 come with mysql server 64bit pre-installed, which can only be talked to via a 64bit ODBC connector. The ODBC 64bit connector will not talk to LO and vice-versa. A simple test for this is to use isql from the command line. Now, on 32bit OSX systems, so Tiger (10.4), Leopard (10.5) and SnowLeopard (10.6) in 32bit kernel mode, the mysql ODBC driver and LO will talk to each other, but there is a bug somewhere in one of the pieces that means that means that either you will get a connection and no data, or else, dependent on mysql ODBC driver and iODBCAdmin version, you will get a connection that only shows the first 3 results of the resultset. Fred is lucky in so far as he can at least see the first 3 results. When I was testing this throughout LO 3.3.x development, I could only get a successful connection, but no data. Note that the ODBC driver supplied by MySQL in versions 5.x is buggy as hell, and is missing bits that are required for proper operation, such as the driver setup libraries... What Fred has failed to give us so far, at least for the Mac, is : Operating system info : OSX version MySQL ODBC Driver version : iODBCAdmin version (this is supplied by Apple) : MySQL server version and whether the server instance is local or remote : The location of his odbc.ini and odbcinst.ini files. Beware, there can often be 2 or more sets of these files on an OSX system, and Apple's "protective" configuration regime prevents the normal user from seeing these locations. I can not do testing because I'm on a 64bit kernel, with a 64bit local version of mysql, which requires the 64bit driver. This driver refuses to talk to LO, or LO refuse to talk to the driver - either way, it doesn't work for me at all. Ideally, if someone wanted to try and reproduce this, they would need an older version of the MySQL ODBC 32bit driver, running on a 32bit Mac OSX system, so Tiger or Leopard, or at a pinch and with some juggling, OSX 10.6. Alex
Yet another nail in the coffin for ODBC on OSX... @Fred : switch to the JDBC connector, at least it works... Alternatively, try the native mysql connector from the Apache OO project, which I think still continues to work with LO 3.6. I haven't been able to build the mysql native connector for Mac for about 6 months now, and there is no solution to that, other than to hope that the AOO project will keep supplying a working connector. This however, is potentially unlikely, with regard to version 4 of LibreOffice, since it was decided to allow incompatible changes in the LO code which might cause extensions to break, including the native mysql connector extension. Alex
Setting version to earliest release where problem first noted, i.e. 3.3.0 Alex
@ Alex Thurgood: Thank you very very much for your careful research and detailed explanation of this issue! Now at least we understand what’s going on here ...
Adding Lionel to CC
This works fine for me with mysql 5.1 odbc connector 64bit and LO 4.3.1.2 64bit TDF release
There is a newer version (5.3) of the odbc connector available from mysql - I haven't tested that yet.
@Fred : update to the latest 64bit versions as indicated and reconfigure your odbc.ini system dsn accordingly