[en] Connecting to Oracle database

Die offizielle Übersetzung liegt noch nicht vor.

[en] Problem

[en] 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.

[en] Solution

[en] 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.

[en] Use Oracle Provider for OLE DB.

[en] Installing the client

[en] 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)".

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

[en] Configuring the client

[en] You can configure the client with Oracle Net Services.

[en] Testing the Connection

[en] 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.

[en] Run the following executable file on your computer:

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

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

oracle.png