MySQLConnection的参数问题

[nashyeah1]

目标：做一个MYSQL的连接池。
难题：在MYSQL的参数设置上不正确。以下是楼主所用的代码：
public DbConn()//构造函数
{
ConnString = GetConnString();
SqlDrConn = new SqlConnection(ConnString);
}

private string GetConnString()
{
return "server=localhost;"
+ "userid=root"
+ "password=root"
+ "integrated security=sspi;"
+ "database=pubs;"
+ "Max Pool Size=" + MaxPool + ";"
+ "Min Pool Size=" + MinPool + ";"
+ "Connect Timeout=" + Conn_Timeout + ";"
+ "Connection Lifetime=" + Conn_Lifetime + ";"
+"Asynchronous Processing=" + Asyn_Process + ";";
}
但是这样一打开SqlDrConn就报错，显示无法连接。 求指导参数上哪里存在问题 需要修改。

[bdmh]

localhost：对吗，能识别吗
用户名，密码对吗

[nashyeah1]

[Quote=引用 1 楼 的回复:]

localhost：对吗，能识别吗
用户名，密码对吗
[/Quote]
这个都改了，但是不能显示不能连接。。这个格式有错吗？

[问苍天人生几何]

LZ参照下面来比对

SqlConnection conn = new SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI");

SqlConnection conn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;");

SqlConnection conn = new SqlConnection("Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=myserver");

SqlConnection conn = new SqlConnection( "uid=sa;pwd=passwords;initial catalog=pubs;data source=127.0.0.1;Connect Timeout=900");

SqlConnection conn = new SqlConnection( "server=localhost,1569;uid=sa;pwd=123;database=mydatabase;Connect Timeout=900");

 

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Data\test.mdb");

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Password=123;User ID=Admin;Data Source=test.mdb;");

OleDbConnection conn = new OleDbConnection("Provider=SQLOLEDB;Data Source=MySQLServer;Integrated Security=SSPI");