{"初始化字符串的格式不符合从索引0开始的规范。“} [英] {"Format of the initialization string does not conform to specification starting at index 0."}

问题描述

当我将连接字符串传递给Connection构造函数时，它在Windows窗体应用程序中给出上述异常

 {初始化字符串的格式不是符合从索引0开始的规格。} 

我尝试过：



app.config中的连接字符串如下

< add name =DBConnectionStringconnectionString =Data Source = SONALI \\ \\ HPPAVSQLEXPRESS;初始目录= testdb;持久安全信息=真;用户ID = sa; Passwordadmin123providerName =System.Data.SqlClient/> 

然后我正在读取连接字符串并存储在字符串变量

中

 public Form1（）
 {
 InitializeComponent（）; 
} 
 
 string connectionstring = ConfigurationManager.ConnectionStrings [DBConnectionString]。ConnectionString; 
 

然后将此字符串变量传递给连接类构造函数

 SqlConnection connection = new SqlConnection（connectionstring）; 
 

但这里给出了上述异常

解决方案

< blockquote>到MS SQL实例的连接字符串以 Server = 开头，而不是 Data Source = 。

您应该查看连接字符串参考 [ ^ ]

< add name =DBConnectionStringconnectionString =Data Source = SONALI \ HPPAVSQLEXPRESS;初始目录= testdb;持久安全信息=真;用户ID = sa;  Passwordadmin123 providerName =System.Data.SqlClient/> 

试试

< add name =DBConnectionStringconnectionString =Data Source = SONALI \ HPPAVSQLEXPRESS;初始目录= testdb;持久安全信息= True;用户ID = sa; 密码= admin123 providerName =System.Data.SqlClient/> 

when I passing connection string to Connection constructor it giving above exception in windows form application

{"Format of the initialization string does not conform to specification starting at index 0."}

What I have tried:

Connection string in app.config is as follows

<add name="DBConnectionString" connectionString="Data Source=SONALI\HPPAVSQLEXPRESS;Initial Catalog=testdb;Persist Security Info=True;User ID=sa;Passwordadmin123" providerName="System.Data.SqlClient" />

then I am reading Connection string and stored in string Variable
as

public Form1()
       {
           InitializeComponent();
       }

       string connectionstring = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;

then passing this string variable to connection class constructor as

SqlConnection connection = new SqlConnection(connectionstring);

but here it is giving above mentioned exception

解决方案

A connection string to a MS SQL instance begins with Server=, not Data Source=.
You should have a look at The Connection Strings Reference[^]

<add name="DBConnectionString" connectionString="Data Source=SONALI\HPPAVSQLEXPRESS;Initial Catalog=testdb;Persist Security Info=True;User ID=sa;Passwordadmin123" providerName="System.Data.SqlClient" />

try

<add name="DBConnectionString" connectionString="Data Source=SONALI\HPPAVSQLEXPRESS;Initial Catalog=testdb;Persist Security Info=True;User ID=sa;Password=admin123" providerName="System.Data.SqlClient" />

这篇关于{&quot;初始化字符串的格式不符合从索引0开始的规范。“}的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！