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

Resolved ODBC vs. MSOLEDBSQL19

  1. Advice
0
Votes
Undo
  1. Richard Donagrandi
    Richard Donagrandi
  2. PowerBuilder
  3. Thursday, 12 October 2023 00:40 AM UTC

We're switching from SQL Anywhere using ODBC to MS SQL Server 2022. We are also on PB 2022 R2... What would be the advantage of using MSOLEDBSQL19 over ODBC?  or does it matter?

Datawindow selected row background color using The...
Date Edit Mask text not always converted to date c...
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 12 October 2023 00:55 AM UTC
  2. PowerBuilder
  3. # 1

More SQL Server feature and theoretically faster performance.

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 12 October 2023 02:57 AM UTC
  2. PowerBuilder
  3. # 2

Hi, Richard -

ODBC is "middle-ware"... an additional layer of software interfaces between your application and the RDBMS.

It may or may not matter to you, but the Microsoft MSOLEDBSQL client does require installation on each client machine via the Microsoft-supplied .msi - You cannot simply copy some files to certain directories like you could with the deprecated Native Client (SNC) driver. It is possible, however, to install the MSOLEDBSQL .msi silently via command-line switches. More information is available on Microsoft's web site.

Best regards, John

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.