1. 幸雄 戸川
  2. PowerBuilder
  3. Tuesday, 23 April 2024 02:37 AM UTC

Is it possible to develop PowerBuilder 12.6 with SQL Server 2019 database?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2024 18:51 PM UTC
  2. PowerBuilder
  3. # 1

Hi ;

Yes, but ...

  1. In SS 2019 and higher, Microsoft clanged the DB Client standard to use the new " "MSOLEDBSQL" DB client for SS DML interactions. This replaced the old SNI DB client used in older SS's (ie: SS 2012) as found in PB 12.6. Microsoft has now fully deprecated the SNI driver but you can still install that old SS DB Driver & use it for PB 12.6 for SS2019 interactions. However, the SNI DB client only has the mentality of supporting SS 2012 functionality. Thus, the new SS 2016, SS2019 (and higher SS versions) features could not be used.
  2. The ODBC DB Client for SS 2019 was updated but PB IDE / Apps do not call it directly. The PB runtime loads an ODBC "Interface" driver that then talks to the real ODBC middle-ware layer (where the SS2019 DB Client actually resides). So the PB 12.6 ODBC Interface driver will have the same restrictions as in #1 DML functionality wise.
  3. The ADO.net DB Client for SS 2019 was updated but PB IDE / Apps do not call it directly. The PB runtime loads an ADO.net "Interface" driver that then talks to the real ADO.net middle-ware layer (where the SS2019 ADO DB Client resides). So the PB 12.6 ADO Interface driver will have the same restrictions as in #1 DML functionality wise.
  4. Microsoft replaced the SNI DB Client driver in SS 2019 with a completely new DB Client called " "MSOLEDBSQL". Unfortunately, PB 12.6 has no interface to that now new MS SS standard DB client driver. Only Appeon PB 2022 does. So that option is not available to you in PB 12.6 and thus, the same restrictions as in #1 DML functionality wise.

HTH

Regards ... Chris

Comment
  1. 幸雄 戸川
  2. Wednesday, 24 April 2024 01:50 AM UTC
Thanks.

I will actually use it and check it out.
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2024 20:11 PM UTC
  2. PowerBuilder
  3. # 2

You'll have to use the PowerBuilder ODBC database connection type.

Install a version of the Microsoft ODBC Driver for SQL Server that is compatible with the version of SQL Server you have. The compatibility chart is here:

https://learn.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-ver16

SQL Server 2019 is compatible with version 18.3 which you can download here:

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

The x64 / x32 version of the installer refers to the bitness of Windows, not the applications.

Comment
  1. 幸雄 戸川
  2. Wednesday, 24 April 2024 01:35 AM UTC
thank you.

I will consider using it.
  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.