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.