为什么大开连接的时候会出现SQL Server 不存在或访问被拒绝?代码如下
public SqlDataReader GetDepartments()
{
SqlConnection myconnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnetionString"]);
SqlCommand thiscommand = new SqlCommand("GetDepartments",myconnection); myconnection.Open();
SqlDataReader thisdatareader = thiscommand.ExecuteReader(CommandBehavior.CloseConnection); return thisdatareader;
}
public SqlDataReader GetDepartments()
{
SqlConnection myconnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnetionString"]);
SqlCommand thiscommand = new SqlCommand("GetDepartments",myconnection); myconnection.Open();
SqlDataReader thisdatareader = thiscommand.ExecuteReader(CommandBehavior.CloseConnection); return thisdatareader;
}
<appSettings>
<add key="ConnectionString" value="Data Source=数据库名; User ID=用户名; Password=密码" />
</appSettings>
以上使用的是 Oracle数据库
2.Sql Server服务器工作是否正常
数据库没有大开
对应在存储过程的哪个数据库没有打开
<appSettings>
<add key ="ConnectionString" value="Server=(loacal)\NetSDK;Integrated Security=True;Initial Catalog=JokePoint"/>
</appSettings>
服务器有打开啊
现在调试有出现ConnectionString 属性尚未初始化的问题.
//web.config中<appSettings>
<add key="constr" value="server=sql服务器的名字;database=数据库的名字;uid=你登陆数据的名字;pwd=你登陆密码"></add>
</appSettings>//在程序里这样写,先引入system.configurationusing System.Configuration;
//声明一个连接字符穿
private readonly string constr =ConfigurationSettings.AppSettings["constr"].ToString();//运行后constr中的内容就是你的连接内容
用SQL打开?
//这句是写在了page-load上面了吗?
public class sqlcon
{
private readonly string constr =ConfigurationSettings.AppSettings["constr"].ToString();
public sqlcon()
{
//
// TODO: 在此处添加构造函数逻辑
//
conn=new SqlConnection(constr); } public string getconstr()
{
return constr; } }
<appSettings>
<add key ="ConnectionString" value="Server=(loacal)\NetSDK;Integrated Security=True;Initial Catalog=JokePoint"/>
</appSettings>
---------------------------
Server=(loacal)\NetSDK???
loacal?不是local?
2.Sql Server服务器工作是否正常
==============================
不要去引用config里的变量,你先把连接字符串直接写上去试一下
_----------------------------------------
SqlConnection myconnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnetionString"].toString());
我以前也碰到过