Click here to get back home

enable pooling on my sql

 HomeNewsGroups | Search | About
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
enable pooling on my sql psawant 07-24-2006
Posted by psawant on July 24, 2006, 10:27 am
Please log in for more thread options
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


Posted by Bill Karwin on July 29, 2006, 8:43 pm
Please log in for more thread options
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;q169470

Regards,
Bill K.

Posted by parez on July 30, 2006, 3:43 pm
Please log in for more thread options
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;q169470
>
> Regards,
> Bill K.


Similar ThreadsPosted
MySql Connector/NET Pooling November 29, 2005, 3:54 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap