[Libreoffice-bugs] [Bug 104757] ODBC data source connected to Access DB: inserting data by drag and drop into a table in Writer returns no data, only shows database field names or aliases (Windows).

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=104757

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #13 from Alex Thurgood <iplaw67 at tuta.io> ---
Can not reproduce with :


LibreOffice 5412 x64

AccessDatabaseEngine_X64.exe (Dated 2016, but for Access2010)
Despite my best attempts at trying to find an official Microsoft download
specifically for Access 2016 databases, I couldn't find a download link that
actually worked.

Windows 10

1) I downloaded the Northwind example database for Access 2016.

2) I installed the AccessDatabaseEngine_X64.exe

3) I then used obdcad64 to configure a suitable DSN pointing to the Northwind
database (by the way, this part didn't work if the Access database was stored
in a OneDrive folder - go figure)

4) I fired up LibreOffice and chose the DB creation wizard and selected
"Connect to existing database via ODBC". I was asked to select a registered DSN
and chose Northwind. No password or user was required to connect to the
datasource. I tested the connection and it was successful.

5) Then I saved the ODB file, opened it in LibreOffice, and opened up the first
table in the list of available tables (Customers).


6) ODBC copy tests :

A) I selected the first table and dragged it into a blank Writer document. The
merge data wizard was started, I chose "Insert Data as Table", selected all
columns of the table and then pressed OK. All of the data from the database
table was copied into the Writer document as a table.

B) I double-clicked on Customers table to display the data content. Then I
selected one row/tuple from the table, and drag/dropped this into a blank
Writer document. The merge data wizard displayed and I chose Insert Data to
Table, selecting all columns from the Customers table, and pressing OK. All
data from the selected tuple was inserted as a table in the Writer document.

C) I repeated the steps in B, but selected multiple contiguous tuples. Then I
chose to only copy over data from 4 columns of the table. All of the selected
data was copied into a table in the Writer document.

D) I repeated the steps in C, but selected non-contiguous records. Again, all
data was correctly copied into the Writer document as a table.

So, I'm afraid that this is no repro for me.

>From various reports I have read on the MVP forums, Microsoft does not
recognize simultaneous installations of both 32bit and 64bit
AccessDatabaseEngine, so I will not be trying this with the 32bit versions of
ADB and LibreOffice.


Note that my Access 2016 db was locally stored and not on a Sharepoint server /
web db, as indicated by Ken in his example, so perhaps the difference lies
there. As I understand it, Microsoft has suspended Sharepoint Access web
database support from June 2017 and is forcing users to migrate to a different
system. As I don't use their cloud support, I can't say how this works exactly.

Setting to UNCONFIRMED.

Ultimately, this is WFM with 64bit LO, 64bit ADB, and an Access 2016 db.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171013/e479e3b6/attachment-0001.html>