实际主机中的连接字符串 [英] Connection string in actual host

问题描述

你好......

在本地我有一个连接字符串（web.config）如下

的ConnectionStrings> 
 <   add    < span class =code-attribute> name   =  bongahConnectionString    connectionString   = 数据源= MEHDI-PC;初始目录= bongah;集成安全性=真  
   
               providerName   =  System.Data.SqlClient    /  >  
 <   / connectionStrings  >  

在主持人中有一个像这样的连接字符串

数据源= .\SQLEXPRESS;集成安全性= SSPI; AttachDBFilename = | DataDirectory | aspnetdb.mdf;用户实例= true 

当我尝试访问db时出现此错误





找不到网络路径



描述：期间发生了未处理的异常执行当前的Web请求。请查看堆栈跟踪以获取有关错误及其源自代码的位置的更多信息。



异常详细信息：System.ComponentModel.Win32Exception：找不到网络路径



源错误：

行 78 ：{
行 79 ：SqlConnection con =  new  SqlConnection（System.Configuration.ConfigurationManager.ConnectionStrings [  bongahConnectionString]的ToString（））; 
行 80 ：con.Open（）; 
行 81 ： string  query1 =   SELECT ID FROM aparteman WHERE ID =（SELECT MAX（ID）FROM aparteman）; 
行 82 ：SqlCommand cmd =  new  SqlCommand（query1，con）; 

我该怎么办？

解决方案

嗨Mehdi，



数据源= MEHDI-PC;初始目录= bongah;集成安全性=真



1）在上面的连接字符串中，尝试将MEHDI-PC替换为IP地址，从连接字符串的角度来看，它将更容易理解。（可选）

2）我认为你错过了数据库实例名称。



示例SQL Server连接字符串应该如下所示

 connectionString =SERVER = 192.168.xx.xx\SQL2008; DataBase = DatabaseName; Initial Catalog = bongah; UID = Username; pwd = ****;

希望这对你有所帮助。



问候，

RK

在Web.config中使用此代码

 <   connectionstrings  >  
 <   add     name   =  NewConnectionString < span class =code-attribute>   connectionstring   =  Data Source = .\SQLEXPRESS; AttachDbFilename = | DataDirectory | \ shoping.mdf; Integrated Security = True; User Instance = True    providername   =  System.Data.SqlClient    /  >  
 <   / connectionstrings  >  

现在在FileName.aspx.CS文件中使用此代码



SqlConnection con = new SqlConnection（ConfigurationManager.ConnectionStrings [ NewConnectionString]的ConnectionString）;

Hi there...
In local hast I have a connection string(web.config) as below

connectionStrings>
    <add name="bongahConnectionString" connectionString="Data Source=MEHDI-PC;Initial Catalog=bongah;Integrated Security=True"

      providerName="System.Data.SqlClient" />
  </connectionStrings>

and in host there is a connectionstring like this

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

when i try to access to db this error appear


The network path was not found

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The network path was not found

Source Error:

Line 78:     {
Line 79:         SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["bongahConnectionString"].ToString());
Line 80:         con.Open();
Line 81:         string query1 = "SELECT ID FROM aparteman WHERE ID=(SELECT MAX(ID)FROM aparteman)";
Line 82:         SqlCommand cmd = new SqlCommand(query1, con);

What can i do?

解决方案

Hi Mehdi,

Data Source=MEHDI-PC;Initial Catalog=bongah;Integrated Security=True

1) In the above connection string, try to replace MEHDI-PC to IP Address it will be more easy to understand in Connection string point of view.(optional)
2) I think you have missed the DB instance name in it.

Sample SQL Server Connection string should look like this

connectionString="SERVER=192.168.xx.xx\SQL2008;DataBase=DatabaseName;Initial Catalog=bongah;UID=Username;pwd=****;"

Hope this helps you a bit.

Regards,
RK

Use This Code in Web.config

<connectionstrings>
    <add name="NewConnectionString" connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\shoping.mdf;Integrated Security=True;User Instance=True" providername="System.Data.SqlClient" />
</connectionstrings>

Now Use this code in FileName.aspx.CS file

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NewConnectionString"].ConnectionString);

这篇关于实际主机中的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！