- 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 22.214.171.124
now updated to LibreOffice 126.96.36.199, 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)
- 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)
Could it be the same problem as
(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.
(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 ***