We have systems with oracle instant client  installed.
We need to connect to DB with "Oracle Connect Descriptor " as datasource, e.g.:
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
(CONNECT_DATA=
(SID=sales)
(SERVICE_NAME=sales.us.example.com)
(INSTANCE_NAME=sales)))
Connection Types with client fail with "can not obtain Oracle client information from registry..."
Connection Type direct mode (no oracle client) do not allow to enter a "Oracle Connect Descriptor"

is there a other way to query our oracle databases without full oracle client with a connect descriptor?

I am not sure exactly. But it sounds like maybe you have installed another architecture of the Oracle Client than VisualCron. Let say VisualCron runs in 64 bit and Orace 32 bit and it is trying to find an instance. Try installing the 64 bit version of the Oracle Client.

---

Yes, we are running VC in 64bit Windows 2012 R2.
Our applications work with oracle instant client 32bit, therefore we can not install 64 bit oracle instant client.

We can query Oracle databases from VC with method Standard 2 - direct mode (no oracle client), with paramater direct = true, when we supply hostname as "data source", port & SID.

But problem is, we need to connect to some databases with "Oracle Connect Descriptor ", which can not be given as "data source" - parameter to VC with "no oracle client" - connect mode.
e.g. like here:
https://connectionstrings.com/oracle-provider-for-ole-db-oraoledb/tns-less-connection-string/ 

The parameter "data source" on the "no oracle client" connection dialog only accepts a hostname (VC 7.2.0).

Perhaps you can adapt your "no oracle client" - connect mode, so that it accepts a datasource string (connect descriptor) for parameter datasource instead of only a hostname.

Thank you!

Thanks for the information. We are investigating this.

---

Thank you for investigating this issue.
Please let me know, if you have a version which allows to enter a connect descriptor for the "no oracle client"-mode.
Thank you.

What if you just use the Direct mode and use this (and replace values) as "data source" value:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = myPort))) (CONNECT_DATA = (SID = MyOracleSID)))

---

What if you just use the Direct mode and use this (and replace values) as "data source" value:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = myPort))) (CONNECT_DATA = (SID = MyOracleSID)))

have tried this before:
Connection failed because target host or object does not exist

if "data source" > 255 char:
hostname to long (max. 255 char allowed)

What if you just use the Direct mode and use this (and replace values) as "data source" value:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = myPort))) (CONNECT_DATA = (SID = MyOracleSID)))

have tried this before:
Connection failed because target host or object does not exist

if "data source" > 255 char:
hostname to long (max. 255 char allowed)

Could you send the exact log to support@visualcron.com when you get this error?

---

What if you just use the Direct mode and use this (and replace values) as "data source" value:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = myPort))) (CONNECT_DATA = (SID = MyOracleSID)))

have tried this before:
Connection failed because target host or object does not exist

if "data source" > 255 char:
hostname to long (max. 255 char allowed)

Could you send the exact log to support@visualcron.com when you get this error?

Not sure what log i can send.
Problem is in "Connection Wizard" in Connection Step 2 with "Connection type" "Standard 2 - direct mode (no oracle client)".
Parameter "Provider" = "Oracle"
Parameter "direct" = "true"
Parameter "user" & "password" are set also.
Parameter "datas source" is a valid connect string like above.

When"test connection ist clicked, an error dialog window appears:
Title "Devart.Data.Universal.UniException"
Network error::11004 ...

if "data source" > 255 char:
hostname to long (max. 255 char allowed)

What if you just use the Direct mode and use this (and replace values) as "data source" value:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myHost)(PORT = myPort))) (CONNECT_DATA = (SID = MyOracleSID)))

have tried this before:
Connection failed because target host or object does not exist

if "data source" > 255 char:
hostname to long (max. 255 char allowed)

Could you send the exact log to support@visualcron.com when you get this error?

Not sure what log i can send.
Problem is in "Connection Wizard" in Connection Step 2 with "Connection type" "Standard 2 - direct mode (no oracle client)".
Parameter "Provider" = "Oracle"
Parameter "direct" = "true"
Parameter "user" & "password" are set also.
Parameter "datas source" is a valid connect string like above.

When"test connection ist clicked, an error dialog window appears:
Title "Devart.Data.Universal.UniException"
Network error::11004 ...

if "data source" > 255 char:
hostname to long (max. 255 char allowed)

Please send the value you use in data source but replace password. Send it to support@visualcron.com

---