Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection string parameters: order and blanks questions

pstein-JavaNetApr 29 2015 — edited Apr 29 2015

The webpage

http://www.connectionstrings.com/oracle/

provides a good introduction to connection strings. But two more questions:

1.) Does the order of the connection string paramters matter ?

In other words: Can I write e.g.

User Id=myUsername;Password=myPassword;Integrated Security=no;Data Source=MyOracleDB;

instead of:

Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;

 

2.) Are blanks in the connection string allowed?

In other words can I write e.g.:

Data Source = MyOracleDB; User Id=myUsername; Password = myPassword; Integrated Security = no;

instead of

Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;

Note the blanks around the "=" and after the semicolon?

Peter

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2015
Added on Apr 29 2015
2 comments
357 views