1. Julián Tagarro
  2. PowerBuilder
  3. Thursday, 21 February 2019 16:05 PM UTC

Hi all,

I'm trying to deploy a .net web service (PB2017 R3) to a production server and, when I try to test it, I get the "Could not load file or assembly 'Sybase.PowerBuilder.DataWindow.Interop.dll' or one of its dependencies". 

I've checked all the pre requisites:

a) Windows Server 2012 R2

b) .net Framework 4.x and asp.net (installed from "Roles and Features" administrative tool)

c) msvcp100.dll, msvcr100.dll and atl100.dll on c:\windows\system32 (installed from c++ runtime installer)

d) I've installed the .net components generated running PBNETRT170 msi generated by PB Runtime Packager.

I'm testing it from "testwebservice.htm" directly from the server.

Can anybody help me with this situation ?

Thanks in advance.

_______________

Julián Tagarro

NeoSistemas SRL

Julián Tagarro Accepted Answer Pending Moderation
  1. Thursday, 21 February 2019 20:25 PM UTC
  2. PowerBuilder
  3. # 1

........ and Sybase.PowerBuilder.DataWindow.Interop.dll is in C:\Windows\Microsoft.NET\assembly\GAC_32 

Comment
There are no comments made yet.
Julián Tagarro Accepted Answer Pending Moderation
  1. Thursday, 21 February 2019 20:14 PM UTC
  2. PowerBuilder
  3. # 2

My webservice uses "PBDotNet4AppPool" and it's set up to run 32 bits app.

I must add .. this is a 100% production server. There isn't any version of PB installed here, it should have just the neccesary components to run the web service I intend to install.

Comment
  1. Chris Pollach @Appeon
  2. Monday, 25 February 2019 17:38 PM UTC
Hi Julian;



Yes, that is the last piece that I was looking for installation wise. WOW .. I am running out of things to suggest now. I have installed PB WS's like this over the past decade without this type of "no go" situation like you are encountering.



I had a customer get into this same predicament about 5 years ago and the only way that they could resolve the situation was to install the PB IDE on the IIS server. It was their idea and they did not need to run the IDE. However, this fixed the set-up issue on the production machine. From there, the were able to uninstall the IDE and then re-install the PB run-time and .Net run-times and the WS's kept running OK. That was very weird - but, it worked for them.



Regards ... Chris
  1. Helpful
  1. Julián Tagarro
  2. Tuesday, 26 February 2019 12:23 PM UTC
Hi Chris,

On the weekend we did that (install PB IDE on the production server) and finally its working.

Thanks for all your help.

Regards.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Tuesday, 26 February 2019 19:17 PM UTC
Hi Julian;

WOW .. that is great news! That was the only way one of my other customers got it to work. Yet, myself and dozens of PB customers have deployed WS's to IIS with what you did and had no issues. A very strange mystery indeed. However, all is well that ends well - end user wise! ;-)

Thanks for letting us know.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Julián Tagarro Accepted Answer Pending Moderation
  1. Thursday, 21 February 2019 19:57 PM UTC
  2. PowerBuilder
  3. # 3

Hi Chris,

Thank you very much for your response. 

Step 4 of my original post covers this requierement. Everything (and more may be unnecesary) is installed.

Thanks in advance.

_______________

Julián Tagarro

NeoSistemas SRL

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 21 February 2019 20:01 PM UTC
Great ... did you set up an "Application Pool" for your Web Service that also uthorizes 32 bit execution?

  1. Helpful
  1. Julián Tagarro
  2. Thursday, 21 February 2019 20:11 PM UTC
Reply in a different section because I can't paste images here ...
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 21 February 2019 19:39 PM UTC
  2. PowerBuilder
  3. # 4

Hi Julián;

  FWIW: You also need to deploy the PB .Net Run-time as well to your IIS server That can be done via the PB Packager Utility - but, you need to create a PBPACK.ini file to have that utility expose this MSI option.

  FYI: See my response in this thread ... https://community.appeon.com/index.php/qna/q-a/web-service-issue

HTH

Regards ... Chris

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.