• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Running 32bit IDE connecting to Database using 64bit oracle client

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

Resolved Running 32bit IDE connecting to Database using 64bit oracle client

  1. Advice
0
Votes
Undo
  1. Leonid Shchervinsky
    Leonid Shchervinsky
  2. PowerBuilder
  3. Wednesday, 17 June 2020 05:28 AM UTC

I am setting up Database Profile for Oracle10g and getting "Oracle library OCI.DLL could not be loaded."

I am on Windows 10 64bit Intel CPU

I have Appeon_PowerBuilder_x32_x64_12.0_V01 runtime installed

I have  Oracle Client 64bit installed

 

The issue is:

 

I seem to be needing Oracle 64bit Client to run my PowerBuilder 64 bit application.

 

Can I run 32bit PowerBuilder application on a 64bit cpu?

 

The PowerBuilder IDE is a 32bit application, and requires 32bit Oracle Client

 

Q: can 32bit and 64bit oracle clients coexist? Turn one off and the other one on?

32bit oracle client for PowerBuilder IDE

64bit oracle client for PowerBuilder Application that I am writing

 

Can I make this setup work with just one oracle client?

 

Thanks

Leonid

 

 

Save As Functionality Excel
Show Blob-Picture in Datawindow
Responses (3)
Leonid Shchervinsky
Leonid Shchervinsky Accepted Answer Pending Moderation
  1. Thursday, 18 June 2020 07:44 AM UTC
  2. PowerBuilder
  3. # 1

Now I am stuck on the error message: "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA" no matter what I try to correct it. It looks like it is not able to locate the service in the tnsnames.ora file...

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 18 June 2020 09:03 AM UTC
Try setting the TNS_ADMIN environment variable. It has to point to the folder where your tnsnames.ora file is.

For example "D:\app\client\miguel\product\12.2.0\client_1\network\admin"

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 18 June 2020 09:20 AM UTC
If you have installed and uninstalled different versions of Oracle, it often messes up the registry. To see which version you're actually using, I always have a look at the registry:

32 bit:

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ORACLE\KEY_OraClient12Home1_32bit (or similar)

64 bit:

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraClient12Home1 (or similar)

Actually, that's where ORACLE_HOME now resides, no longer as an environment variable.



Clean up any old paths to old oracle client installations from the PATH environment variable.

See if you might have to do something with sqlnet.ora file:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

# NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)



Some people say commenting the NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) solved their issues.

Comment = #

Google is your friend :)

  1. Helpful
There are no comments made yet.
ATK Gimmy Susan
ATK Gimmy Susan Accepted Answer Pending Moderation
  1. Thursday, 18 June 2020 07:25 AM UTC
  2. PowerBuilder
  3. # 2

Hi

 

FYI

I have a 64-bit Oracle server installed on my personal computer.

I have a 32 bit Oracle client installed on my personal computer

I use both 32-bit applications and 64-bit applications without problems.

for example: - Powerbuilder (32 bit) - Oracle tools (64 bit).

 

I use this technique: https://ibk-software.com/beitrag/oracle-32-und-64-bit-gleichzeitig

 

Here the example shown is with cleinte 11_2, but with a few modifications you can adapt it to any client.

 

regards ...

GMY

 

 

P.s.

@Mazda Armeen: this is why we need a 64 bit IDE. To avoid these unnecessary spells.
We need a 64bit ecosystem.
(Remember that Microsoft retires the 32-bit windows 10 version)

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 17 June 2020 06:42 AM UTC
  2. PowerBuilder
  3. # 3

Hi,

Can I run 32bit PowerBuilder application on a 64bit cpu?
Yes you can.

Q: can 32bit and 64bit oracle clients coexist? Turn one off and the other one on?
Yes they can, you don't have to turn any of them "off".

 

Can I make this setup work with just one oracle client?
You have to install both: Oracle 32 bit client runtime and also Oracle 64 bit client runtime. So that's 2 clients.

regards,

Comment
Load more comments
Leonid Shchervinsky
  1. Leonid Shchervinsky
  2. Thursday, 18 June 2020 05:56 AM UTC
When I am using SQL Developer using TNS way of connecting to the database, SQL Developer uses ORACLE_HOME environment to locate the tnsnames.ora file.

How does the PowerBuilder IDE locate the tnsnames.ora file?
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 18 June 2020 09:04 AM UTC
YW,

I think you can use only ONE tnsnames.ora file if you set the TNS_ADMIN environment variable. It has to point to the folder where your tnsnames.ora file is. For example "D:\app\client\miguel\product\12.2.0\client_1\network\admin"

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 18 June 2020 09:10 AM UTC
ORACLE_HOME still seems to work, but if I remember well, that variable is no longer required from v 12 and higher.

I don't know how the powerbuilder IDE locates the file.

SQL Developer might but does not necessarily use the ORACLE_HOME variable, you can set the path in "Tools > Preferences > Database > Advanced", Tnsnames directory.

regards
  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.