How can we help?

Yes. Install a relevant version of Oracle Client before connecting to an Oracle database.

If you are a subscriber or have a full license of the tool, there are several ways to apply the license key:

Apply the key automatically
Download the license key from the email we sent you upon the license registration and save it to the application home folder. The license key will be applied automatically at the first application launch.

Log into your Conquest account

1. In the welcome window, click Locate License or Have an existing subscription, depending on the license you hold.
2. Enter your customer ID or registration email and password to log into your account. The license key will be applied automatically.

Locate the key on the disk
On the login page, click Locate Key on Disk and then select the license key from the file system.

Paste the key from the Clipboard
Go to your Conquest account, copy the relevant key, and then click Paste from Clipboard on the login page of the application.

ClearSQL works with PL/SQL scripts, Oracle Forms & Libs versions from 6 to 11, and Oracle database objects versions from 9i to 19c.

To re-install your ClearSQL to another PC

1. Download and install the latest version of ClearSQL on the new PC.
2. Copy the license key to the application home folder.
3. Copy the %AppData%\ClearSQL folder.
4. Save Preferences and Code Analyzer Options to files and load them to the new ClearSQL.
5. Back up your ClearSQL projects and then restore them in the new ClearSQL.

For details, refer to the Re-installing ClearSQL to a new PC article.

We don't provide Mac-native versions of our tools, but you've got plenty of options, which are successfully applied by many of our mac-based users.

1. All the tools are tested in a virtual environment. You can install it with an Oracle Client to VMWare, VirtualBox, Parallels. Even Documenter, which is resource-critical runs with a minor overhead (±1%).
2. Some users report successful launches with Wine, though we haven't tested it on our grounds.
3. Bootcamp could also be the choice, should you prefer non-virtualized environments.

Yes, you can, but mind the following:

— Jenkins Windows service must be started under a user account, not under a system account.
— Check the available memory heap for non-interactive applications:

1. Open the registry value HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows.
2. Change last three digits of the SharedSection value to 1536.

By default, SharedSection = 1024,12288,512. The last three digits differ depending on Windows version. ClearSQL requires at least 1536.

For more information, refer to Microsoft support.

After running a job, you can check the log file %APPDATA%\ClearSQL\CS.log for errors.