1. Apoorva JUKANTI
  2. PowerBuilder
  3. Tuesday, 12 March 2024 07:21 AM UTC

I installed Microsoft OLE DB Driver19 for sql server and pbmsoledbsql.dll are already installed along with PB. I created  a Database profile for MSOLEDBSQL SQLServer.

But I see the data profile using sql server driver instead of MSOLEDBSQL DB Driver, what is the expected behaviour of this MSOLEDBSQL SQL Server interface in Power builder.

1. Which driver it uses in the background?

2. After updating the database interface to MSOLEDBSQL SQL Server, what are the changes that need to be done in the code?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 12 March 2024 14:23 PM UTC
  2. PowerBuilder
  3. # 1

Hi Apoorva ;

  FYI: The MSOLEDB driver is a native SS DB client. As such, the newer PB IDE versions & runtime have a native DB Client "interface" driver, as follows ...

IDE:

Run time:

SQLCA.DBMS = "MSO"
SQLCA.DBParm = "Provider='MSOLEDBSQL19'"

Using the MSO v19 DB client would now mean that you should completely Unit Testing your App against SS to ensure that the newer SS & DB client software still behaves (DML wise) the same as your older SS DB client that your App was using.  HTH

Regards .. .Chris

Comment
  1. Armeen Mazda @Appeon
  2. Tuesday, 12 March 2024 16:13 PM UTC
Adding to what Chris said, for MSOLEDBSQL 19 version driver you need to use PB 2022 or newer. Are you using PB 2022?
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.