Download it now!
Bug 55869 - Fileopen: ADO driver does not work with MS-SQL-Server
Summary: Fileopen: ADO driver does not work with MS-SQL-Server
Status: RESOLVED DUPLICATE of bug 53070
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.6.2.2 release
Hardware: Other Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-11 11:25 UTC by oli
Modified: 2012-11-01 12:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description oli 2012-10-11 11:25:29 UTC
our Setup: 
- MS-SQL-Server 2003
- <file_name>.odb File with the following Connection String: 
"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=<_My_Database_>;Data Source=<_My_SQL-Server_Name_ or _IP_>"
this works fine with LibreOffice 3.5.4.2

now updated to LibreOffice 3.6.2.2, gives following error(s):

LibreOffice (with all components currently running not only base) hangs with hourglass when: 
- opening the old <file_name>.odb file (o.k.) and then clicking on <Tabellen> in the left Database-Window (hourglass)

OR

- making a new <file_name>.odb file through ADO-connection:
step 1: o.k.
step 2: o.k. ; incl. Button <Verbindung testen> !
step 3: (no user name inserted) -> hangs on clicking Button <Verbindung testen>
        or o.k. on clicking <weiter>
step 4: -> hangs when checking <open database for editing> and clicking <Fertigstellen>
        or o.k. when not checking <open database for editing> and only creating <file_name>.odb file.

Cannot close LibreOffice any more; have to kill process by Task-Manager.

(Maybe somehow related to bug 52615, but definitely not solved)
Comment 1 Robert Großkopf 2012-10-15 17:03:07 UTC
Could it be the same problem as 
https://bugs.freedesktop.org/show_bug.cgi?id=53070 ?
Comment 2 oli 2012-10-24 10:21:00 UTC
(In reply to comment #1)
> Could it be the same problem as 
> https://bugs.freedesktop.org/show_bug.cgi?id=53070 ?

Bug 53070 deals with MS-Access and its drivers. 
Our problem is with MS-SQL-Server and ADO-driver. I can confirm that we can access our SQL-Server via ODBC-driver if that is helpfull somehow.
Comment 3 Lionel Elie Mamane 2012-11-01 12:58:53 UTC
(In reply to comment #2)
> (In reply to comment #1)

>> Could it be the same problem as 
>> https://bugs.freedesktop.org/show_bug.cgi?id=53070 ?

> Bug 53070 deals with MS-Access and its drivers.

That's how the reporter wrote it, but it is the same problem. The drivers that LibreOffice calls "MS Access (2003/2007)" is an automagic configuration around the ADO driver.

--> same problem, marking as DUP

*** This bug has been marked as a duplicate of bug 53070 ***