blocks|key|2210871|text|检查你的连接线。如果您需要帮助，请检查连接串，它有一个常用的列表。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2210872|常用的连接字符串：|2210873|+Server+2012|style|BOLD|2210874|标准安全|2210875|Server=myServerAddress;Database=myDataBase;User+Id=myUsername;Password=myPassword;|code-block|syntax|javascript|2210876|可信连接|2210877|Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;|2210878|到Server实例的连接|2210879|服务器选项中使用的服务器/实例名称语法与所有server连接字符串相同。|2210880|Server=myServerName\myInstanceName;Database=myDataBase;User+Id=myUsername;
Password=myPassword;|2210881|+Server+2005|2210882|2210883|Server=myServerAddress;Database=myDataBase;User+Id=myUsername;Password=myPassword;|2210884|2210885|2210886|2210887|2210888|Server=myServerName\myInstanceName;Database=myDataBase;User+Id=myUsername;Password=myPassword;|2210889|MySQL|2210890|标准|2210891|Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;|2210892|指定TCP端口|2210893|Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;|2210894|甲骨文|2210895|使用TNS的|2210896|Data+Source=TORCL;User+Id=myUsername;Password=myPassword;|2210897|使用集成安全|2210898|Data+Source=TORCL;Integrated+Security=SSPI;|2210899|使用没有tnsnames.ora的ODP.NET|2210900|Data+Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User+Id=myUsername;Password=myPassword;|2210901|entityMap|0|LINK|mutability|MUTABLE|url|http://www.connectionstrings.com/^0|J|3|0|0|0|0|C|0|0|4|0|0|0|4|0|0|A|2|0|0|0|0|C|0|0|4|0|0|0|4|0|0|A|2|0|0|0|0|5|0|0|2|0|0|0|7|0|0|0|3|0|0|0|0|6|0|0|0|O|0|0^^$0|@$1|2|3|4|5|6|7|27|8|@]|9|@$A|28|B|29|1|2A]]|C|$]]|$1|D|3|E|5|6|7|2B|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|2C|8|@$A|2D|B|2E|H|I]]|9|@]|C|$]]|$1|J|3|K|5|6|7|2F|8|@$A|2G|B|2H|H|I]]|9|@]|C|$]]|$1|L|3|M|5|N|7|2I|8|@]|9|@]|C|$O|P]]|$1|Q|3|R|5|6|7|2J|8|@$A|2K|B|2L|H|I]]|9|@]|C|$]]|$1|S|3|T|5|N|7|2M|8|@]|9|@]|C|$O|P]]|$1|U|3|V|5|6|7|2N|8|@$A|2O|B|2P|H|I]]|9|@]|C|$]]|$1|W|3|X|5|6|7|2Q|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|N|7|2R|8|@]|9|@]|C|$O|P]]|$1|10|3|11|5|6|7|2S|8|@$A|2T|B|2U|H|I]]|9|@]|C|$]]|$1|12|3|K|5|6|7|2V|8|@$A|2W|B|2X|H|I]]|9|@]|C|$]]|$1|13|3|14|5|N|7|2Y|8|@]|9|@]|C|$O|P]]|$1|15|3|R|5|6|7|2Z|8|@$A|30|B|31|H|I]]|9|@]|C|$]]|$1|16|3|T|5|N|7|32|8|@]|9|@]|C|$O|P]]|$1|17|3|V|5|6|7|33|8|@$A|34|B|35|H|I]]|9|@]|C|$]]|$1|18|3|X|5|6|7|36|8|@]|9|@]|C|$]]|$1|19|3|1A|5|N|7|37|8|@]|9|@]|C|$O|P]]|$1|1B|3|1C|5|6|7|38|8|@$A|39|B|3A|H|I]]|9|@]|C|$]]|$1|1D|3|1E|5|6|7|3B|8|@$A|3C|B|3D|H|I]]|9|@]|C|$]]|$1|1F|3|1G|5|N|7|3E|8|@]|9|@]|C|$O|P]]|$1|1H|3|1I|5|6|7|3F|8|@$A|3G|B|3H|H|I]]|9|@]|C|$]]|$1|1J|3|1K|5|N|7|3I|8|@]|9|@]|C|$O|P]]|$1|1L|3|1M|5|6|7|3J|8|@$A|3K|B|3L|H|I]]|9|@]|C|$]]|$1|1N|3|1O|5|6|7|3M|8|@]|9|@]|C|$]]|$1|1P|3|1Q|5|N|7|3N|8|@]|9|@]|C|$O|P]]|$1|1R|3|1S|5|6|7|3O|8|@$A|3P|B|3Q|H|I]]|9|@]|C|$]]|$1|1T|3|1U|5|N|7|3R|8|@]|9|@]|C|$O|P]]|$1|1V|3|1W|5|6|7|3S|8|@$A|3T|B|3U|H|I]]|9|@]|C|$]]|$1|1X|3|1Y|5|N|7|3V|8|@]|9|@]|C|$O|P]]|$1|1Z|3|-4|5|6|7|3W|8|@]|9|@]|C|$]]]|20|$21|$5|22|23|24|C|$25|26]]]]

Check your connection string. If you need help with it check <a href="http://www.connectionstrings.com/">Connection Strings</a>, which has a list of commonly used ones.

Commonly used Connection Strings:

<h1>SQL Server 2012</h1>

Standard Security

<pre><code>Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;
</code></pre>

Trusted Connection

<pre><code>Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
</code></pre>

Connection to a SQL Server instance

The server/instance name syntax used in the server option is the same for all SQL Server connection strings.

<pre><code>Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;
</code></pre>

<h1>SQL Server 2005</h1>

Standard Security

<pre><code>Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;
</code></pre>

Trusted Connection

<pre><code>Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
</code></pre>

Connection to a SQL Server instance

The server/instance name syntax used in the server option is the same for all SQL Server connection strings.

<pre><code>Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;
</code></pre>

<h1>MySQL</h1>

Standard

<pre><code>Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
</code></pre>

Specifying TCP port

<pre><code>Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
</code></pre>

<h1>Oracle</h1>

Using TNS

<pre><code>Data Source=TORCL;User Id=myUsername;Password=myPassword;
</code></pre>

Using integrated security

<pre><code>Data Source=TORCL;Integrated Security=SSPI;
</code></pre>

Using ODP.NET without tnsnames.ora

<pre><code>Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;
</code></pre>

blocks|key|388206|text|引用完整sp路径为我解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388207|var+command+=+new+SqlCommand("DatabaseName.dbo.StoredProcedureName",+conn)|code-block|syntax|javascript|388208|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Referencing the full sp path resolved this issue for me:

<pre><code>var command = new SqlCommand("DatabaseName.dbo.StoredProcedureName", conn)
</code></pre>

blocks|key|2210937|text|请确保连接字符串采用以下格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2210938|server=FOOSERVER;database=BLAH_DB;pooling=false;Connect+Timeout=60;Integrated+Security=SSPI；|blockquote|offset|length|style|BOLD|2210939|如果您的字符串缺少server标记，则该方法将返回此错误。|CODE|2210940|entityMap^0|0|0|6|0|9|6|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|O|8|@$E|P|F|Q|G|H]]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@$E|S|F|T|G|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|M|$]]

Make sure that your connection string is in this format:

<blockquote>
 server=FOOSERVER;database=BLAH_DB;pooling=false;Connect Timeout=60;Integrated Security=SSPI;
</blockquote>

If your string is missing the <code>server</code> tag then the method would return back with this error.

blocks|key|2210963|text|当您将网页从一个解决方案复制到另一个解决方案时，也会发生这种情况，然后运行解决方案，发现它在webconfig中具有不同的连接字符串名称。然后，在页面的设计视图中，不小心地更改属性面板中连接字符串的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2210964|最好只是在代码部分而不是设计中更改它。|2210965|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This also happens when you copy a web page from one solution to another, then you run your solution and find out that it has a different connection string name in the webconfig. Then you carelessly change the name of the connection string in the properties panel in the design view of the page. 

