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.