连接打开错误 [英] connection open error

问题描述

我使用了此代码

i used this code

SqlConnection Con =new SqlConnection("Data Source=ZENITH\SQLEXPRESS;Initial Catalog=alu;Integrated Security=SSPI");

但是此行显示错误无法识别的转义序列..pl告诉解决方案err

but this line show error Unrecongnized escape sequence..pl tell solution ths err

推荐答案

无法识别的转义序列为"\S".没收到?使用@"Data Source=ZENITH\SQL...".阅读有关C#字符串文字的信息.前缀"@"使原义语法变得冗长:"\"将被视为字符，而不是"\r"，"\n"，"\\"，等.编写此文字的另一种方法是用非详细语法"\\":"Data Source=ZENITH\\SQL...".

—SA

Unrecognized escape sequence is "\S". Did not get it? Use @"Data Source=ZENITH\SQL...". Read about C# string literals. The prefix "@" makes the literal syntax verbose: "\" will be considered as a character, not as the escape character used in "\r", "\n", "\\", etc. Another way to write this literal is "\\" in non-verbose syntax: "Data Source=ZENITH\\SQL...".

—SA

在前面加上"@"字符:

Stick a ''@'' character in the front:

SqlConnection Con =new SqlConnection("Data Source=ZENITH\SQLEXPRESS;Initial Catalog=alu;Integrated Security=SSPI");

成为

SqlConnection Con =new SqlConnection(@"Data Source=ZENITH\SQLEXPRESS;Initial Catalog=alu;Integrated Security=SSPI");

这将禁用字符串的转义序列处理，因此"\"字符不会给您造成问题.

That will disable Escape sequence processing for the string, so the the ''\'' character doesn''t cause you problems.

我认为您会收到此错误，因为您使用了单斜杠数据源值中的"\".尝试以下任何一种方法:-

1)SqlConnection Con =新的SqlConnection(@数据源= ZENITH \ SQLEXPRESS；初始目录= alu；集成安全性= SSPI")；

2)SqlConnection Con =新的SqlConnection(数据源= ZENITH \\ SQLEXPRESS；初始目录= alu；集成安全性= SSPI")；

I think you get this error because you use the single slash "\" in the Data Source value. Try anyone of the below:-

1) SqlConnection Con =new SqlConnection(@"Data Source=ZENITH\SQLEXPRESS;Initial Catalog=alu;Integrated Security=SSPI");

2)SqlConnection Con =new SqlConnection("Data Source=ZENITH\\SQLEXPRESS;Initial Catalog=alu;Integrated Security=SSPI");

这篇关于连接打开错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！