Better to just change it in the code portion instead of the design.

blocks|key|388286|text|我也遇到了同样的问题，最后我设法以以下方式解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388287|问题在于我的web.config中的连接字符串定义。|388288|<add+name="DefaultConnection"+connectionString="DefaultConnection_ConnectionString"+providerName="System.Data.SqlClient"/>|code-block|syntax|javascript|388289|由于我在管理用户和角色时使用了本地数据库，上述功能在本地非常有效。当我将应用程序转移到IIS时，本地DB不再可访问，此外，我还想在Server中使用我的DB。因此，我将上面的连接字符串更改为以下Server等效字符串：|388290|<add+name="DefaultConnection"+connectionString="data+source=MY_SQL_SERVER;+Initial+Catalog=MY_DATABASE_NAME;+Persist+Security+Info=true;+User+Id=sa;Password=Mybl00dyPa$$"+providerName="System.Data.SqlClient"/>|388291|注意:另外，假设您将从本地框中使用相同的Server+(万一您将它合并到本地web.config中--这正是我在本例中所做的)。|388292|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I had the same problem and finally I managed to resolve it in the following way:

The problem was in the connection string definition in my web.config.

<pre class="lang-html prettyprint-override"><code>&lt;add name="DefaultConnection" connectionString="DefaultConnection_ConnectionString" providerName="System.Data.SqlClient"/&gt;
</code></pre>



The above worked perfect locally because I used a local Database when I managed users and roles. When I transfered my application to IIS the local DB was not longer accessible, in addition I would like to use my DB in SQL Server. So I change the above connection string the following SQL Server DB equivalent:

<pre><code>&lt;add name="DefaultConnection" connectionString="data source=MY_SQL_SERVER; Initial Catalog=MY_DATABASE_NAME; Persist Security Info=true; User Id=sa;Password=Mybl00dyPa$$" providerName="System.Data.SqlClient"/&gt;
</code></pre>

NOTE: The above, also, suppose that you are going to use the same SQL Server from your local box (in case that you incorporate it into your local web.config - that is what exactly I did in my case).

blocks|key|388334|text|我的问题是，我将数据库日志代码添加到DB对象的构造函数中，这似乎对我的azure部署配置文件造成了破坏。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388335|FYI+-我简化了这个例子，在实际的代码中，这在生产中被关闭了(但仍然在代码中)|388336|public+class+MyDB+:+DbContext
{
++++public+MyDB()
++++{
+++++++++this.Database.Log+=+x+=>+{+Debug.WriteLine(x);+};
++++}
}|code-block|syntax|javascript|388337|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

My problem was I added database logging code to my constructor for a DB object, and this seemed to cause havoc on my azure deployment profile. 

FYI - I simplified this example, in the real code this was turned off in production (but still in the code)

<pre><code>public class MyDB : DbContext
{
 public MyDB()
 {
 this.Database.Log = x =&gt; { Debug.WriteLine(x); };
 }
}
</code></pre>

blocks|key|180314|text|我在连接字符串"Database==PESitecore1_master“中输入了错误|type|unstyled|depth|inlineStyleRanges|entityRanges|data|180315|<add+name="master"+connectionString="user+id=sa;password=xxxxx;Data+Source=APR9038KBD\SQL2014;Database==PESitecore1_master"/>|code-block|syntax|javascript|180316|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I had typo in my connection strings "Database==PESitecore1_master"

<pre><code>&lt;add name="master" connectionString="user id=sa;password=xxxxx;Data Source=APR9038KBD\SQL2014;Database==PESitecore1_master"/&gt;
</code></pre>

