This rather "Strange and UnCommon" error comes up mostly while connecting do database via your C# application.
Reason: - In your connection string, when there is a escape sequence (\), C# converts it to "\\" so that it could be treated the way it needs to.
Therefore if you provide a connection string as "DataSource=ServerName\SQL", c# automatically converts it to "DataSource=ServerName\\SQL" and reads it the way it needs to.
However, if we actually provide the string something like "DataSource=ServerName\\SQL" (With Double Back Slashes), then it raises this error causing "Instance Failure".
Solution: Use a SINGLE ( \ ) instead of Double ( \\ ).
Reason: - In your connection string, when there is a escape sequence (\), C# converts it to "\\" so that it could be treated the way it needs to.
Therefore if you provide a connection string as "DataSource=ServerName\SQL", c# automatically converts it to "DataSource=ServerName\\SQL" and reads it the way it needs to.
However, if we actually provide the string something like "DataSource=ServerName\\SQL" (With Double Back Slashes), then it raises this error causing "Instance Failure".
Solution: Use a SINGLE ( \ ) instead of Double ( \\ ).
No comments:
Post a Comment