DI/JCo: Problem Data interface for Web applications

[Former Member]

L.S.,

We are running into problems with the DI objects in conjunction with IIS (ASP). On every page we need to query/update information on items. It takes quite a long time to connect to the SBO database every time, so to connect again on every page is no option.

Putting the DI object into a session variable is also no option, since the DI component is not Free threaded.

Does anyone have a solution to use the DI component in an IIS application?

Many thanks in advance.

Regards,

Michiel

[Former Member]

Previuosly I have used pooling in MS Component Services. To make this possible you should write a simple dll that supports pooling. I think you can find some info in MSDN/google on how you should do it. Doing this you can have several company-objects connected at the same time and you don't have to connect to the company for every call you make in your ASP-pages. I haven't tried this with SBO but i have done this with a similar object that used much time connecting to the database.

Leif Skaar

Bis-One as Norway