blocks|key|2211113|text|将包含DbContext类的项目设置为启动项目。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2211114|在调用enable-migrations时，我收到了这个错误。即使在Package+Manager+Console中，我选择了正确的Default+project，它仍然在查看该启动项目的web.config文件，其中不存在连接字符串。|2211115|entityMap^0|3|9|0|3|H|Y|N|1U|F|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|I|$]]

Set the project containing your <code>DbContext</code> class as the startup project.

I was getting this error while calling <code>enable-migrations</code>.
Even if in the <code>Package Manager Console</code> I selected the right <code>Default project</code>, it was still looking at the web.config file of that startup project, where the connection string wasn't present.

blocks|key|388444|text|我也有同样的问题。在当地，该网站运行良好，但在蔚蓝的情况下，它将失败与上述信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388445|问题是在ctor中设置连接字符串，如下所示：|388446|++++public+DatabaseContext()+
++++{
++++++++Database.Connection.ConnectionString+=+ConfigurationManager.ConnectionStrings["db"].ConnectionString;
++++}|code-block|syntax|javascript|388447|不起作用，这将：|388448|++++public+DatabaseContext()+:+base("db")
++++{
++++}|388449|打败了我..。|388450|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I had the same problem. Locally the site ran fine, but on azure it would fail with the message above.

turns out the problem was setting the connectionstring in the ctor, like this:

<pre><code> public DatabaseContext() 
 {
 Database.Connection.ConnectionString = ConfigurationManager.ConnectionStrings["db"].ConnectionString;
 }
</code></pre>

Does NOT work, this will: 

<pre><code> public DatabaseContext() : base("db")
 {
 }
</code></pre>

Beats me..

blocks|key|388504|text|我通过更改我的ASP.NET+Web的发布设置上的连接字符串来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388505|查看我在这篇文章上的答案：如何修复错误：：初始化字符串的格式不符合规范，从索引0:：|offset|length|388506|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/9040266/how-to-fix-error-format-of-the-initialization-string-does-not-conform-to-speci/#43965574^0|0|D|T|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I solved this by changing the connection string on the publish settings of my ASP.NET Web Api.

Check my answer on this post: <a href="https://stackoverflow.com/questions/9040266/how-to-fix-error-format-of-the-initialization-string-does-not-conform-to-speci/#43965574">How to fix error ::Format of the initialization string does not conform to specification starting at index 0::</a>

blocks|key|2211178|text|我也犯了同样的错误。在我的例子中，这是因为我丢失了连接字符串中密码的结尾引号。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211179|从现在开始|2211180|<add+name="db"+connectionString="server=local;database=dbanme;user+id=dbuser;password='password"+providerName="System.Data.SqlClient"+/>|code-block|syntax|javascript|2211181|至|2211182|<add+name="db"+connectionString="server=local;database=dbanme;user+id=dbuser;password='password'"+providerName="System.Data.SqlClient"+/>|2211183|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I had the same error. In my case, this was because I was missing an closing quote for the password in the connection string. 

Changed from this

<pre><code>&lt;add name="db" connectionString="server=local;database=dbanme;user id=dbuser;password='password" providerName="System.Data.SqlClient" /&gt;
</code></pre>

To

<pre><code>&lt;add name="db" connectionString="server=local;database=dbanme;user id=dbuser;password='password'" providerName="System.Data.SqlClient" /&gt;
</code></pre>

blocks|key|388543|text|这可能对某人有帮助..。我的密码包含一个分号，所以面对这个问题，issue.So在引号中添加了密码。这真是个愚蠢的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388544|我修改了以下内容：|388545|<add+name="db"+connectionString="server=local;database=dbanme;user+id=dbuser;password=pass;word"+providerName="System.Data.SqlClient"+/>|code-block|syntax|javascript|388546|至|388547|<add+name="db"+connectionString="server=local;database=dbanme;user+id=dbuser;password='pass;word'"+providerName="System.Data.SqlClient"+/>|388548|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

