472,123 Members | 1,373 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,123 software developers and data experts.

MySql Connector/NET Pooling


I am trying to configure my asp.net application to work with MySQL
using Connector/NET and I wish to use connection pooling. What is the
best way to do this?

This is what I have so far:

MySqlConnection myConnection;
MySqlDataAdapter myDataAdapter;
DataSet myDataSet;

String strSql;

myConnection = new MySqlConnection("server=localhost; user id =
testuser; password=abc123; database=test;pooling=false;");

strSql = "Select * From Users;";

myDataAdapter = new MySqlDataAdapter(strSql, myConnection);

myDataSet = new DataSet();

myDataAdapter.Fill(myDataSet, "mytable");

DataGrid1.DataSource = myDataSet;

Now, I was thinking about putting the connection string in the
web.config file with pooling=true, but I a not sure what that would do.
I checked the documentation for Connection/NET and it doesn't give any
information on the pooling parameter. What happens if I set it to true?
Where do I specify the size of the pool? Do I need to make any changes
on IIS or MySQL itself?



Nov 29 '05 #1
0 1462

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by bunnytail | last post: by
5 posts views Thread by asadikhan | last post: by
5 posts views Thread by =?Utf-8?B?RGVubmlz?= | last post: by
14 posts views Thread by Frank Rizzo | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.