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

Resolved Database connection string using SQL server 2019

  1. How-to
0
Votes
Undo
  1. Sara Kaur
    Sara Kaur
  2. PowerBuilder
  3. Tuesday, 7 March 2023 19:23 PM UTC

I am trying to connect PowerBuilder 2019 tp SQL Server 2019. Initially we were running application with SQL server 2014. What will be the best provider to connect to the database. Initially I was using SQLNCLI11 and found 2019 to be very slow compare to previous 2014 server. SQLOLEDB is better but still slow. let me know what you think will be the way to go?

Thanks,

Sara

Named pipes provider- could not open a connection ...
What function can be used to import window into pb...
Responses (3)
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 8 March 2023 19:47 PM UTC
  2. PowerBuilder
  3. # 1

your connection settings can make a difference.

things like packet size for example.  

Comment
There are no comments made yet.
Sara Kaur
Sara Kaur Accepted Answer Pending Moderation
  1. Tuesday, 7 March 2023 21:00 PM UTC
  2. PowerBuilder
  3. # 2

It seems to be working fine with PowerBuilder 2019. We are currently not upgrading the application to 2019 R3 or latest version. Do you know if that will be an issue?

Comment
Roland Smith
  1. Roland Smith
  2. Wednesday, 8 March 2023 13:43 PM UTC
SQLNCLI11 hasn't been supported by Microsoft since 7/11/2017. If you are okay with that, you can still use it.

  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 8 March 2023 18:04 PM UTC
In future when you do upgrade to latest PB version, use the latest version of MSOLEDBSQL driver. Sorry, don't know what is the issue with Microsoft's driver you might also want to post on some SQL Server forums.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 8 March 2023 21:45 PM UTC
Hi Everyone;

I just tested PB 2019 R3 into SS 2019 using ADO.Net, ODBC, OLEDB, MSOLE DB drivers with no issues and no performance hits. All DML was super fast running on my test systems.

I also tested PB 2022 into SS 2019 and SS 2022 using ADO.Net, ODBC, OLEDB, MSOLE DB drivers with no issues and no performance hits either . Again, all DML was super fast running on my test systems.

HTH Regards .. Chris
  1. Helpful 1
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 7 March 2023 19:31 PM UTC
  2. PowerBuilder
  3. # 3

SQLNCLI11 has been out of support by Microsoft for several years.

You might want to upgrade to PB 2019 R3 or higher and take advantage of the new MSOLEDBSQL driver. It uses 'Microsoft OLE DB Driver for SQL Server' which is the Microsoft supported driver.

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.