I'm trying to use u2 (10.1.12) on aix (5.2) connection pooling from
uniobjects.net via C# 2.0.

When I attempt even the ibm sample connection pooling code I get the
error below. Is there anything I need to configure on the server? I
cannot find anything in the docs. How do I configure conn pooling on
the server?

I have verified that 10.1.12 is supposed to support connection pooling.

[IBM U2][UODOTNET - UNICLIENT][ErrorCode=92] Connection Pooling is OFF.
Please verify UniVerse or UniData Version. This feature may not be
supported in older UniVerse or UniData version. Source: UniObjects
Class Method: Void .ctor(System.String, System.String, System.String,
System.String, System.String, Int32, Int32, Int32) at
IBMU2.UODOTNET.UniPool..ctor(String hostname, String userid, String
password, String account, String service, Int32 min_poolsize, Int32
max_poolsize, Int32 port_number)

You also have to licence U2 to use connection pooling - check the
licence params that it is in fact switched on.

rgds
Symeon.


chriscauchi (AT) hotmail (DOT) com wrote:

And if the licensing to get "free" UO.NET to use connection pooling is
going to cost more than a couple hundred dollars then I highly suggest
you take a look at mv.NET which fully supports connection pooling over
all MV platforms.

Tony
mv.net@ removethisNebula-RnD.com


"Symeon" <symeonb (AT) gmail (DOT) com> wrote:

There are many things I can do in UV, but figure out how to check the
license params to see if conn pooling is on is NOT one of them. I have
not a clue. I've looked all through UniAdmin and searched the
documentation, but clueless I remain. In UniAdmin there is the license
screen but it has no mention of what I'm looking for.

Anyone have the time to point me in the right direction?

Thanks! Pardon my stupidity.

Also, MV.NET looks very cool. I did not know about this before. Thanks
for the tip.

Symeon wrote:

chris wrote:
Glad it looks good to you. More info here:
removethisNebula-RnD.com/products/mvdotnet/mvdotnet.htm
removethisNebula-RnD.com/blog/category/tech/mv/mvnet/

Some happy users in this forum can comment if you have questions.

I'll be happy to provide download info, installation assistance, etc.

Regards,
Tony
TG@ always.remove.this.mungeNebula-RnD.com

chriscauchi (AT) hotmail (DOT) com wrote:
Hi,

This may help...

Have done a bit of investigation have have come up with the followingon
my test
system:

This was done using uv 10.1.20 on RH Linux ES

1) In the universe distribution there is a new package name CONNPL.
Inspection
of the uv.load script shows that this package is _not_ installed
into the uv
home directory during the uv installation.

2) Manual inspection of the package shows the following scripts and
file:
connpl.delete
connpl.install
connpl.stamp
checksums

So, test by manually installing the package. Move into the Universe
home directory
and unpack the package. On my test system the following does the job:

NOTE: I copy the uv media of the CD-ROM onto the hard disk before
installing,
adjust your command paths to suit your system.

# cd $(cat /.uvhome)
# cpio -icvdumB < /usr/download/universe/10.1.20/cdrom/CONNPL

Inspection of the connpl.stamp script shows that a uvcs licence will be
added to the
uvconfig file, so lets run it in the uvhome directory

# ./connpl.stamp

Inspection of the connpl.install shows that a new entry is added to the
unirpcservices
file, so lets run this script as well

# ./connpl.install

No errors were reported, therefore universe needs to read in the new
uvconfig file
generated by the connpl.stamp script, shutdown universe and restart:

# bin/uv -admin -stop
# bin/uv -admin -start

Log in to uv and run CONFIG to check uv configuration, the following is
a new entry:


-UVCS package is installed.
User limit = 32. Expiry date = 1/1/2500

Without any further testing it would appear that connpl has been added
to uv and is
a valid package in CONFIG.

The next source of information is the documentation for uniobject (.net
version) which
explains how to use connection pooling (I have uv 10.1b clients). Also
refer to
sample source code.

I have not tested if the connection pooling works, this is as far as I
can take it as
I do not have .net development installed on this pc, so the rest is up
to you....

I hope this help, good luck...

Barry

chriscauchi (AT) hotmail (DOT) com wrote:
Hi Chris,

Have found some more additional information:

1) Connection pooling is available in UniVerse 10.1.18 and greater
(therefore your
10.1.12 does not have connection pooling)

2) You find documentation for connection pooling in the UniData 7.1
manual NEWFEAT.pdf

HTH,

Barry

Thanks for the info you've saved me hours of looking.

C