Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved ORACLE EZCONNECT

  1. How-to
0
Votes
Undo
  1. Kyle Griffis
    Kyle Griffis
  2. PowerBuilder
  3. Friday, 21 February 2020 20:59 PM UTC

Hi All,

I am trying to connect to an Oracle database using the EZCONNECT method.  We were given advice to use the servername setting like this

sqlca.dbms="ORA Oracle"
sqlca.userid=""
sqlca.dbpass=""
sqlca.logid=asv_login
sqlca.logpass=asv_password
sqlca.database=""
sqlca.dbparm=""
sqlca.servername=[//]host[:port][/service_name]

However it is failing to recognize the setting as being valid.  Is there a working solution/example that illustrates how to employ Oracle's EZCONNECT for database connections?

 

Thanks,

Kyle

Runtime Error
PB license management
Accepted Answer
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 21 February 2020 21:19 PM UTC
  2. PowerBuilder
  3. # Permalink

yes, that is correct, most likely you don't have the correct values for this:

sqlca.servername=[//]host[:port][/service_name]

this is what my settings look like:

sqlca.servername="//ORANGE:1521/oracle.SBT.com"

 

do you have the oracle client installed?

 

Comment
Kyle Griffis
  1. Kyle Griffis
  2. Friday, 21 February 2020 22:06 PM UTC
I had the wrong values, thank you for your example.

  1. Helpful
There are no comments made yet.
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 21 February 2020 21:17 PM UTC
  2. PowerBuilder
  3. # 1

Hi Kyle;

   I would recommend using the Oracle "Instant" client.

   Also, make sure that you install both the 32bit & 64bit Oracle drivers.

HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.