用数据库连接是可以连得上的。但是用.Net怎么也连不上。求大神帮忙。
web.config里这么写的:
<connectionStrings>
<add name="loadometerDataBase" connectionString="Data Source= 10.7.105;Initial Catalog=andi;User ID=sa;Password=123" providerName="System.Data.SqlClient" />
</connectionStrings>
程序里:
1, public class CoalBase
{
public static bool sqlReader()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["loadometerDataBase"].ConnectionString;
try
{
conn.Open();
return true;
}
catch
{
return false;
}
}
2,
bool conn = false;
conn = xlmis.Coal.CoalBase.sqlReader();
if (conn == false)
{
Response.Write("<script language='javascript'>alert('数据库连接不成功!')</script>");
}