Steps to reproduce: * Open LibreOffice Base 3.3 rc1 * Select option "Connect to existing database" * Select item "ADO" * Click "Next" button * On the next window "Configure ADO connection" click "Browse" button The button do nothing. Expected: open ADO connection window. Cpu is 99% idle (no hang or high cpu usage) LibreOffice 3.3.0 OOO330m17 (Build:3) libreoffice-build 3.3.0.1 Windows XP SP3
This might be a silly question, but just to make sure, you do have an ADO database (whatever that is) and any required software so that you should have to in theory be able to connect to it?
I think ADO is an acronym from "ActiveX Data Object" (or have I misunderstood?) that is a library installed by default in every Windows XP (and later) box. I use ADO from my C# software to connect remote SQL Server databases... ADO is OK. I think "Browse" button do help on building the correct connection string to ADO resources... maybe the problem is that the button should be removed because effectively there is nothing to do
Created attachment 41057 [details] Ado Browse button
Created attachment 41058 [details] OleDB properties ADO can use OleDB provider to connect remote resources
Did this ever work in OOo ? Alex
Yes, in OOo 3.3rc1 works... and appear the second attachment (OleDB properties)
I can confirm it on win7 with LibO 3.3RC2, nothing happens when click on "Browse" button. It works in OOo 3.3RC8, can connect to MSSQL server with ADO.
Nothing happens, and when adding a correct connection string it returns an error message. LO3.3.3 XPsp3 No problem with OO3.2.1
Can someone test this on a recent Win LibO version, i.e. a nightly build ? There was apparently some confusion with the withdrawal of Adabas support, and I noticed that one of the commits actually removed the Ado build strings out of the build, but I think (from a commit I saw yesterday) that it has been sorted out again now. Alex
The problem still exists in Lib0 3.4.2 If needed, where can I download a nightly build? (In reply to comment #9) > Can someone test this on a recent Win LibO version, i.e. a nightly build ? > There was apparently some confusion with the withdrawal of Adabas support, and > I noticed that one of the commits actually removed the Ado build strings out of > the build, but I think (from a commit I saw yesterday) that it has been sorted > out again now. > > > Alex
(In reply to comment #10) > The problem still exists in Lib0 3.4.2 > If needed, where can I download a nightly build? > Ho hum, there don't actually appear to be any available at the moment...in theory they should be here : http://dev-builds.libreoffice.org/daily/ but the only ones I can see for Windows are 3.4.2 builds (i.e. the current 3.4.2 release) You can usually check the status of these (tinderbox) builds here : http://tinderbox.libreoffice.org/MASTER/status.html but as you will note, there are no entries for Win, and even the other OSes seem to be having a rather hard time of it at the moment (due to the move to a single source repository and other factors no doubt). So we'll just have to wait. Alex
I can confirm this on master build from 23/11/2011. Clicking on the Browse button does nothing. Alex
!!!! Bugzilla lost my carefully crafted comment :-( So starting again, but "it was not as good" as she said: Need intervention / advice from Windows porter (Tor?). The immediate cause is that _ADO_DATALINK_BROWSE_ is not #define'd in dbaccess/source/ui/dlg/ConnectionHelper.cxx. There used to be this code: #if !defined(WINDOWS_VISTA_PSDK) && defined(WNT) #define _ADO_DATALINK_BROWSE_ #endif This explains why OpenOffice 3.3rc1 did not have this bug (compiled with WIndows XP SDK), but LibreOffice 3.3rc1 had this bug (compiled with Windows Vista SDK). The tinderbox build logs tell me that adodatalinks.cxx is compiled alright now, so my guess is that this whole "disable ADO if compiling with Vista SDK" is obsolete by now. Could a Windows porter just remove all that logic (basically finishing Tor's cleanup job in 4c505502a86f8579711ef869e171f7bcce35f7eb) and test? Thanks in advance. #define _ADO_DATALINK_BROWSE_ in dbaccess/source/ui/dlg/ConnectionHelper.cxx Remove all DISABLE_ADO and WINDOWS_VISTA_PSDK logic from dbaccess/Library_dbui.mk and dbaccess/Library_dbu.mk Compile, test, report.
Created attachment 53811 [details] patch as described in comment 13 Here is a "ready to test" patch, which does what I described in comment 13.
https://issues.apache.org/ooo/show_bug.cgi?id=77988 suggests that the whole issue of incompatibility of Vista SDK and ADO was solved in the Vista SDK as of version 6.0.6001.16621.148. So I'm going to be bold and just push my patch to master; if anything breaks, we'll deal with it. Other relevant OO.org issues: https://issues.apache.org/ooo/show_bug.cgi?id=77980 https://issues.apache.org/ooo/show_bug.cgi?id=76713
(In reply to comment #15) > So I'm going to be bold and just push my patch to master; if anything breaks, > we'll deal with it. Yes, it works in master (3.5) now. Asking for review to backport to 3.4.5
(In reply to comment #16) > (In reply to comment #15) >> So I'm going to be bold and just push my patch to master; if anything breaks, >> we'll deal with it. > Yes, it works in master (3.5) now. Asking for review to backport to 3.4.5 The fix has been applied to libreoffice-3-4 branch and will be part of release version 3.4.5