This might help someone.. 
My password contained a semicolon so was facing this issue.So added the password in quotes. It was really a silly mistake.

I changed the following :

<pre><code>&lt;add name="db" connectionString="server=local;database=dbanme;user id=dbuser;password=pass;word" providerName="System.Data.SqlClient" /&gt;
</code></pre>

to

<pre><code>&lt;add name="db" connectionString="server=local;database=dbanme;user id=dbuser;password='pass;word'" providerName="System.Data.SqlClient" /&gt;
</code></pre>

blocks|key|181116|text|我也有同样的问题，后来发现到IIS的部署没有正确设置连接字符串。在IIS中查看站点的连接字符串时，它们是“$(ReplacableToken_devConnection-Web.config+Connection+String_0)”，而不是实际的连接字符串。我在那里更新了它们，一切都如预期的那样工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|181117|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same issue, came to find out that the deployment to IIS did not set the connection strings correctly. they were '$(ReplacableToken_devConnection-Web.config Connection String_0)' when viewing the connection strings of the site in IIS, instead of the actual connection string. I updated them there, and all worked as expected

blocks|key|388568|text|我将连接字符串配置复制并粘贴到测试项目中，并开始遇到此错误。连接字符串在我的WebAPI项目中运行良好。这是我的解决办法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388569|var+connection+=+ConfigurationManager.ConnectionStrings["MyConnectionString"];
var+unitOfWork+=+new+UnitOfWork(new+SqlConnection(connection.ConnectionString));|code-block|syntax|javascript|388570|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I copied and pasted my connection string configuration into my test project and started running into this error. The connection string worked fine in my WebAPI project. Here is my fix.

<pre><code>var connection = ConfigurationManager.ConnectionStrings["MyConnectionString"];
var unitOfWork = new UnitOfWork(new SqlConnection(connection.ConnectionString));
</code></pre>

blocks|key|2211223|text|我删除了“在连接字符串的末尾，它工作了。”|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211224|而不是|2211225|App=EntityFramework&quot;|code-block|syntax|javascript|2211226|使用|2211227|App=EntityFramework;|2211228|将DefaultConnection设置如下|2211229|<add+name="DefaultConnection"+connectionString="data+source=(local);initial+catalog=NamSdb;persist+security+info=True;user+id=sa;password=sa;MultipleActiveResultSets=True;App=EntityFramework;"+providerName="System.Data.SqlClient"+/>|2211230|注:在connectionString中不包括：
X\x元数据信息：“元数据=res://*/”
X编码引号：“|blockquote|2211231|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Y|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Z|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|10|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|11|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|S|7|12|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|U|$]]

I removed &amp;quot at the end of the connection string and it worked

Instead of 

<pre><code>App=EntityFramework&amp;quot;
</code></pre>

Used 

<pre><code>App=EntityFramework;
</code></pre>

<h3>Set DefaultConnection as below</h3>

<pre><code>&lt;add name="DefaultConnection" connectionString="data source=(local);initial catalog=NamSdb;persist security info=True;user id=sa;password=sa;MultipleActiveResultSets=True;App=EntityFramework;" providerName="System.Data.SqlClient" /&gt;
</code></pre>

<blockquote>
 Note : In connectionString Do not include : 
 |x| Metadata info : "metadata=res://*/" 
 |x| Encoded Quotes : "&quot;" 
</blockquote>

blocks|key|181127|text|我的问题不是我提供的连接字符串是错误的，或者我认为我使用的app.config中的连接字符串是错误的，而是我使用了错误的app.config。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|181128|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

My problem wasn't that the connection string I was providing was wrong, or that the connection string in the app.config I thought I was using was wrong, but that I was using the wrong app.config.

blocks|key|388599|text|有时，Server服务尚未启动。这可能会产生错误。转到Services并启动Server。这应该能让它发挥作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388600|📷|atomic|offset|length|388601|​|388602|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/e2c489bfa3aa0ead78c365f43a511ab7.jpg|imageAlt^0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@$E|T|F|U|1|V]]|A|$]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P|Q|-4]]]]

