• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PB 2019 R2 - recommended database interface to connect to SQL Server 2016

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

Resolved PB 2019 R2 - recommended database interface to connect to SQL Server 2016

  1. How-to
0
Votes
Undo
  1. Steen Jakobsen
    Steen Jakobsen
  2. PowerBuilder
  3. Monday, 14 September 2020 07:37 AM UTC

Hi all my fellow PB entusiasts  :-)

 

What PowerBuilder database interface (oledb,odbc, etc..) do you recommend to use to connect realiably to SQL Server  from a classic windows PowerBuilder application.

I'm running up to 50 instances of the same PB application exe (32 bit) simultaneously on the same windows server 2019 machine that has 56 cores and 512 gb memory.

 

Thanks for any advice :-)

 

//Steen

  1. Database
  2. PowerBuilder (Appeon)
  3. SQL Server
PowerBuilder Code Review
SMTP server
Responses (1)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 14 September 2020 15:44 PM UTC
  2. PowerBuilder
  3. # 1

Hi Steen,

Most customers used the SQL Server native client (SQLNCLI), but the issue is that Microsoft has deprecated this.  PowerBuilder 2019 R3 supports the Microsoft OLE DB Driver (MSOLEDBSQL), which is the recommended replacement by Microsoft.  Also, another advantage of R3 over R2 is that it is a long-term support (LTS) version.  Currently, there is a beta version of PowerBuilder 2019 R3 available.

Best regards,
Armeen

Comment
Load more comments
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 15 September 2020 07:44 AM UTC
You’re very welcome!
  1. Helpful
Steen Jakobsen
  1. Steen Jakobsen
  2. Tuesday, 15 September 2020 13:14 PM UTC
I have it all working perfect with 2019 R3 and the new SQL Server driver.

  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 15 September 2020 15:54 PM UTC
Excellent news!
  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.