Jonathan: The connection pooling feature can be turned on by using the code examples I gave you. One was a connection form and the other was an "app.config" file in the .NET application. When I tested the project my connection pooling license showed one connection. I'm not sure how many connections one can get and whether they only allow one connection at a time (thus non-persistent http connections are what the license is designed for).
Writing a connection pool is certainly doable. Research on the internet shows: 1) ADO Connection Pooling Explained http://www.ondotnet.com/pub/a/dotnet/2004/02/09/connpool.html 2) Understanding Connection Pooling in .NET http://aspalliance.com/1099_Understanding_Connection_Pooling_in_NET 3) ADO.NET: Connection Pooling http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/connectionpooling.aspx 4) Take advantate of .NET connection pooling http://www.builderau.com.au/program/dotnet/soa/Take-advantage-of-Net-connection-pooli ng/0,339028399,339269541,00.htm I have no personal experience actually writing one. However, in a "production" environment, our .NET consultants supposedly gave us a connection pool but it failed weekly, which required a reboot of the .NET web server. In addition, when the last connection was terminated at the dbms end we also had to reboot the .NET web server. However, considering we were using PDP.NET at the time it's quite possible that this junk software was also involved somehow. Anyway, noone could figure this out so we moved to mv.NET and removed the connection pooling from the .NET code. Hope this helps. Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Jonathan Lienhoop >Sent: Wednesday, August 29, 2007 5:26 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] Learning Uniobjects.NET > >Well ... I guess I'm going to have to get lucky because we won't go get >ANY help and I'd be lucky to purchase a copy of mv.NET (especially if >its over 1000). > >I have two remaining questions: >1 - Is it possible for me to turn the connection pooling feature on? And >if so, how. >2 - If I can't turn connection pooling on, could I build a program that >maintains a connection pool? > >Jon > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett >Sent: Tuesday, August 28, 2007 5:05 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] Learning Uniobjects.NET > >Jonathan: > >You ask; "But is there any way I could create my own connection pool?". >The answer >is yes, and here is how it can be done: > >1) You get extremely lucky in your development and make a thousand design >decisions >correctly, >2) You get outstanding help (not just any .NET programmer) from those who >know both >technologies, or >3) You use a third party tool and get help to integrate these tools into your >application. > >Your boss is correct; this hiring of additional staff isn't worthwhile. >However, one >cannot use .NET technology without help from .NET consultants and others >familiar >with the tools you choose. This is the price we all have to pay to use new >technology produced by Microsoft and IBM. > >I personally think using mv.NET is the way to go as it presents the smallest learning >curve. You should be able to follow some of the development templates to >build an >application. > >Bill > >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf Of >>Jonathan Lienhoop >>Sent: Tuesday, August 28, 2007 11:32 AM >>To: u2-users@listserver.u2ug.org >>Subject: RE: [U2] Learning Uniobjects.NET >> >>Makes me laugh, I've only preaching the same thing (about getting >>experienced help) since January. But my boss doesn't seem to think >>hiring developers either as consultants or staff is worthwhile. He >>expects me to learn this stuff. So while I'm here I will and >>I want to do the best I can. >> >>In the meantime, I do feel that I understand the basics of how to pull >>data out. I'm more worried about how I'm managing the sessions and >>trying to implement a connection pool. >> >>I've already requested a demo of mv.NET simply because they promise data >>binding to .net controls and connection pooling. But is there anyway I >>could create my own connection pool? >> >>Jonathan Lienhoop >>Marvin Johnson & Associates, Inc. >>1.800.457.5255 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
