1. Jacob Osborne
  2. PowerBuilder
  3. Friday, 19 April 2024 16:26 PM UTC

We are attempting to transition from ODBC to MSOLEDBSQL Version 19.3.3, but when we try to connect our Transaction, we get the error in the title of this post:

"DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"

This is from the connection string:
Provider='MSOLEDBSQL19'
DBMS='MSOLEDBSQL SQL Server'

Powerbuilder 2022, Build 1878

Windows Server 2022, Version 21h2

I've verified that MSOLEDBSQL19, Version 19.3.3 is installed. Also MSOLEDBSQL Version 18.5.0.0 is installed.

Who is viewing this page
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 19 April 2024 17:24 PM UTC
  2. PowerBuilder
  3. # 1

Hi Jacob;

  The "MSOLEDBSQL" DB Driver in PB is only an "interface" to the real Microsoft "MSOLEDBSQ" SQL Server "Client software ( either version 18 or 19). Thus, PB could just be trying to say that it cannot locate the Microsoft DB Client on your PC to connect its "interface" driver to. Please make sure that the Microsoft "MSOLEDBSQL" DB Driver(s) is(are) installed before trying that connection again in your PB ODE (you might need your DBA Team's help here). 

HTH

Regards .. Chris

Comment
  1. Jacob Osborne
  2. Friday, 19 April 2024 17:33 PM UTC
Hey Chris,

I've confirmed that MSOLEDBSQL version 19.3.3 is in fact installed on the machine. Here is a link to said version that's installed: https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 19 April 2024 17:45 PM UTC
Excellent ... then the next step is to make sure that you are using the correct MSO version as follows:

// Profile SS2022_PBDemoDB2022

SQLCA.DBMS = "MSO"

SQLCA.DBParm = "Provider='MSOLEDBSQL19'"

So for the "Provider", you would use either 18 or 19 (whichever you have installed). That should complete the "handshake".

  1. Helpful
There are no comments made yet.
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Friday, 19 April 2024 16:45 PM UTC
  2. PowerBuilder
  3. # 2

What Windows version are you running?

 

Regards,
Francisco

Comment
  1. Jacob Osborne
  2. Friday, 19 April 2024 16:50 PM UTC
Windows Server 2022, Version 21h2
  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.