1. Jesus Perez
  2. PowerBuilder
  3. Tuesday, 4 April 2023 13:03 PM UTC

We are trying to install a .net web services on a Windows 2012 R2 server, but the runtime files installation of PowerBuilder 2021 does not contain the required files.

 

Steps

  1. Installation IIS & ASP.net 3.5 and 4.5
  2. Restart server
  3. Installing 2021 runtime msi
  4. Restart server
  5. Installation .net web services project

After the installation we get the error message that Sybase.PowerBuilder.Core is not found.

Error

Line 386:            <add assembly="Sybase.PowerBuilder.Core, Version=21.0.0.0, Culture=neutral, PublicKeyToken=6e9b5029db92175f"/>

 

 

We use pb 2021 build 1506.

 

Jesus Perez Accepted Answer Pending Moderation
  1. Tuesday, 11 April 2023 13:23 PM UTC
  2. PowerBuilder
  3. # 1

I have put all my .Net files into the bin proyect folder but i have another error:

Could not load file or assembly 'Sybase.PowerBuilder.DataSource.Db.dll' or one of its dependencies.



All dll with .DataSourse are already in the bin proyect folder.

What can I do?



Thanks.

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 6 April 2023 15:01 PM UTC
  2. PowerBuilder
  3. # 2

In my PB web service, I had to put Sybase.PowerBuilder.DataWindow.Excel12.dll in the same folder as the deployed PB code files for XLSX export to work.

You'll have to put your .Net files in with the deployed PB code files or register them in the GAC.

Comment
  1. Jesus Perez
  2. Monday, 10 April 2023 12:38 PM UTC
Hi Roland, Thanks for your response.

I have put all my .Net files into the bin proyect folder but i have another error:

Could not load file or assembly 'Sybase.PowerBuilder.DataSource.Db.dll' or one of its dependencies.



All dll with .DataSourse are already in the bin proyect folder.

What can I do?



Thanks.
  1. Helpful
There are no comments made yet.
Jesus Perez Accepted Answer Pending Moderation
  1. Wednesday, 5 April 2023 14:50 PM UTC
  2. PowerBuilder
  3. # 3

I have the same problem "Could not load file or assembly 'Sybase.PowerBuilder.Interop.dll' or one of its dependencies"

I have to copy this dll into the proyect folder?

Comment
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Tuesday, 4 April 2023 15:01 PM UTC
  2. PowerBuilder
  3. # 4

This file should be in your Powerbuilder installation (in my computer it's located in "C:\Program Files (x86)\Appeon\PowerBuilder 19.0\DotNET\bin"). Normally this file should have been deployed with the msi created from runtime packages...

Andreas.

Comment
  1. Jesus Perez
  2. Tuesday, 4 April 2023 18:09 PM UTC
Yes, .NET 4.5 is installed.



I have to copy this dll into proyect folder?

Where are the dll after install the runtime msi?



Thanks
  1. Helpful
  1. Andreas Mykonios
  2. Wednesday, 5 April 2023 06:03 AM UTC
Normally all pb .net libraries should be installed in GAC. In my computer I do find them in C:\Windows\Microsoft.NET\assembly\GAC_MSIL.

Andreas.
  1. Helpful
  1. Jesus Perez
  2. Wednesday, 5 April 2023 12:01 PM UTC
I have the same problem "Could not load file or assembly 'Sybase.PowerBuilder.Interop.dll' or one of its dependencies"

I have to copy this dll into the proyect folder?
  1. Helpful
There are no comments made yet.
Jesus Perez Accepted Answer Pending Moderation
  1. Tuesday, 4 April 2023 14:37 PM UTC
  2. PowerBuilder
  3. # 5

Hi Andreas, thanks for your  response.

 

I have installed the runtime package i have a diferent problem .

 

the ws return "Could not load file or assembly 'Sybase.PowerBuilder.Interop.dll' or one of its dependencies"

 

 

what can I do?

 

 

Comment
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Tuesday, 4 April 2023 13:50 PM UTC
  2. PowerBuilder
  3. # 6

Hi.

First of all you should avoid using this type of projects as it is considered as obsolete (and unsupported).

Working with PowerBuilder - - Users Guide (appeon.com)

By the way this type of project isn't available in PB 2022...

For the runtime, you can use pbpackager to create an msi with all powerbuilder required runtimes files. Packager may be located to "C:\Program Files (x86)\Appeon\PowerBuilder 21.0\IDE" depending on the installation folder you choose while running installation.

You will have to add a file named pbpack.ini in the same folder where pbpack210.exe is located (probably "C:\Program Files (x86)\Appeon\PowerBuilder 21.0\IDE"). The contents of the ini should be:

[Packager]
DotNetComponents=1

After that, launching pbpackager will allow you to create an msi for .NET components.

Andreas.

Comment
  1. rodrigo teixeira
  2. Monday, 15 April 2024 12:36 PM UTC
Hello, is this process also necessary in 2022 r3?
  1. Helpful
  1. Andreas Mykonios
  2. Monday, 15 April 2024 12:48 PM UTC
Hi. If you are asking about .net web services, then this type of project isn't available in PB 2022.x...

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