Sometimes the Sql Server service has not been started. This may generate the error. Go to Services and start Sql Server. This should make it work.
<a href="https://i.stack.imgur.com/Tm9fl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tm9fl.jpg" alt="enter image description here"></a>

blocks|key|2211281|text|对于另一个不幸的灵魂，即管理使用内联sql数据源的遗留webforms应用程序以及存储在web.config中的连接字符串，如果您像<%25APSDataConnectionString%25>一样访问连接字符串，而不是访问<%25$+ConnectionStrings:MyConnectionString+%25>，则可能会出现此错误。这种情况发生在我们将.NET从3.5升级到4.x时。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211282|<asp:DropDownList+ID="ddl"+runat="server"+DataSourceID="SqlDataSource1"
++DataTextField="value"+DataValueField="id"></asp:DropDownList>++++++++++++++++
<asp:SqlDataSource+ID="SqlDataSource1"+runat="server"+
++ConnectionString="<%25$+ConnectionStrings:MyConnectionString+%25>"
++SelectCommand="select+id,+value+from+a_table">
</asp:SqlDataSource>|code-block|syntax|javascript|2211283|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For the one other unfortunate soul that is managing a legacy webforms application that uses an inline sqldatasource, along with connection strings stored in web.config, then you may get this error if you access your connection string like &lt;%APSDataConnectionString%> instead of 
&lt;%$ ConnectionStrings:MyConnectionString %>. This happened to us when upgrading .NET from 3.5 to 4.x.

<pre><code>&lt;asp:DropDownList ID="ddl" runat="server" DataSourceID="SqlDataSource1"
 DataTextField="value" DataValueField="id"&gt;&lt;/asp:DropDownList&gt; 
&lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
 ConnectionString="&lt;%$ ConnectionStrings:MyConnectionString %&gt;"
 SelectCommand="select id, value from a_table"&gt;
&lt;/asp:SqlDataSource&gt;
</code></pre>

blocks|key|180467|text|在我的例子中，问题是在服务器上，应用程序使用了一个不同的appsettings.json文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|180468|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case the problem was that on the server, a different appsettings.json file was used by the application.

blocks|key|2211320|text|在我的例子中，我遇到了一个类似的错误：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211321|应用程序引发一个未处理的异常。System.ArgumentException:初始化字符串的格式不符合从索引91开始的规范。|2211322|我将连接字符串更改为：|2211323|Server=.;Database=dbname;User+Id=myuserid;Password=mypassword“|2211324|至：|2211325|Server=.;Database=dbname;User+Id=myuserid；密码=“mypassword”|2211326|我在密码中添加了单引号。|2211327|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

In my case, I got a similar error:

An unhandled exception was thrown by the application. System.ArgumentException: Format of the initialization string does not conform to specification starting at index 91.

I change my connection string from:

Server=.;Database=dbname;User Id=myuserid;Password=mypassword"

to:

Server=.;Database=dbname;User Id=myuserid;Password='mypassword'"

and it works, I added single quotes to the password.

