EEE Excel Templates: Use Updated OLEDB Driver - Revision history

Nivin: /* Updated OLEDB Driver */

2020-09-17T01:31:34Z

Updated OLEDB Driver

← Older revision		Revision as of 01:31, 17 September 2020
Line 15:		Line 15:
	Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2.		Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2.

	In order to support our customers who still use the classic EEE Excel Templates, ~~they are gradually being~~ updated with support for this driver. ~~Please refer~~ to the ~~EEE release notes to see which Templates have been updated~~.		In order to support our customers who still use the classic EEE Excel Templates, all of them have been updated with support for this new driver as of EEE v1.86 SR6. The recommendation is to use the new driver for connections where possible.

	Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit [https://aka.ms/downloadmsoledbsql aka.ms/downloadmsoledbsql].		Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit [https://aka.ms/downloadmsoledbsql aka.ms/downloadmsoledbsql].

Nivin: /* Updated OLEDB Driver */

2020-06-04T05:48:01Z

Updated OLEDB Driver

← Older revision		Revision as of 05:48, 4 June 2020
Line 22:		Line 22:
	* Please download and install the version of the driver based on your operating system architecture.		* Please download and install the version of the driver based on your operating system architecture.
	** 32-bit systems will require the x86 version of the driver.		** 32-bit systems will require the x86 version of the driver.
	** 64-bit systems will require the x64 version of the driver. This contains both the 32-~~bit~~ and 64-bit drivers.		** 64-bit systems will require the x64 version of the driver. This contains both the 32- and 64-bit drivers.

	Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''. Then continue to use the template as per normal.		Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''. Then continue to use the template as per normal.

	[[File:Excel_Updated_OLEDB_Driver_Support.png]]		[[File:Excel_Updated_OLEDB_Driver_Support.png]]

Nivin: /* Updated OLEDB Driver */

2020-06-04T05:47:21Z

Updated OLEDB Driver

← Older revision		Revision as of 05:47, 4 June 2020
Line 13:		Line 13:
	=== Updated OLEDB Driver ===		=== Updated OLEDB Driver ===

	Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2~~. The EEE Excel Templates are gradually being updated with support for this driver. Please refer to the EEE release notes to see which Templates have been updated~~.		Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2.

	Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit [https://aka.ms/downloadmsoledbsql aka.ms/downloadmsoledbsql] ~~to download the drivers~~.		In order to support our customers who still use the classic EEE Excel Templates, they are gradually being updated with support for this driver. Please refer to the EEE release notes to see which Templates have been updated.

			Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit [https://aka.ms/downloadmsoledbsql aka.ms/downloadmsoledbsql].

	* The driver needs to be installed on each client machine from where the EEE Excel Templates will be used.		* The driver needs to be installed on each client machine from where the EEE Excel Templates will be used.

Nivin: /* Background */

2020-06-04T05:45:07Z

Background

← Older revision		Revision as of 05:45, 4 June 2020
Line 2:		Line 2:
	EEE's classic Excel templates use the OLE DB Provider for SQL Server to establish connections with the EEE database. As of EEE v1.86, all the classic templates rely on the OLEDB driver in the Microsoft ActiveX Data Objects 2.8 Library that ships with Windows. This version of the OLEDB driver relies on TLS 1.0 to establish the connection.		EEE's classic Excel templates use the OLE DB Provider for SQL Server to establish connections with the EEE database. As of EEE v1.86, all the classic templates rely on the OLEDB driver in the Microsoft ActiveX Data Objects 2.8 Library that ships with Windows. This version of the OLEDB driver relies on TLS 1.0 to establish the connection.

	As TLS 1.0 is being deprecated by the industry, software and policies will require TLS1.0 connections to be ~~disables~~. Once this happens, this driver can no longer be used to connect to the EEE database.		As TLS 1.0 is being deprecated by the industry, software and policies will require TLS1.0 connections to be disabled. Once this happens, this driver can no longer be used to connect to the EEE database.

	== Recommendations ==		== Recommendations ==

Nivin: /* Updated OLEDB Driver */

2020-06-04T05:16:59Z

Updated OLEDB Driver

← Older revision		Revision as of 05:16, 4 June 2020
Line 23:		Line 23:

	Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''. Then continue to use the template as per normal.		Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''. Then continue to use the template as per normal.

			[[File:Excel_Updated_OLEDB_Driver_Support.png]]

Nivin: /* Updated OLEDB Driver */

2020-06-04T04:22:10Z

Updated OLEDB Driver

← Older revision		Revision as of 04:22, 4 June 2020
Line 13:		Line 13:
	=== Updated OLEDB Driver ===		=== Updated OLEDB Driver ===

	Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2. The EEE Excel Templates are gradually being updated with support for this driver. Please refer to the EEE release notes to see which Templates have been updated ~~with this support~~.		Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2. The EEE Excel Templates are gradually being updated with support for this driver. Please refer to the EEE release notes to see which Templates have been updated.

	Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit [https://aka.ms/downloadmsoledbsql aka.ms/downloadmsoledbsql] to download the drivers.		Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit [https://aka.ms/downloadmsoledbsql aka.ms/downloadmsoledbsql] to download the drivers.

Nivin: /* Updated OLEDB Driver */

2020-06-04T04:21:31Z

Updated OLEDB Driver

← Older revision		Revision as of 04:21, 4 June 2020
Line 15:		Line 15:
	Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2. The EEE Excel Templates are gradually being updated with support for this driver. Please refer to the EEE release notes to see which Templates have been updated with this support.		Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2. The EEE Excel Templates are gradually being updated with support for this driver. Please refer to the EEE release notes to see which Templates have been updated with this support.

	Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit https://aka.ms/downloadmsoledbsql to download the drivers.		Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit [https://aka.ms/downloadmsoledbsql aka.ms/downloadmsoledbsql] to download the drivers.

	* The driver needs to be installed on each client machine from where the EEE Excel Templates will be ~~run~~.		* The driver needs to be installed on each client machine from where the EEE Excel Templates will be used.
	* Please download and install the version of the driver based on your operating system architecture.		* Please download and install the version of the driver based on your operating system architecture.
	** 32-bit systems will require the x86 version of the driver		** 32-bit systems will require the x86 version of the driver.
	** 64-bit systems will require the x64 version of the driver. This contains both the 32-bit and 64-bit drivers.		** 64-bit systems will require the x64 version of the driver. This contains both the 32-bit and 64-bit drivers.

	Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''. Then continue to use the template as per normal.		Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''. Then continue to use the template as per normal.

Nivin: /* Updated OLEDB Driver */

2020-06-04T04:18:07Z

Updated OLEDB Driver

← Older revision		Revision as of 04:18, 4 June 2020
Line 20:		Line 20:
	* Please download and install the version of the driver based on your operating system architecture.		* Please download and install the version of the driver based on your operating system architecture.
	** 32-bit systems will require the x86 version of the driver		** 32-bit systems will require the x86 version of the driver
	** 64-bit systems will require the x64 version of the driver. ~~That this~~ contains both the 32-bit and 64-bit drivers.		** 64-bit systems will require the x64 version of the driver. This contains both the 32-bit and 64-bit drivers.

	Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''		Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''. Then continue to use the template as per normal.

Nivin at 04:17, 4 June 2020

2020-06-04T04:17:07Z

← Older revision		Revision as of 04:17, 4 June 2020
Line 1:		Line 1:
	EEE's classic Excel templates use the OLE DB Provider for SQL Server to establish connections with the EEE database. As of EEE v1.86, all the classic templates rely on the OLEDB driver in the Microsoft ActiveX Data Objects 2.8 Library that ships with Windows.		== Background ==
			EEE's classic Excel templates use the OLE DB Provider for SQL Server to establish connections with the EEE database. As of EEE v1.86, all the classic templates rely on the OLEDB driver in the Microsoft ActiveX Data Objects 2.8 Library that ships with Windows. This version of the OLEDB driver relies on TLS 1.0 to establish the connection.

	~~This version of the OLEDB driver relies on TLS 1.0 to establish the connection.~~ As TLS 1.0 is being deprecated by the industry, software and policies will require TLS1.0 connections to be ~~turned off~~. Once this happens, this driver can no longer be used to connect to the EEE database.		As TLS 1.0 is being deprecated by the industry, software and policies will require TLS1.0 connections to be disables. Once this happens, this driver can no longer be used to connect to the EEE database.

			== Recommendations ==
			=== API-based Templates ===

			Since v1.84, EEE has started the move towards an API-based approach for the Excel Templates. This means that a REST API sits at a EEE Head Office server which the Templates will then communicate with over HTTPS. This has the advantage of the latest security benefits, and customers have the option of making the API available over the internet which means the templates can be used without the need for a VPN. This is the recommended method going forward.

			Most of the standard EEE Excel Templates are available as API-based versions. Please contact Magenta Retail Support if you'd like to implement the API-based templates in your environment.

			=== Updated OLEDB Driver ===

			Microsoft has recently resurrected previously deprecated OLEDB drivers for SQL server and has made available a new version that supports TLS1.2. The EEE Excel Templates are gradually being updated with support for this driver. Please refer to the EEE release notes to see which Templates have been updated with this support.

			Note that the updated driver is not shipped with Windows and is available as a separate download from Microsoft. Please visit https://aka.ms/downloadmsoledbsql to download the drivers.

			* The driver needs to be installed on each client machine from where the EEE Excel Templates will be run.
			* Please download and install the version of the driver based on your operating system architecture.
			** 32-bit systems will require the x86 version of the driver
			** 64-bit systems will require the x64 version of the driver. That this contains both the 32-bit and 64-bit drivers.

			Once the correct driver is downloaded and installed, open a compatible EEE Excel Template, and under the Settings sheet, specify the Driver as '''MSOLEDBSQL'''

Nivin: Created page with "EEE's classic Excel templates use the OLE DB Provider for SQL Server to establish connections with the EEE database. As of EEE v1.86, all the classic templates rely on the OLE..."

2020-06-04T03:54:16Z

Created page with "EEE's classic Excel templates use the OLE DB Provider for SQL Server to establish connections with the EEE database. As of EEE v1.86, all the classic templates rely on the OLE..."

New page

EEE's classic Excel templates use the OLE DB Provider for SQL Server to establish connections with the EEE database. As of EEE v1.86, all the classic templates rely on the OLEDB driver in the Microsoft ActiveX Data Objects 2.8 Library that ships with Windows.

This version of the OLEDB driver relies on TLS 1.0 to establish the connection. As TLS 1.0 is being deprecated by the industry, software and policies will require TLS1.0 connections to be turned off. Once this happens, this driver can no longer be used to connect to the EEE database.