enable pooling on my sql

am 24.07.2006 16:27:18 von psawant

hi all.

How do i enable pooling on mysql connection?
this is my string.

DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=dfdfd;" +
"DATABASE=dbname;" +
"UID=" + UserId +";" +
"PASSWORD=ff;" +
"OPTION=3

Re: enable pooling on my sql

am 30.07.2006 02:43:22 von Bill Karwin

psawant@gmail.com wrote:
> hi all.
>
> How do i enable pooling on mysql connection?
> this is my string.
>
> DRIVER={MySQL ODBC 3.51 Driver};" +
> "SERVER=dfdfd;" +
> "DATABASE=dbname;" +
> "UID=" + UserId +";" +
> "PASSWORD=ff;" +
> "OPTION=3

I can't tell from your code fragment what language you are using.
Probably some Microsoft language, but you don't make it clear which one.

Read the FAQ on ODBC connection pooling. It includes links to more
specific information for enabling ODBC connection pooling for individual
languages.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169 470

Regards,
Bill K.

Re: enable pooling on my sql

am 30.07.2006 21:43:55 von psawant

Hi Bill,

Thanks for the reply.

I am using vb.net and c#.

Bill Karwin wrote:
> psawant@gmail.com wrote:
> > hi all.
> >
> > How do i enable pooling on mysql connection?
> > this is my string.
> >
> > DRIVER={MySQL ODBC 3.51 Driver};" +
> > "SERVER=dfdfd;" +
> > "DATABASE=dbname;" +
> > "UID=" + UserId +";" +
> > "PASSWORD=ff;" +
> > "OPTION=3
>
> I can't tell from your code fragment what language you are using.
> Probably some Microsoft language, but you don't make it clear which one.
>
> Read the FAQ on ODBC connection pooling. It includes links to more
> specific information for enabling ODBC connection pooling for individual
> languages.
>
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169 470
>
> Regards,
> Bill K.