Problem

To connect to the Oracle database and use the data in NiceLabel software, install and configure the Oracle client software on each computer where NiceLabel is installed.

Solution

There are two providers for the Oracle database. Microsoft OLE DB provider for Oracle, which is discontinued and not supported anymore DO NOT USE THIS PROVIDER.

Use Oracle Provider for OLE DB.

Installing the client

The Oracle Provider for OLE DB is included in the bundle download from the Oracle site. Provider's name is "Oracle Data Access Components (ODAC)".

Install the appropriate release (32 or 64 bit) according to your version of Windows.

Configuring the client

You can configure the client with Oracle Net Services.

Testing the Connection

After you configure the client, test if the connection between clients and the Oracle server is established. Test the connection without using NiceLabel Desktop Designer.

Run the following executable file on your computer:

C:\app\client\[user]\product\[version]\client\sqlplus.exe

If everything is OK, you can make a connection in NiceLabel Desktop Designer.

oracle.png