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

问题描述

我有我的运行本地开发机器上精美的ASP.Net应用程序。

当我在网上运行该应用程序，它显示了以下错误

  

初​​始化字符串的格式不符合规范
  从索引0

解决方案

检查您的连接字符串。如果你需要用它帮助检查连接字符串，里面有常用的列表。

常用的连接字符串：

SQL Server 2012中

标准安全性的

 服务器= myServerAddress;数据库= MyDatabase的;用户ID =名为myUsername;密码= MYPASSWORD;
 

可信连接的

 服务器= myServerAddress;数据库= MyDatabase的; Trusted_Connection = TRUE;
 

连接到SQL Server实例的

的服务器选项一起使用的服务器/实例名称语法对于所有SQL Server连接字符串相同。的

 服务器= myServerName \\ myInstanceName;数据库= MyDatabase的;用户ID =名为myUsername;
密码= MYPASSWORD;
 

SQL Server 2005中

标准安全性的

 服务器= myServerAddress;数据库= MyDatabase的;用户ID =名为myUsername;密码= MYPASSWORD;
 

可信连接的

 服务器= myServerAddress;数据库= MyDatabase的; Trusted_Connection = TRUE;
 

连接到SQL Server实例的

的服务器选项一起使用的服务器/实例名称语法对于所有SQL Server连接字符串相同。的

 服务器= myServerName \\ myInstanceName;数据库= MyDatabase的;用户ID =名为myUsername;密码= MYPASSWORD;
 

的MySQL

标准的

 服务器= myServerAddress;数据库= MyDatabase的; UID =名为myUsername; PWD = MYPASSWORD;
 

指定的TCP端口的

 服务器= myServerAddress;端口= 1234;数据库= MyDatabase的; UID =名为myUsername; PWD = MYPASSWORD;
 

的Oracle

是TNS

 数据源=的TORC1;用户ID =名为myUsername;密码= MYPASSWORD;
 

使用集成的安全的

 数据源=的TORC1;集成安全性= SSPI;
 

使用ODP.NET没有的tnsnames.ora 的

 数据Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User ID =名为myUsername;密码= MYPASSWORD;
 

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

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

解决方案

Check your connection string. If you need help with it check Connection Strings, which has a list of commonly used ones.

Commonly used Connection Strings:

SQL Server 2012

Standard Security

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

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.

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;

SQL Server 2005

Standard Security

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

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.

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

MySQL

Standard

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Specifying TCP port

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Oracle

Using TNS

Data Source=TORCL;User Id=myUsername;Password=myPassword;

Using integrated security

Data Source=TORCL;Integrated Security=SSPI;

Using ODP.NET without tnsnames.ora

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

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