• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • DBMS OLE DB is not supported in your current installation

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

Resolved DBMS OLE DB is not supported in your current installation

  1. Advice
0
Votes
Undo
  1. rehees rafiq
    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.

Trim zero in EditMask
Cannot get raiseerror from procedure called using ...
Responses (2)
Andreas Mykonios
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
Load more comments
Andreas Mykonios
  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
rehees rafiq
  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
Armeen Mazda @Appeon
  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
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.