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

Resolved PB2022, MSSQLOLEDB and Windows Server 2022 Issue

  1. Issue
0
Votes
Undo
  1. Menna Pablo Javier
    Menna Pablo Javier
  2. PowerBuilder
  3. Monday, 6 November 2023 13:55 PM UTC 
Hi.
I have a problem connecting to the databases using the MSSQLOLEDB driver, version 19.x, from Appeon Powerbuilder 2022 R2, on a Windows Server 2022 server. The error it returns is "The specified module cannot be found."
Any idea what's happening?

Regards
Attachments (1)
Error_PB2022.png Error_PB2022.png
Option to open FTP url & perform download in power...
Structured Excel Generation
Responses (3)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 6 November 2023 14:50 PM UTC
  2. PowerBuilder
  3. # 1

Did you install 'Microsoft OLE DB Driver 19 for SQL Server' on that server? Also, you need to have Provider='MSOLEDBSQL19' as part of DBParm, otherwise it will look for version 18 which uses 'Microsoft OLE DB Driver for SQL Server'.

Comment
Menna Pablo Javier
  1. Menna Pablo Javier
  2. Monday, 6 November 2023 17:26 PM UTC
Yes, it is installed. And the DBParm contains that text as Provider:



Database Connection Syntax:

// Profile p_pna

SQLCA.DBMS = "MSOLEDBSQL SQL Server"

SQLCA.LogPass = <*******>

SQLCA.ServerName = "HADES\SQL2022"

SQLCA.LogId = "integral"

SQLCA.AutoCommit = False

SQLCA.DBParm = "Database='P_PNA',Provider='MSOLEDBSQL19'"
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Thursday, 16 November 2023 14:24 PM UTC
Try dropping \SQL2022 from servername.
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Monday, 6 November 2023 14:47 PM UTC
  2. PowerBuilder
  3. # 2

Did you install the 32-bit version of the MSOLEDBSQL driver?

Comment
Menna Pablo Javier
  1. Menna Pablo Javier
  2. Monday, 6 November 2023 17:23 PM UTC
Hi John,

When I try to install 32-bit MSSQLOLEDB, it gives a message "Installation of this product failed because it is not supported on this operating system".

The operating system is Windows Server 2022, 64-bit
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 6 November 2023 17:41 PM UTC
Hi Menna;

AFAIK the installation of the 64 bit MSOLEDBSQL client also includes the 32 bit drivers as well. HTH

Regards ... Chris
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Monday, 6 November 2023 18:11 PM UTC
Chris is correct. The 32bit installer is for 32bit Windows and the 64bit installer is for 64bit Windows.
  1. Helpful
There are no comments made yet.
Menna Pablo Javier
Menna Pablo Javier Accepted Answer Pending Moderation
  1. Tuesday, 7 November 2023 11:23 AM UTC
  2. PowerBuilder
  3. # 3

I still can't get it to work. Is there any experience using PB2022 on Windows Server 2022? Or are they incompatible?

Regards

Comment
Andreas Mykonios
  1. Andreas Mykonios
  2. Tuesday, 7 November 2023 11:32 AM UTC
If you are running Powebuilder 2022 R2 (the IDE) on a windows 2022 server, this isn't supported. But if you are running an application deployed with PB 2022, then widnows server 2022 is supported.

Andreas.
  1. Helpful 2
Roland Smith
  1. Roland Smith
  2. Wednesday, 8 November 2023 13:31 PM UTC
Check the PB runtime folder to see if you have pbmsoledbsql.dll present. The PB runtime will be in:

C:\Program Files (x86)\Appeon\Common\PowerBuilder\Runtime 22.1.0.####
  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.