Oracle Connection String example

[cbrydon]

Hello, I am attempting to create an Oracle connection using the following format as suggested in another post.

url=jdbc:oracle:thin:@192.168.157.128:1521:orcl;user=sys as sysdba;password=oracle

When I try to use this format, and press the Test Button on the Oracle Connection dialog, I get the following message...
'url' is an invalid connection string attribute. How should the connection string be formed if the above syntax doesn't quite
work?

I am using Stimulsoft Web 2015.3 and Flash Player 25 for Windows.

Thanks,
Carl

[cbrydon]

I've also tried the following connection string format, but it doesn't quite work either.
jdbc:oracle:thin:sys/oracle@192.168.157.128:1521:orcl

The message I get is "Connection string is not well-formed".

[cbrydon]

Hi,
I kept pluggin away at this and a colleague suggested the following format and it works!
Data Source = orcl;User ID = sys;Password = oracle.

Cheers,
Carl

[Alex K.]

Hello,

You can find all connection strings for Oracle at the following link:
https://www.connectionstrings.com/oracle/

Thank you.

[cbrydon]

Thanks Aleksey!

[Alex K.]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.