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

Resolved Regarding MSOLEDBSQL Server driver

  1. How-to
0
Votes
Undo
  1. Apoorva JUKANTI
    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?

pbautobuild220.exe crashing on two branches but no...
Can PB2017 R3 run under windows 11?
Responses (1)
Chris Pollach @Appeon
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
Armeen Mazda @Appeon
  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.