Page 1 of 1

Oracle Connection String example

Posted: Fri Apr 28, 2017 1:52 pm
by 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

Re: Oracle Connection String example

Posted: Fri Apr 28, 2017 1:58 pm
by 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".

Re: Oracle Connection String example

Posted: Fri Apr 28, 2017 3:46 pm
by 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

Re: Oracle Connection String example

Posted: Mon May 01, 2017 9:58 am
by Alex K.
Hello,

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

Thank you.

Re: Oracle Connection String example

Posted: Mon May 01, 2017 11:10 am
by cbrydon
Thanks Aleksey!

Re: Oracle Connection String example

Posted: Mon May 01, 2017 2:41 pm
by Alex K.
Hello

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

Thank you.