blocks|key|388743|text|我也有这个错误，并能够按照如下方式解决它:我以前将连接字符串写入我创建的一个部分(注意额外的"s")，并试图连接到导致错误的数据库。它是一个ASP.NET核心应用程序，所以我想用.GetConnectionString方法连接到它(关于这个这里的详细信息)。这个方法似乎隐式地在"ConnectionStrings"-section中搜索一个连接字符串，而这个连接字符串并不存在。当我将它更改/更正为"ConnectionStrings“时，它就像预期的那样工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|388744|entityMap|0|LINK|mutability|MUTABLE|url|https://www.youtube.com/watch?v=xMktEpPmadI^0|3C|2|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I had this error too and was able to solve it as follows:
I previously wrote the connectionstring to the appsettings.json into a section that I created (ConnectionsStrings (notice the extra "s") and tried to connect to my database which caused the error. It was an ASP.NET CORE application and so I wanted to connect to it with the .GetConnectionString Method (details on that <a href="https://www.youtube.com/watch?v=xMktEpPmadI" rel="nofollow noreferrer">here</a>). It seems that this method implicitly searches for a connectionstring in the "ConnectionStrings"-section, which didn't exist. When I changed/corrected it to "ConnectionStrings" it worked as expected.

blocks|key|388768|text|如我所知，每当解决方案中有超过一个连接字符串时(当前项目、启动项目、.)，您可能会遇到此错误|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388769|此链接可能帮助您点击。|offset|length|388770|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/25161419/telerik-report-not-working/62641276#62641276^0|0|8|2|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

As I Know, whenever you have more than 1 connection string in your solution(your current project, startup project,...), you may confront with this error
this link may help you
<a href="https://stackoverflow.com/questions/25161419/telerik-report-not-working/62641276#62641276">click</a>

blocks|key|2211445|text|我也有同样的问题花了一整天。当索引0是连接字符串时，此错误肯定会指示连接字符串问题。我的问题是在创业课上。我用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211446|var+connection+=+Configuration["ConnectionStrings:DefaultConnection"];
services.AddControllersWithViews();
services.AddApplicationInsightsTelemetry();
services.AddDbContextPool<Models.PicTickContext>(options+=>+options.UseSqlServer("connection"));`|code-block|syntax|javascript|2211447|这是错误的，相反，请使用以下命令：|2211448|services.AddControllersWithViews();
services.AddApplicationInsightsTelemetry();
services.AddDbContextPool<Models.PicTickContext>(options+=>+options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));|2211449|我的问题解决了。|2211450|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I had the same problem spent an entire day. The error indicates Connection string issue for sure as index 0 is connection string. My issue was in the Startup class. I used:
<pre class="lang-cs prettyprint-override"><code>var connection = Configuration[&quot;ConnectionStrings:DefaultConnection&quot;];
services.AddControllersWithViews();
services.AddApplicationInsightsTelemetry();
services.AddDbContextPool&lt;Models.PicTickContext&gt;(options =&gt; options.UseSqlServer(&quot;connection&quot;));`
</code></pre>
which is wrong instead use this:
<pre class="lang-cs prettyprint-override"><code>services.AddControllersWithViews();
services.AddApplicationInsightsTelemetry();
services.AddDbContextPool&lt;Models.PicTickContext&gt;(options =&gt; options.UseSqlServer(Configuration.GetConnectionString(&quot;DefaultConnection&quot;)));
</code></pre>
and my problem was solved.

blocks|key|181222|text|我犯了这个错误，结果发现原因是我用一个使用/结束使用的包围了一个(新的)制表机。只需更改tableadapter，使其停留更长的时间(在我的实例中，类的持续时间)，就为我修复了这个问题。也许这能帮上忙。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|181223|entityMap^0|Q|23|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

I had this error and it turned out that the cause was that I had surrounded a (new) tableadapter with a Using/End Using. Just changing the tableadapter to stay live for longer (duration of class in my instance) fixed this for me. Maybe this will help someone.

blocks|key|2211552|text|您必须使用从DbContext派生的类的完全相同的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211553|示例:注意类名是："CreativeFormDbContext“|2211554|++public+class+CreativeFormDbContext+:+DbContext
++++{
++++++++public+DbSet<Person>+Persons+{+get;+set;+}

++++++
++++}|code-block|syntax|javascript|2211555|app.config文件:名称属性为"CreativeFormDbContext“|2211556|<connectionStrings>+
++++<add+name="CreativeFormDbContext"+providerName="MySql.Data.MySqlClient"
++++++++connectionString="Server=localhost;Database=creativeform;Uid=username;Pwd=pass"/>
++</connectionStrings>|2211557|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You have to use the exact same name of the class that you derived from DbContext.
example: Note that the class name is: &quot;CreativeFormDbContext&quot;
<pre><code> public class CreativeFormDbContext : DbContext
 {
 public DbSet&lt;Person&gt; Persons { get; set; }

 
 }
</code></pre>
app.config file: And the name property is &quot;CreativeFormDbContext&quot;
<pre><code>&lt;connectionStrings&gt; 
 &lt;add name=&quot;CreativeFormDbContext&quot; providerName=&quot;MySql.Data.MySqlClient&quot;
 connectionString=&quot;Server=localhost;Database=creativeform;Uid=username;Pwd=pass&quot;/&gt;
 &lt;/connectionStrings&gt;
</code></pre>

blocks|key|388935|text|SQLite在aspnetcore中遇到了这个问题。我写|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388936|+"DefaultSQLiteConnection":+"MyBlog.db"|code-block|syntax|javascript|388937|而不是|388938|"DefaultSQLiteConnection":+"Data+Source+=+MyBlog.db"|388939|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Got this problem with SQLite in aspnetcore. I wrote
<pre><code> &quot;DefaultSQLiteConnection&quot;: &quot;MyBlog.db&quot;
</code></pre>
instead of
<pre><code>&quot;DefaultSQLiteConnection&quot;: &quot;Data Source = MyBlog.db&quot;
</code></pre>

blocks|key|2211600|text|我生成的密码包含了一些在AWS中有效的字符，但由于某种原因，我的.NET应用程序无法处理它。对我起作用的解决方案是生成新的密码，而不需要像`(回勾)这样的字符。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211601|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

My generated password contained few characters that were valid in AWS RDS, but for some reason my .NET app could not handle it. The solutions that worked for me, was to generate new password without characters like ` (backtick).

blocks|key|2211603|text|就我而言，这是..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211604|index:+58|code-block|syntax|javascript|2211605|但最终发生的是生成的密码中有一个单引号。Server接受了这一点，但我的连接字符串在解析它时遇到了问题。希望这能节省至少几分钟的时间，因为我花了一到两个小时才重新了解了发生的事情。干杯|2211606|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In my case, it was...
<pre><code>index: 58
</code></pre>
but what ended up happening was the password generated had a single quote in it. SQL Server accepted that, but my connection string had trouble parsing it. Hope this saves someone at least a few minutes, because it cost me an hour to two before I relized what was going on. cheers

blocks|key|2211618|text|希望这对将来的人有帮助。我的连接字符串有用双引号包装的空值，例如用户ID="“。因此，为了解决这个问题，我不得不避开双引号。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2211619|Dim+ConString+=+"Data+Source=MYSERVER;User+ID="";Initial+Catalog=Northwinds..."

ConString+=+ConString.Replace("""",+"""""")|code-block|syntax|javascript|2211620|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Hope this helps someone in the future. My connection string had blank values wrapped in double quotes, e.g. User ID=&quot;&quot;. So to resolve it I had to escape the double quotes.
<pre><code>Dim ConString = &quot;Data Source=MYSERVER;User ID=&quot;&quot;;Initial Catalog=Northwinds...&quot;

ConString = ConString.Replace(&quot;&quot;&quot;&quot;, &quot;&quot;&quot;&quot;&quot;&quot;)
</code></pre>

I have an ASP.NET application which runs fine on my local development machine.
When I run this application online, it shows the following error:
<blockquote>
Format of the initialization string does not conform to specification starting at index 0
</blockquote>
Why is this appearing, and how can I fix it?

Format of the initialization string does not conform to specification starting at index 0

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个在本地开发机器上运行良好的ASP.NET应用程序。当我在线运行此应用程序时，它会显示以下错误：初始化字符串的格式不符合从索引0开始的规范。为什么会出现这种情况，我该如何解决呢？

问初始化字符串的格式不符合从索引0开始的规范。
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问初始化字符串的格式不符合从索引0开始的规范。EN