这样配置没有连接成功:
<connectionStrings>
<add name="TestConnectionString" connectionString="Provider=Microsoft.Jet.Oledb.4.0;Server=(local);Database=test;uid=root;pwd=123456;port=3306" providerName="System.Data.OleDb"/>
</connectionStrings>不知道具体怎样配置,才能通过数据源连接到MySql数据库,
非常感谢。
<connectionStrings>
<add name="TestConnectionString" connectionString="Provider=Microsoft.Jet.Oledb.4.0;Server=(local);Database=test;uid=root;pwd=123456;port=3306" providerName="System.Data.OleDb"/>
</connectionStrings>不知道具体怎样配置,才能通过数据源连接到MySql数据库,
非常感谢。
<add name="connstring" connectionString="User Id=root;host=192.168.10.188;Database=retest;password=000000;port=3306;persist security info=True;character set=utf8;" providerName="MySql.Data.MySqlClient"/>
<add name="TestConnectionString" connectionString="Provider=Microsoft.Jet.Oledb.4.0;Server=(local);Database=test;uid=root;pwd=123456;port=3306" providerName="System.Data.OleDb"/>
</connectionStrings>...
<add name="MySql" connectionString="server=10.0.5.29;user id=root; password=wrs123; database=ultrax; pooling=false;charset=gb2312;allow zero datetime=true" />
www.cnblogs.com/mail-ricklee
一、Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
二、Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;ORACLE 连接字符串:
Data Source=TORCL;User Id=myUsername;Password=myPassword;MS SQL 2005连接字符串:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;