Skip to main content
Solved

SQLExecutor Oracle Connection Parameter

  • May 29, 2014
  • 1 reply
  • 10 views
Y
Hi All, 

 

 

I was wondering if it Is possible to connect to a Oracle Non-spatial database without having the Service name set up in the tnsnames.ora file?

 

 

I'm using a Esri ArcSDE reader in my workbench so I am trying to use the same parameters to keep it simple to deploying on another machine. 

 

 

Thanks

Best answer by david_r

Hi,

 

 

you can use an Oracle EZCONNECT (http://www.orafaq.com/wiki/EZCONNECT) string on the format username/password@[//]host[:port][/service_name]

 

 

Example:

 

 

 

 

 

David
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • June 2, 2014
Hi,

 

 

you can use an Oracle EZCONNECT (http://www.orafaq.com/wiki/EZCONNECT) string on the format username/password@[//]host[:port][/service_name]

 

 

Example:

 

 

 

 

 

David

Helpful Members This Week

Community Stats

31,326
Posts
118,851
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.