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)
Menna Pablo Javier
Menna Pablo Javier Accepted Answer Pending Moderation
  1. Tuesday, 7 November 2023 11:23 AM UTC
  2. PowerBuilder
  3. # 1

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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 6 November 2023 14:50 PM UTC
  2. PowerBuilder
  3. # 2

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. # 3

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.