Escape quote in web.config connection string

by

Use " instead of " to escape it.

web.config is an XML file so you should use XML escaping.

connectionString="Server=dbsrv;User ID=myDbUser;Password=somepass"word"

See this forum thread.

Update:

" should work, but as it doesn’t, have you tried some of the other string escape sequences for .NET? \" and ""?

Update 2:

Try single quotes for the connectionString:

connectionString='Server=dbsrv;User ID=myDbUser;Password=somepass"word'

Or:

connectionString='Server=dbsrv;User ID=myDbUser;Password=somepass"word'

Update 3:

From MSDN (SqlConnection.ConnectionString Property):

To include values that contain a semicolon, single-quote character, or double-quote character, the value must be enclosed in double quotation marks. If the value contains both a semicolon and a double-quote character, the value can be enclosed in single quotation marks.

So:

connectionString="Server=dbsrv;User ID=myDbUser;Password='somepass"word'"

The issue is not with web.config, but the format of the connection string. In a connection string, if you have a " in a value (of the key-value pair), you need to enclose the value in '. So, while Password=somepass"word does not work, Password='somepass"word' does.

More Related Contents:

  1. Setting up connection string in ASP.NET to SQL SERVER
  2. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’
  3. Using different Web.config in development and production environment
  4. How do you modify the web.config appSettings at runtime?
  5. Access-control-allow-origin with multiple domains
  6. Forms authentication timeout vs sessionState timeout
  7. Avoid web.config inheritance in child web application using inheritInChildApplications
  8. Which gets priority, maxRequestLength or maxAllowedContentLength?
  9. ASP.NET web.config: configSource vs. file attributes
  10. How to prevent an ASP.NET application restarting when the web.config is modified?
  11. Error to use a section registered as allowDefinition=’MachineToApplication’ beyond application level
  12. Adding machineKey to web.config on web-farm sites
  13. Difference between and ?
  14. Reading web.config from JavaScript
  15. ASP.NET: HTTP Error 500.19 – Internal Server Error 0x8007000d
  16. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  17. HTTP Error 500.19 – Internal Server Error
  18. How to configure invariant culture in ASP.NET globalization?
  19. What are the Web.Debug.config and Web.Release.Config files for?
  20. Nested ASP.NET ‘application’ within IIS inheriting parent config values?
  21. Store String Array In appSettings?
  22. How to encrypt one entry in web.config
  23. Web Config Transform not working
  24. Is it possible to configure a location in Web.config to only allow local connections
  25. The configuration section ‘system.web.extensions’ cannot be read because it is missing a section declaration
  26. web.config and app.config confusion
  27. Specify more than one directory in Web.Config’s Location Path element
  28. Editing Web.config programmatically
  29. How can I reference an appSetting in a different part of web.config
  30. URL Routing, Image Handler & “A potentially dangerous Request.Path value”

Leave a Comment