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

Resolved connecting to database using ado.net

  1. Advice
0
Votes
Undo
  1. Malek Taha
    Malek Taha
  2. PowerBuilder
  3. Thursday, 12 October 2023 21:54 PM UTC

Hi

  I upgraded our application from PB 2021 to PB 2022 now i cannot connect to the data base using ado.net

documentation say i need these file in the executable folder of my app

pbado.dll

pbrth.dll

sybase.PowerBuilder.Db.dll

sybase.PowerBuilder.DbExt.dll

sybase.PowerBuilder.DataSource.Sharing.dll

 

I found the sybase dll on my computer but cannot find pbado.dll and pbrth.dll

Can you please direct me on how to get these files

 

Thanks

malek

 

 

Does the PowerBuilder Runtime and Frameworks inclu...
Use Object clicked
Responses (4)
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Tuesday, 9 April 2024 15:03 PM UTC
  2. PowerBuilder
  3. # 1

You should post a new question.

For PB 2022 R3 there required runtimes are different. Take a look at Database connections - - Application Techniques (appeon.com). .NET Desktop Runtime 6.0 is also required.

Andreas.

Comment
Erwin Anema
  1. Erwin Anema
  2. Tuesday, 9 April 2024 15:10 PM UTC
Thank you Andreas, that would be it!
  1. Helpful
There are no comments made yet.
Erwin Anema
Erwin Anema Accepted Answer Pending Moderation
  1. Tuesday, 9 April 2024 14:28 PM UTC
  2. PowerBuilder
  3. # 2

Hi,

Unfortunately that didn't solve it for me.
I uninstalled everything and then installed everything, even things I don't need just to be sure to find the pbado.dll file.
My version is PB 2022 R3 build 3356.

In the previous versions of PB 2021 and 2022 (2022.0.0.1892), the file has always been found under the runtime, e.g.
c:\Program Files (x86)\Appeon\Common\PowerBuilder\Runtime 22.0.0.1892\
c:\Program Files (x86)\Appeon\Common\PowerBuilder\Runtime 22.0.0.1892\x64\

So for my release I would expect it here:
c:\Program Files (x86)\Appeon\Common\PowerBuilder\Runtime 22.2.0.3356\

Has anyone installed PB 2022 R3 build 3356 and found the pbado.dll?
If so, where exactly / what exactly needs to be installed.
Or, is it not needed anymore and has the documentation not (yet) been updated?

Thanks in advance,

Erwin 

 

Comment
There are no comments made yet.
Malek Taha
Malek Taha Accepted Answer Pending Moderation
  1. Friday, 13 October 2023 18:14 PM UTC
  2. PowerBuilder
  3. # 3

Thanks John appreciate your help

       I uninstall PB 2022 R2 and reinstall from the appeon.com website. And i still cannot connect using ADO i can with ODBC b ut not =ADO

The application was upgraded fromPB2021 which connects without issue after the update can no longer connect.

 

I dont know where to turn or debug. This is a showstopper for us as my company wants us to upgrade before the end of the year.

 

Any help advise will be helpful

Thanks

Malek

 

Comment
John Fauss
  1. John Fauss
  2. Friday, 13 October 2023 19:30 PM UTC
I suggest you open a free standard support ticket regarding this issue: https://www.appeon.com/standardsupport/newbug
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Friday, 13 October 2023 03:01 AM UTC
  2. PowerBuilder
  3. # 4

Hi, Malek - 

I found the following information (highlighted) in the Connecting to Your Database publication (https://docs.appeon.com/pb2022r2/connecting_to_your_database/XREF_14307_Preparing_to_use.html):

If you install PowerBuilder using the PowerBuilder Installer (an online setup program), the ADO.NET interface is automatically installed. If you install PowerBuilder using the downloaded installation package (an offline setup program), select the ADO .NET Database Driver from the list of components.

If you used the downloaded installer, you may have to re-install PB 2022 and explicitly select the ADO.NET Database Driver.

Best regards, John

Comment
Paweł Kasperek
  1. Paweł Kasperek
  2. Tuesday, 18 June 2024 14:12 PM UTC
Hi,

I've got a question about distribution. If I can use my version of ADO .NET Database driver ex. to PostgreSQL, do I have to install .NET Runtime on the Machine from MSI installer or maybe I can load .NET Framework in any place and set the path to this folder?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 18 June 2024 16:47 PM UTC
FYI: Using an ADO.net client to interact with PostGreSQL is not planned to be in PB until PB 2025.
  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.