1. Sally D
  2. PowerBuilder
  3. Friday, 18 January 2019 09:22 AM UTC

Hi all,

 

Now we are using the pb2017 r3 webservice function to replace the funtions in EA server before as .net webservice interface.

 

But we set the DB connection in the EA server in connection caches, then the PB just get the CacheName to connect to DB with the old PB. Now does anyone have some thoughts or advice to re-write the DB connection part on the IIS .net server?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 18 January 2019 15:12 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sally;

   For PB2017Rx PB based web services, you can just use an ODBC or ADO.Net client connectivity mechanism and then let those connections handle the DB caching (see MSDN for ODBC and ADO.Net help on accomplishing this).

FYI:  https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ole-db-odbc-and-oracle-connection-pooling

HTH

Regards ... Chris

Comment
  1. Sally D
  2. Wednesday, 27 February 2019 01:50 AM UTC
Hi Chris,

Thanks for replying. We are now deploy the PB code to dll file, then used in .net project. If use ADO.net client to handle the DB cache, how do we use the PB code which is in DLL to call the cache?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 27 February 2019 21:05 PM UTC
Hi Sally;

AFAIK, the cache is managed by the ADO.Net sub-system and transparent to PB.

Regards ... Chris
  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.