1. Amna Khalid
  2. PowerBuilder
  3. Saturday, 21 September 2024 04:54 AM UTC

Dear All,

 

I am encountering the error "No Database interfaces are installed. Please run the Setup program to install the appropriate interface(s)" when trying to use PowerBuilder 2022 R3.

SQL Native client is already installed on machine.

Note: I am using the free trial version of PB 2022.

Roland Smith Accepted Answer Pending Moderation
  1. Monday, 23 September 2024 12:56 PM UTC
  2. PowerBuilder
  3. # 1

Something went wrong with the PowerBuilder install. You should see this in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Sybase\PowerBuilder\22.0\Vendors

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Saturday, 21 September 2024 15:36 PM UTC
  2. PowerBuilder
  3. # 2

Hi, Amna -

There are two pieces of software that are needed in order for a PB application to communicate with any database:

  1. The vendor-supplied database client (SQL Server Native Client, in this case).
  2. The Appeon-supplied database interface that it to be used with (Part 1).

As Chris explains, you have installed (Part 1), but do not have any of the various options for (Part 2) installed.

Here is a link to a diagram that illustrates this: https://docs.appeon.com/pb2022r3/connecting_to_your_database/XREF_23761_Basic_software.html

If you are using a more recent version of SQL Server and you decide to purchase PowerBuilder, I suggest you consider using Microsoft's MSOLEDBSQL client instead of SQL Server Native Client (SNC). Microsoft deprecated the SNC client a few years ago and will no longer be providing updates to it. There is also the option of using an ODBC (Open DataBase Connection) driver along with PB's ODBC interface. ODBC works well, but it adds another software layer to the mix: https://docs.appeon.com/pb2022r3/connecting_to_your_database/XREF_22487_About_the_ODBC.html#d0e649

The Community is here to help, so I encourage you to ask additional questions as needed.

Best regards, John

Comment
  1. Chris Pollach @Appeon
  2. Saturday, 21 September 2024 20:13 PM UTC
Hi John;

That's not his problem as you can see the there are *no* DB driver options in the DB Profile Painter screen capture that he posted. That means the the PB installation was not completed properly.

Regards ... Chris
  1. Helpful 2
There are no comments made yet.
Amna Khalid Accepted Answer Pending Moderation
  1. Saturday, 21 September 2024 11:43 AM UTC
  2. PowerBuilder
  3. # 3

Hi,

 

in Appen free trial version of 2022, when I click on the DB profile for making database connection

then below message window message. 

Upon click of this ok button then below window comes

Comment
  1. Chris Pollach @Appeon
  2. Saturday, 21 September 2024 13:54 PM UTC
Looks like the problem could be with your PB installation. This could have been because you used the Appeon Online Installer vs the Offline (download & run setup.exe) in Admin mode; the installer asked you about DBMS interfaces & you bypassed that step; you do not have "local" admin privileges; a Windows policy is blocking you; your AntiVirus is blocking the installation from completing properly; etc.

I would suggest retrying an offline install running "as admin" and see if it prompts you to install the missing DB interfaces. Then the DB Profile Painter should then be full of interface options.

HTH
  1. Helpful 1
  1. Amna Khalid
  2. Sunday, 22 September 2024 07:04 AM UTC
HI Chris,



One thing needs to add that when I installed PowerBuilder 2022 R3, and initially, the database interfaces were available. I successfully tested the connection string using my database credentials, and the connection was established without any issues.



However, after restarting my system, I encountered the following error message:



"No Database interfaces are installed. Please run the Setup program to install the appropriate interface(s)."



  1. Helpful
  1. Amna Khalid
  2. Sunday, 22 September 2024 07:17 AM UTC
As pleas be noted, that I installed free trial version of pb 2022.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Saturday, 21 September 2024 11:17 AM UTC
  2. PowerBuilder
  3. # 4

Hi Amma;

  Are you referring to trying to connect to SS in the DB Profile Painter in the IDE or when you try to run your app from the IDE / EXE?

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.