1. Sathishkumar S
  2. PowerBuilder
  3. Thursday, 5 May 2022 17:55 PM UTC

Hi Appeon,

I am having an issue with MSOLEDBSQL connection.

Database has been migrated form SQL Anywhere 16 to MS SQL Server 2019 and we made compatibility changes in the power builder 2019 R3.

In the development environment I am able to run the application and connect with Database by using INI file (where MSOLEDBSQL is installed version 18.5).

/***************************

DB Profile Ini file

DisplayName=Database Test
DBMS=MSOLEDBSQL SQL SERVER
Database="DB_Test"
Servername="SQLServer"
DBParm= "Database='DB_Test',DelimitIdentifierToDB='Yes'"
EncryptName=EncryptHP::

*********************/

When I build and move to the another test PC to run the test where I am getting the message Microsoft OLE DB Driver for SQL Server(MSOLEDBSQL) is not installed.

Actually MSOLEDBSQL19 (64 bit version 19) is installed in that machine.

 

Kindly guide me how to rectify the issue.

Thank you,

Sathishkumar.

Accepted Answer
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 5 May 2022 18:02 PM UTC
  2. PowerBuilder
  3. # Permalink

You need to install 32-bit driver because your app is compiled as 32-bit

Comment
  1. Sathishkumar S
  2. Friday, 6 May 2022 05:16 AM UTC


Hi Armeen Mazda,



We have installed 32 bit version driver and able to access the application, thank you for the clarification



Thank you

  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 6 May 2022 06:21 AM UTC
Glad to hear resolved!
  1. Helpful
There are no comments made yet.
Georgios Papageorgiou Accepted Answer Pending Moderation
  1. Thursday, 26 May 2022 16:04 PM UTC
  2. PowerBuilder
  3. # 1

I have the same problem. 

When i try to install the 32bit from msoledbsql.msi i get this error

 

So i installed the 64bit ( which says it also puts  32bit in the syswow  )

Download Microsoft OLE DB Driver for SQL Server - OLE DB Driver for SQL Server | Microsoft Docs

 

But my very simple PB2021.1509 (32bit exe/pbd)  app says this ( but )

 

I installed the 1509 runtime with "PBCLTRT 21.0.0.1509" having all db options selected

any help appreciated

Georgios 

 

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 26 May 2022 16:23 PM UTC
Hi Sathishkumar / Georgios;

Please check with your SS DBA Team for the correct SS drivers for your environment (SS & O/S version) as these installs would come with your SS server's installation. HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Georgios Papageorgiou Accepted Answer Pending Moderation
  1. Thursday, 26 May 2022 16:09 PM UTC
  2. PowerBuilder
  3. # 2

Follow up

 

I got the 18.6.3 version from 

Release notes for OLE DB Driver - OLE DB Driver for SQL Server | Microsoft Docs

 

and this version x64 with 32bit PowerBuilder - så there is an issue with the version 19..... 

Anyone at Appeon who can veryfi this ?

Regards

Georgios

Comment
There are no comments made yet.
Georgios Papageorgiou Accepted Answer Pending Moderation
  1. Thursday, 26 May 2022 16:32 PM UTC
  2. PowerBuilder
  3. # 3

Chris 

 

The drivers failing are the (new) version 19 from Microsoft 

Version 18.6.3 are working

 

Regards

Georgios

 

PS. I'm the developer, DBA team , architect , CEO - > depends on which HAT im wearing :)

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 26 May 2022 16:46 PM UTC
Hi Georgios ... Thank you for that key feedback!

In that case, I would also suggest opening a Support Ticket around this SS DB driver issue (please & thanks).
  1. Helpful
  1. Georgios Papageorgiou
  2. Thursday, 26 May 2022 17:09 PM UTC
Added - support case - BUG 8423



Regards,

Georgios
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 26 May 2022 18:29 PM UTC
Hi Georgios ... Thank you for opening that ticket. I have already transferred it over to Appeon Engineering to confirm that A) they know about this and B) they have a plan to address this issue (at least in PB2022). Let's see what they say. ;-)
  1. Helpful
There are no comments made yet.
Georgios Papageorgiou Accepted Answer Pending Moderation
  1. Thursday, 26 May 2022 16:49 PM UTC
  2. PowerBuilder
  3. # 4

Hmmm seems my post disappeared .... 

 

Version 18.6.3 drivers from Microsoft are working 

Version 19.0.0 - are not working ... (but maybe not supported in PB2021)

I install the x64 as they also makes 32bit version i syswow 

 

 

But this could cause a lot of headache if not adressed in the documantaion ( og fixed :) )

Regards

Georgios

 

Comment
  1. Armeen Mazda @Appeon
  2. Thursday, 26 May 2022 17:06 PM UTC
Yes, 19 version of drivers not supported in PB 2021. You need to upgrade to 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.