1. Moshe Tangi
  2. PowerBuilder
  3. Tuesday, 24 April 2018 08:53 AM UTC

Helo all ,

I have an desktop app , using pb 2017 r2 . running and connecting to mssql  2014 DB . The pb + database are  installed on the same sever

Now , I need to develop .Net WebService . ( it going to be published on the same server) .

I wrote one function which does  : connect ( Via ADO.NET ) , and then   SELECT and  returs the select result ( one string ). I published and it went well .

Testing with the IE , returns the message : "error connecting data base" ( i put that in a case i can't connect ).

1. Do i need to include dll files ( such as : Sybase.PowerBuilder.Ado.dll ) in the WS deploy in the ( in the Library tab of the project painter ) ?

2. do i need to connect in the open event instead of the function code itself  ?

3. Originally , i do connect with ini file. ( i tried with ini and witout ) , if i want to do so , where do i put the ini file ?

thanks

 

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 24 April 2018 12:37 PM UTC
  2. PowerBuilder
  3. # 1

Hi Moshe;

       If this problem started on a non-developer PC, it might be because you do not have the .Net pieces of the PB run-time installed on that IIS machine. The PB Packager will create the normal C/S run-time PBVM installation. However the extra .Net pieces - that also need to be registered in GAC - need to be installed from the PB .Net run-time MSI installer. You can find the .Net "pbruntime.msi" install file located where PB2017R2 is installed. On my PC for example, the path would be: "C:\Program Files (x86)\Appeon\PowerBuilder 17.0\DotNET\pbiu\BootStrapper\Packages\1-PBRuntime"

HTH

Regards ... Chris

Comment
  1. Moshe Tangi
  2. Friday, 27 April 2018 08:51 AM UTC
Hi Chris



I have on the same server (2012 r2 ) pb 2017 rs + sql server management 2014 + database + .Net 4 , 2, 4.5 frame work .+ iis 8



running desktop app exe or runtime works great .



running ws from ide or IE does not connect ( the function i wrote returns error in case it does not connect )



do i need to config iis ? do i need to config sqlserver ?  what else do i need to check ?

  1. Helpful
  1. iliyan iliev
  2. Wednesday, 14 August 2019 12:22 PM UTC
Do you find resolution for this problem ?!

For me when start dekstop app is work , but start ws - transtaction not connected !

code is the same in for desktop & ws.
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.