1. NiceLabel Help Center
  2. Base de conocimientos
  3. Conectividad y base de datos

[en] Cannot connect to Excel or Access database

La traducción oficial aún no está disponible.

[en] Problem

[en] Problem 1

[en] You want to use Excel or Access database with your NiceLabel solution. When you try to connect to the database, you get an error message In some cases, you get the error message that you use the wrong type of file, or the database login dialog pops up when trying to connect to the Excel database.

[en] Problem 2

[en] When you try to print your labels, you get the following errors:

[en] "An error occurred during data processing.

[en] System error message:

[en] Provider cannot be found. It may not be properly installed."

31_provider1.png

[en] or

[en] "Error connecting to databases

[en] Could not establish connection to the following data tables:"

[en] "Database provider not found.

[en] Download Microsoft Office database provider from ..."

57_database_engine.jpg
[en] Problem 3

[en] When you are running Web Client with a solution connected to Excel or Access database, you get the error message:

[en] “System error message: Exception has been thrown by the target of an invocation. An error occurred while receiving the HTTP response to http://[workstation]/PowerFormsWeb/Services/V7DataServices.svc. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.The underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host”

[en] Solution

Nota

[en] This solution applies only to 64-bit Windows.

[en] Install  Microsoft Access Database Engine 2010 Redistributable form Command Prompt (CMD) with /passive switch:

  1. [en] Dioenload Microsoft Access Database Engine 2010 Redistributable. 

  2. [en] Select the option AccessDatabaseEngine.exe if you have 64-bit Office or if you have no Office installed. Select AccessDatabaseEngine_X64.exe if you have 32-bit Office.

    img-01_download.png

    Nota

    [en] Most of the Office installations are 64 bit so install the 32-bit driver: AccessDatabaseEngine.exe

    Nota

    [en] If you use a database connection from VBScript (for example, in our Allergen solution), only the 32-bit version of the driver (AccessDatabaseEngine.exe) will work.

  3. [en] Click Next to download the driver.

  4. [en] Run Command Prompt (CMD) as Administrator.

    Excel_login_2.png

  5. [en] In CMD navigate to downloaded AccessDatabaseEngine.exe or AccessDatabaseEngine_X64.exe.

    [en] Add a / passive switch and press <ENTER>.

    Excel_login_3.png

[en] Your database driver is now installed. Restart NiceLabel to see if your error is resolved.

[en] For more information about connectivity to MS Office documents, see this KB article.

Nota

[en] In some cases, problems may occur even if you have installed Microsoft Access Database Engine 2010 Redistributable. In this case, uninstall all versions of Microsoft Access Database Engine and then install Microsoft Access Database Engine 2010 Redistributable.