diff options
| author | jucasaca <jucasaca@gmail.com> | 2024-04-03 18:15:39 +0200 |
|---|---|---|
| committer | Mike Kaganski <mike.kaganski@collabora.com> | 2024-04-18 16:19:04 +0200 |
| commit | 7edca7dc740f6877fa85c2a996ca869c6b971a48 (patch) | |
| tree | 5d627cea026d412fb58854d6d5213708c40f312d /connectivity/registry | |
| parent | e1268721d4266ed1254da99581a7c2c3dfb72ba6 (diff) | |
tdf#158056 Connect to MS Access .mdb files by mean of ACE.OLEDB.12.0 provider
* Modify the code so that all connections to MS Access files, both .mdb
and .accdb are made with the provider "Microsoft.ACE.OLEDB.12.0".
* Remove all references to the "Microsoft.Jet.OLEDB.4.0" provider to clean
up the code.
* Leave only one entry "Microsoft Access" in the Connection Wizard, which
would work for .mdb and .accdb files.
* Remove the entry "Microsoft Access 2007" from the Connection Wizard,
since it is no longer needed.
Change-Id: If523712d071199d61e0c994b35291d3a69246ad1
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/165756
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
Diffstat (limited to 'connectivity/registry')
| -rw-r--r-- | connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu | 19 |
1 files changed, 2 insertions, 17 deletions
diff --git a/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu b/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu index 288c23e2e497..28f915ff8e3e 100644 --- a/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu +++ b/connectivity/registry/ado/org/openoffice/Office/DataAccess/Drivers.xcu @@ -214,7 +214,7 @@ </node> </node> </node> - <node oor:name="sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=*" oor:op="replace"> + <node oor:name="sdbc:ado:access:Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=*" oor:op="replace"> <prop oor:name="Driver"> <value>com.sun.star.comp.sdbc.ado.ODriver</value> </prop> @@ -340,7 +340,7 @@ </node> <node oor:name="Extension" oor:op="replace"> <prop oor:name="Value" oor:type="xs:string"> - <value>mdb</value> + <value></value> </prop> </node> <node oor:name="SupportsColumnDescription" oor:op="replace"> @@ -350,20 +350,5 @@ </node> </node> </node> - <node oor:name="sdbc:ado:access:Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=*" oor:op="replace"> - <prop oor:name="ParentURLPattern"> - <value>sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=*</value> - </prop> - <prop oor:name="DriverTypeDisplayName" oor:type="xs:string"> - <value xml:lang="en-US">Microsoft Access 2007</value> - </prop> - <node oor:name="MetaData"> - <node oor:name="Extension" oor:op="replace"> - <prop oor:name="Value" oor:type="xs:string"> - <value></value> - </prop> - </node> - </node> - </node> </node> </oor:component-data> |