1. rehees rafiq
  2. PowerBuilder
  3. Friday, 26 January 2024 11:17 AM UTC

PB2022 R2 2828 - Oracle 19c 64 bit.

After moving our PB app across to 64 bit when our app tries to connect to db get the following message:

DBMS OLE DB is not supported in your current installation

32- Bit version runs fine.

Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 26 January 2024 11:23 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

Is oracle client x64 installed on computer?

Andreas.

Comment
  1. Andreas Mykonios
  2. Friday, 26 January 2024 12:11 PM UTC
The main connection uses OLE DB or a different provider to connect?

Andreas.
  1. Helpful
  1. rehees rafiq
  2. Friday, 26 January 2024 15:01 PM UTC
The main connection is a standard connection so no issues there, whereas the OLE DB connection, connects with SQLOLEDB
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 26 January 2024 15:52 PM UTC
Are you connecting to SQL Server? Did you install 64-bit version of driver? A 64-bit app must use 64-bit DB driver.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 26 January 2024 16:09 PM UTC
  2. PowerBuilder
  3. # 2

Hi rehees

  Yes, the "OLE DB" DB driver is not 64 bit compliant.

   In your case you are connecting to an Oracle DBMS thus, you should be using the Oracle "native" driver ...

    SQLCA.DBMS = "ORA"

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.