1. Johan Wallén
  2. PowerBuilder
  3. Thursday, 21 November 2024 10:27 AM UTC

Hi,

connect to a SQL-server DB with ADO doesn't work in runtime environment after upgrading the application from 2019 to 2022R3. In the development environment everything works fine. But when I have distribute the runtime files to the testenvironment the application terminate during connect without any error message diplayed. The is a message in Window event viewer says something about missing rights to start the COM-serverprogram with CLSID.

It works fine to connect the DB by OLE DB and ODBC but not with ADO which always worked fine before.

Does anyone have a clue?

 

Regards,

Johan 

 

Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 21 November 2024 11:00 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

Check that you deployed all required runtimes with your application. Take a look at the following link:

Required runtime files - - Connecting to Your Database

Also, pay attention: if you are using PB 2022 R3 MR 3391, then you must install .NET Desktop Runtime 8.0. If you are using a lower version of PowerBuilder 2022 R3, then you must have .NET Desktop Runtime 6.0.

Andreas.

Comment
There are no comments made yet.
Johan Wallén Accepted Answer Pending Moderation
  1. Thursday, 21 November 2024 11:11 AM UTC
  2. PowerBuilder
  3. # 2

Thanks a lot, it works fine now. I have 3391 installed but have .net desktop 6.0 installed and thats why it didnt work.

Mayby Appeon should update the documentation.

 

Johan

Comment
  1. Andreas Mykonios
  2. Thursday, 21 November 2024 11:34 AM UTC
It's already mentioned in the link I sent you...

Andreas.
  1. Helpful
There are no comments made yet.
Johan Wallén Accepted Answer Pending Moderation
  1. Thursday, 21 November 2024 13:10 PM UTC
  2. PowerBuilder
  3. # 3

It wasn't updated in the PB help. But thanks anyway 

Comment
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.