连接字符串中的 AllowUserVariables - SQL Server Express [英] AllowUserVariables in connection string - SQL Server Express
本文介绍了连接字符串中的 AllowUserVariables - SQL Server Express的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试在我的连接字符串中添加AllowUserVariables=true"以使用 C# 访问 SQL Server Express.但是一个 Keyword not supported: 'allowuservariables'.
抛出异常.我该如何解决?
I am trying to add "AllowUserVariables=true" in my connection string to access SQL Server Express using C#. But an Keyword not supported: 'allowuservariables'.
exception is thrown.
How can I resolve this?
推荐答案
仅在 ms SQL server 中,您可以运行此命令:
Only in ms SQL server, you can run this command:
<add name="ConnectionString_LIVE_customer_support" connectionString="server=REMOVED;port=REMOVED;User Id=REMOVED;password=REMOVED;Persist Security Info=True;database=customer_support;Sql Server Mode=True;Allow User Variables=True" providerName="MySql.Data.MySqlClient" />
这篇关于连接字符串中的 AllowUserVariables - SQL Server Express的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文