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.
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.
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.
You can configure the client with Oracle Net Services.
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.