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

Resolved Best Driver to connect to SQL Server 2019/2022

  1. How-to
0
Votes
Undo
  1. Jacob Osborne
    Jacob Osborne
  2. PowerBuilder
  3. Tuesday, 9 April 2024 13:53 PM UTC

Hi there,

Currently we use ODBC to connect to SQL Server 2019/2022, but we want the best possible performance and as such we're looking for the best practice in this regard.

We're using Powerbuilder Version 2022, Build 1878.

Thank you in advance for the help!

  1. Database Driver
  2. ODBC
  3. PowerBuilder (Appeon)
  4. SQL Server
connecting to database using ado.net
Print
Responses (1)
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Tuesday, 9 April 2024 15:07 PM UTC
  2. PowerBuilder
  3. # 1

You should mention version of PB you are using.

For PB 2022.x I guess the best option would be to go with OLE DB Driver for SQL Server (MSOLEDBSQL 19.x).

Andreas.

Comment
Jacob Osborne
  1. Jacob Osborne
  2. Tuesday, 9 April 2024 15:17 PM UTC
Hey Andreas, I've added the PB version to my question, thank you.
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Tuesday, 9 April 2024 15:33 PM UTC
We use version 19.2.We install 'Microsoft OLE DB Driver 19 for SQL Server' and set DBParm Provider='MSOLEDBSQL19'.
  1. Helpful 2
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.