• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Connecting to Oracle Database in Power Builder 12.6?

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

Resolved Connecting to Oracle Database in Power Builder 12.6?

  1. Issue
0
Votes
Undo
  1. N P
    N P
  2. PowerBuilder
  3. Thursday, 22 February 2018 18:49 PM UTC

Hi All,

I am new to Power Builder .NET 12.6 . How do i make connection to Oracle database? , i have software installed on my machine which is Windows 10 64-bit. 

Thanks in advance.

NA

 

  1. Build
  2. Oracle
PB 2017 R2 executable Problem
PowerBuilder 2017R2 Localized Runtime
Responses (1)
Shenn Sellers
Shenn Sellers Accepted Answer Pending Moderation
  1. Thursday, 22 February 2018 19:25 PM UTC
  2. PowerBuilder
  3. # 1

Don't.  PowerBuilder .Net is deader than dead.  However, if you must persist, you need to create a ADO.Net connection.

Here are some tips...

https://archive.sap.com/discussions/thread/3373409​

https://www.cdata.com/kb/tech/oraclesalescloud-ado-powerbuilder.rst

http://www.databasesql.info/article/60887896/

 

Comment
Load more comments
Miguel Leeuwee
  1. Miguel Leeuwee
  2. Saturday, 24 February 2018 11:14 AM UTC
Without upgrading? You cannot. You will have to migrate the 6.5 application as soon as you add it to your 12.5 workspace.



32 / 64 bit Oracle client: For running your application from the powerbuilder IDE and executable, you would need 32 bit Oracle client. 



You only need the 64 bit oracle client if you generate a 64 bit executable with powerbuilder (not sure if that's possible with 12.5 but it is possible with 12.6)

  1. Helpful
N P
  1. N P
  2. Monday, 5 March 2018 12:30 PM UTC
Miguel,



Thanks for the response. I have upgraded my application to 12.6 and was able to connect with ORA db profile using tnsnames. How do i generate 64bit runtime application in 12.6? Would 32 bit runtime exe work on Win10 , Server 2003  & 2007 Server ?



Thanks,



NA

  1. Helpful
Miguel Leeuwee
  1. Miguel Leeuwee
  2. Thursday, 15 March 2018 23:39 PM UTC
Sorry for the late reply, we really miss the email notification on this forum :(



When you create a project object, there is a ddlb called "platform". There you can choose 64 or 32 bit. 



For running your application from the powerbuilder IDE you always will need the 32 bit oracle driver. You can have both versions installed.



Yes a 32 bit exe will work on windows 10, not sure if there is a windows server 2003 which is 64 bit? and not sure of 2007 server either. I know server 2008 does have 64 bit version. I think there was a problem of not having an Oracle 12 32 bit version for windows 10 (so we used the oracle 11g 32bit client), but believe that theres a 12c 32 bit version of oracle client available now also.

  1. Helpful
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.