1. Sverre Tvedt
  2. PowerBuilder
  3. Thursday, 1 August 2024 18:24 PM UTC

Platforms: SQL Server 2022/PB 2022 32bit apps

We are considering a new attempt to upgrade from PB 2022 to R3, having abandoned the previous attempt to upgrade to R2, due to the hassle with .NET Desktop Runtime 6.0 on  the client side. There are hundreds of client computers interfacing directly with SQL Server.

Switching to the recommended MSOLEDBSQL connectivity there still seems to be a dependency on  external installers, in this case Microsoft OLE DB Driver 19 for SQL Server (x64), right?

Is that the only way?

 

best regards

sverre

Sverre Tvedt Accepted Answer Pending Moderation
  1. Thursday, 1 August 2024 21:23 PM UTC
  2. PowerBuilder
  3. # 1

mike,

yes that is the only option if one wants to avoid the client machine installer problem. As to bitness, the 64 bit installer is intended to match the OS , and supports both 32 & 64 bit PB applications.

 

cheers

sverre

Comment
There are no comments made yet.
Sverre Tvedt Accepted Answer Pending Moderation
  1. Thursday, 1 August 2024 20:12 PM UTC
  2. PowerBuilder
  3. # 2

Right . But up to and including PB 2022, the appropriate client drivers for ADO.NET could be bundled together with the rest of the PB runtime components and copied from a file server to each client machine by the same script. That has been our deployment mechanism for fifteen years now. Now we need an installer executing with AD admin permissions due to ever increasing security policy. I suppose that can be done with Group Policy tools.

 

Thanks for clarifying!

 

regards sverre

 

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Thursday, 1 August 2024 19:31 PM UTC
  2. PowerBuilder
  3. # 3

all versions of windows (not sure about 11, but it runs on my new windows 11 laptop) from vista (i believe) came with oledb installed (old/original oledb not the msoledb).  That is still an available option for powerbuilder. 

 

If you are not using any of the newer features in sql server then maybe that is an option.

You stated "32bit apps" but then ask about x64?  you need to install same bitness 

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 1 August 2024 19:28 PM UTC
  2. PowerBuilder
  3. # 4

Hi Sverre

  Yes, the "MSOLEDBSQL" DB Client is now Microsoft's current recommended SS connectivity mechanism - especially going forward. There are still DB connecti0on alternatives like ODBC for example that you can use but for SS 2022, both the OLEDB and SNC DB client drivers are now deprecated by MS.

  If you stay in the Client / Server paradigm then yes, you will still need to install the appropriate SS DB Client software. That is no change from what you have been doing to deploy C/S Apps with PB releases from PowerSoft, Sybase, SAP and early Appeon PB releases. If you stay in that C/S paradigm  - even in the latest PB 2022 R3 version - you would be required to install the DB client using the same deployment considerations you have been used to.

  However, if you move to the new Native Cloud paradigm (aka PowerServer feature), then the data access and all related SS connectivity software to be installed and run is handled in the middle tier as your PB Apps are now processing as an N-Tier PB applications.

FYI: https://www.appeon.com/products/powerserver

  PowerServer Native Cloud apps are still native PB App execution. Its just that the App delivery (including the PB runtime) is via a Web Server. Once the PB App is delivered to the App user from the Web Server, the PS App then connects to PowerServer (middle tier) where all the SS Data interactions are processed.  Food for thought

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.