问题描述
这很奇怪，因为我能够通过 SSMS 2008R2 使用相同的连接字符串 ("Data Source=(LocalDB)v11.0;Integrated Security=true") 连接到 localDB
This is strange as I'm able to connect to localDB through SSMS 2008R2 with the same connection string ("Data Source=(LocalDB)v11.0;Integrated Security=true")
只有 C# 代码无法连接，我尝试使用 Connect Timeout=60 增加登录时间，但没有成功.
Only C# code is unable to connect, I have tried increasing login time with Connect Timeout=60 but no luck.
我还尝试指定数据库 Initial Catalog=<databasename> 其中 <databasename>是我通过 ssms 在 localdb 上创建的.
I have also tried specifying the database Initial Catalog=<databasename> where the <databasename> is the one I have created on localdb via ssms.
关于为什么不连接的任何指针?
Any pointers as to why is this not connecting?
推荐答案
有没有可能是因为你忘记了双转义反斜杠?你试过这个吗:
Any chance it is because you forgot to double-escape the backslash? Did you try this:
"数据源=(LocalDB)\v11.0;Integrated Security=true"
或者更好的是，您可以只使用 @ 标记来禁用整个连接字符串的字符转义:
Or even better, you could just use the @ mark to disable character escaping for the entire connection string:
@"Data Source=(LocalDB)v11.0;Integrated Security=true"
这篇关于在 VS2012 中无法连接到 localDB –“与 SQL Server 建立连接时发生与网络相关或特定于实例的错误..."的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！