How to enable connection pooling support?

[John]

I have a connection to Sybase which works fine. However, it
seems that the connection pooling is not enabled by default.
I tried to set pooling to true as well as set Max/min poll
Number, but it did not solve the problem.

Thanks,

John

[Paul Vero [Sybase]]

Hi John,

What sybase server? What exact type of driver? what application?

-Paul

<John> wrote in message news:4a825300.4cc...@sybase.com...

[John]

Hi Paul,

The sybase server is ASE version 15.0.2 (applied EBF 16299).
I connected to Sybase from a .Net application by
Sybase.AdoNet2.AseClient.

Hope the above answers your questions. If not, please let me
know.

Thanks,

John

[Paul Vero [Sybase]]

Hi John,

Pooling should be on by default on the Provider, try using connection
property pooling=true

What version of ADO.NET 2.0 Provider is this?

-Paul

<John> wrote in message news:4a832eb4.789...@sybase.com...

[John]

Hi Paul,

I did set Pooling=true in the connection string (along with
Max/Min pool Size). But it does not seem to help.

The version is V2.0.50727.

Is there a way (Setting, key, or program?) that I can
manually enable/disable connection pooling on Sybase server?

Thanks,

John

[Paul Vero [Sybase]]

Hi John,

Sorry for late response -

I want to know the Provider version, the file Sybase.AdoNet2.AseClient.dll -
just get the file version.

In .NET the pooling should happen automatically, especially when pooling is
true on the connection string.
I can't recall if we had pooling issues with the older provider.

Also, can you post your entire connection string? Maybe that has something
to do with it.

Thank you,

-Paul

<John> wrote in message news:4a8581e2.5c5...@sybase.com...

[John]

Hi Paul,

Thanks for your reply.

The version for Sybase.AdoNet2.AseClient.dll is 1.15.335.0.

The connection string is: "data source=<My local
IP>;PORT=5000;initial catalog=SybaseTest;Pooling=True; Max
Pool Size=50; Min Pool
Size=5;uid=testuser;pwd=mypassword;Connect Timeout=20".

I used my local IP as 'data source' since I am using Vista
and for some reason the machine name does not work.

Thank you!

John

[Paul Vero [Sybase]]

Hi John

Is it possible to provide a simple example of what you're doing and how you
monitor the pooling so you know it's not
working?
Otherwise you'll need to log a tech support case.

Thank you,

-Paul
<John> wrote in message news:4a9422fe.3f5...@sybase.com...

[Paul Vero [Sybase]]

Hi John,

Did you ever get this resolved? How are you monitoring the connections to
find out pooling isn't working? I;ve been working on a case where pooling
is involved and I
definitely see the connections pool on the ASE.

That version isn't too old and I never knew of issues where pooling wasn't
working.

THank you,

-Paul

<John> wrote in message news:4a9422fe.3f5...@sybase.com...