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

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

  • Comments 4

Short one.

 

You are letting your user connect to your trusted SQL Server (fairly common scenario J)

They are connecting using SQL Authentication (it is recommended to use Windows Authentication however) an intermittently the application throws an exception:

 

Unhandled Exception: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 42.

   at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)

   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)

   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)

   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)

   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)

 

A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.

 

So, to illustrate:

 

            string cs = @"Data Source=server\instance;User=username;Password='password;Initial Catalog=database";

            using (SqlConnection con = new SqlConnection(cs))

            {

                try

                {

                    con.Open();

                    Console.WriteLine("We are connected...");

                    con.Close();

                }

                catch (Exception ex)

                {

                    Console.WriteLine(ex);

                }

            }

 

Will give the exception above.

 

So either escape the ‘ correctly (Password=\'password) or do not allow the single quote.

Leave a Comment
  • Please add 3 and 3 and type the answer here:
  • Post
  • thank you,sir!!it was problem in password i was missing pwd=password

  • Will give the exception above.

    So either escape the ‘ correctly (Password=\'password) or do not allow the single quote.

  • A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.A common scenario here is that the user has provided a string termination character in the username or password and that character is not correctly escaped.

  • Hi Can any one help me, i am getting this error "Format of the initialization string does not conform to specification starting at index 86".

    i am using in my application asp.net,EF, and for reports i am using sp and connection string.

Page 1 of 1 (4 items)