469,081 Members | 1,882 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

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 1437

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
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.