Pooling connections

--===============3960044320625884==
Content-Type: multipart/alternative; boundary="94eb2c1c1008211ee5055d924a51"

--94eb2c1c1008211ee5055d924a51
Content-Type: text/plain; charset="UTF-8"

Hi,

We are using mxODBC  with the native Microsoft MS SQL Linux driver (version
13.0) and we are opening and closing a connection for every database call.

This is considered to be  not very efficient, although I am not sure if
mxODBC does some clever pooling of connections or not.

We tried to add pooling at the unixODBC level, according to this:
http://www.unixodbc.org/doc/conn_pool.html

[ODBC]
Pooling=Yes

And in the drivers section:
CPTimeout=120


After that, our connections fail to work with this error:
[unixODBC][Driver Manager]Driver does not support this function

My question is, what is the best way to do connection pooling with mxODBC
and the native Microsoft MS SQL linux driver?

Regards, Jan

--94eb2c1c1008211ee5055d924a51
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div><div><div>Hi,<br><br></div>We are using mxO=
DBC=C2=A0 with the native Microsoft MS SQL Linux driver (version 13.0) and =
we are opening and closing a connection for every database call.</div><div>=
<br></div>This is considered to be=C2=A0 not very efficient, although I am =
not sure if mxODBC does some clever pooling of connections or not.<br><br><=
/div>We tried to add pooling at the unixODBC level, according to this:<br><=
a href=3D"http://www.unixodbc.org/doc/conn_pool.html">http://www.unixodbc.o=
rg/doc/conn_pool.html</a><br><br>[ODBC]<br>Pooling=3DYes<br><br>And in the =
drivers section:<br>CPTimeout=3D120<br><br><br>After that, our connections =
fail to work with this error:<br>[unixODBC][Driver Manager]Driver does not =
support this function<br><br></div>My question is, what is the best way to =
do connection pooling with mxODBC and the native Microsoft MS SQL linux dri=
ver?<br><br></div>Regards, Jan<br>=C2=A0<br><div><div><br><br></div></div><=
/div>

--94eb2c1c1008211ee5055d924a51--


--===============3960044320625884==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit


_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

--===============3960044320625884==--