• You are here:  
  • Home
  • Q&A
  • Q&A
  • Beta Testing
  • OLE DB connection using Provider=MSOLEDBSQL vs. new PowerBuilder 2019 R3 connection

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

Resolved OLE DB connection using Provider=MSOLEDBSQL vs. new PowerBuilder 2019 R3 connection

  1. Advice
0
Votes
Undo
  1. Tony Fahlberg
    Tony Fahlberg
  2. Beta Testing
  3. Friday, 30 October 2020 22:52 PM UTC

Hi - We have a PB2017 R3 application that uses a OLE DB connection with the Provider='MSOLEDBSQL' to connect to a MSSQL Server 2017 database. This is the newly supported driver provided by Microsoft so was wondering if there are additional benefits to replace the OLE DB connection we are currently using with the new connection type that I read read about in PowerBuilder 2019 R3 that uses the same MSOLEDBSQL provider.

Thanks in advance,

Tony

 

datawindow importfile() UTF8 (all European charac...
PB 2019 R3 Beta launched
Responses (1)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 30 October 2020 23:10 PM UTC
  2. Beta Testing
  3. # 1

Tons of benefits.  Microsoft has in-depth documentation about benefits, and they recommend not to use anything besides the new driver we are providing in 2019 R3.  Below are screenshots taken from the page I provided link for.

Comment
Tony Fahlberg
  1. Tony Fahlberg
  2. Friday, 30 October 2020 23:17 PM UTC
But we are already using the new MSOLEDBSQL provider in PB2017 R3 with an OLE DB connection type.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 30 October 2020 23:44 PM UTC
That's not going to work properly or it may be falling back to the old OLE DB driver. We did work in 2019 R3 to support the new driver for MSOLEDBSQL. https://docs.appeon.com/pb2019r3/whats_new/MS_SQL_Server_enhancements.html
  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.