issuese with Oracle Database connection in VisualCron - VisualCron - Forum

Community forum

Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
Offline tozier  
#1 Posted : Thursday, January 24, 2019 3:56:16 PM(UTC)

Rank: No customer

Joined: 7/28/2016(UTC)
Posts: 12
Location: Luxembourg, Luxembourg

Was thanked: 2 time(s) in 2 post(s)
Good Day,

We have issues trying to configure an Oracle Database connection in VisualCron

OS: Windows Server 2016 Standard 64bits
VisualCron Client/Server: 32bits v8.2.8 Build 42562 (2017-07-31 23:38:48)
Oracle Client: 32bits v12.

Steps to reproduce:
- Open VisualCron Client 8.2.8
- In the 'Server [localhost]' tab, go to 'Connections'
- Click the 'Add' dropdown and select 'SQL'
- Choose 'Use connection guide' option
- Select the following options and click 'Next':
Storage type -> Database
Database type -> Oracle
Data provider -> Native
- Set the following options
Connection type -> Standard
User Id -> *****
Password -> *****
- Click 'Test connection'

We get the following error message:
Connection test failed. Error: Unable to load C:\Oracle\product\12.1.0\client_1\oci.dll. Please check that you use 64x version of Oracle client with 64x application.

C:\Oracle\product\12.1.0\client_1\oci.dll exists on the filesystem.
Both VisualCron and the Oracle client are 32 bits
The connection string works fine when used in the code of console applications run by VisualCron
Creating and testing a MSSQL connection works fine.

What can we do to solve this issue?

Thank you,
Best Regards.
Offline Support  
#2 Posted : Thursday, January 24, 2019 11:28:20 PM(UTC)

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,258

Thanks: 877 times
Was thanked: 450 time(s) in 427 post(s)
Use the Oracle direct mode without the need of any Clients.

Oracle->Native->Standard 2- direct mode connection string
Please like VisualCron on facebook!
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top