I have an existing Excel Spreadsheet which has VBA code to connect to an Oracle database. I am trying to get it working with LibreOffice 3.4 in Windows 7 as a precursor to getting it running under GNU/Linux. The ADO Connection object is set and seems to be correctly instantiated but cannot be watched when stepping through the VBA code. I have both LibreOffice 3.4 and MS Excel 2003 runing side-by-side to verify its operation. Very happy to assist with debugging and testing and proposed changes. The code below does not raise an error but I cannot watch the mCnn object to confirm that the code is working as expected. This is hampering my coversion and is just a sample of an issue with the watch functionality. Any help is gratefully received. Sub OpenADOConnection() Dim strConnectionString As String On Error GoTo OpenError Dim mCnn As ADODB.Connection If mCnn Is Nothing Then Set mCnn = New ADODB.Connection End If 'Set the ADO connection parameters to connect to the Oracle Database strConnectionString = "PLSQLRSet=1;Data Source=somesource;User ID=someuser;Password=somepwd;" If Not mCnn.State = adStateOpen Then With mCnn .Mode = adModeRead .CursorLocation = adUseClient .ConnectionString = strConnectionString .Provider = "OraOLEDB.Oracle" .Open End With End If Exit Sub OpenError: Err.Raise Err.Number, Err.Source, Err.Description End Sub
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian