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
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 ?
For me when start dekstop app is work , but start ws - transtaction not connected !
code is the same in for desktop & ws.