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

Resolved PB 2019 Migration Failure to Launch...

  1. Issue
0
Votes
Undo
  1. Lynn A Haynes
    Lynn A Haynes
  2. PowerBuilder
  3. Wednesday, 21 August 2019 15:53 PM UTC

My application was developed in PB 12.5 and I am migrating it to PB 2019. It runs from the IDE, but the deployed version on IDE machine errors out with message: DBMS OLE DB is not supported in your current installation, where PROVIDER='SQLOLEDB'. On an end user computer(with only PB Runtime dll’s + app), the error reads: The application was unable to start correctly (0xc000007b). I’m assuming the two are somehow related. Please advise. TIA

Should we replace POS with POSA in PB 2017r3
Using a REGISTRATION-FREE .Net DLL in PowerBuilder
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 21 August 2019 18:11 PM UTC
  2. PowerBuilder
  3. # 1

Hi Lynn;

  You would also need to deploy the SS OLEDB client as well on the PB App's PC. PB's OLEDB driver is only an interface to the real SS OLEDB client.

  The SS client would also require the proper .Net framework runtime as well.

Regards ... Chris

Comment
There are no comments made yet.
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Thursday, 22 August 2019 10:01 AM UTC
  2. PowerBuilder
  3. # 2

Hi Lynn，

#1 For the issue ‘DBMS OLE DB is not supported’:
If you deploy the application as 64-bit, then OLE DB is not supported, I suggest you deploy it as 32-bit and try again.
If you must deploy the application as 64-bit, then you need to use ODBC, SQL Native Client or ADO.Net to connect to SQL Server instead of OLE DB.

#2 For the issue “The application was unable to start correctly (0xc000007b)”：
Please confirm whether you are using the corresponding PB Runtime DLLs.
If your application is 64-bit, you need to use the PB 64-bit Runtime DLLs;
If your application is 32-bit, you will need to use the PB 32-bit Runtime DLLs.

Regards,
Ken

 

Comment
Lynn A Haynes
  1. Lynn A Haynes
  2. Thursday, 22 August 2019 19:08 PM UTC
Ken,



Thank you for your reply. We definately want to create a 64-bit app,so this is helpful. The transaction object is setup with these property values: dbms='OLE DB' and Provider='SQLOLEDB'. Where can I find what these should be set to for ADO.NET, ODBC, and SQL Server Native?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 22 August 2019 20:14 PM UTC
Hi Lynn;

FYI: https://www.appeon.com/support/documents/appeon_online_help/pb2019/connecting_to_your_database/pt02.html

Regards ... Chris
  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.