无法从app config读取连接字符串-Java 学习之路

这是我在App.config中的连接字符串

<connectionStrings>
<add name="CostAllocationEntities2" connectionString="Data Source=PC210090\SQLEXPRESS; Initial Catalog=master;Persist Security Info=True;
         User ID=sa;password=password-1;multipleactiveresultsets=True; " providerName="System.Data.SqlClient"/>

</connectionStrings>

     ServerConnection connection = new ServerConnection(ConfigurationManager.ConnectionStrings["CostAllocationEntities2"].ConnectionString);

                    Server sqlServer = new Server(connection);

                    Database db = sqlServer.Databases[strDBName];

例外：无法连接到服务器数据源= PC210090 \ SQLEXPRESS;初始目录=主;持久安全信息=真;用户ID = sa;密码=密码-1; multipleactiveresultsets = True; .

1 回答

你想做什么，不确定但改变你的连接字符串

connectionString="Data Source=PC210090\\SQLEXPRESS;

Initial Catalog=master; ;不要连接到 master DB而是提供用户数据库名称，如 Sample .

<connectionStrings>
<add name="CostAllocationEntities2" connectionString="Data Source=PC210090\\SQLEXPRESS; Initial Catalog=Sample;Persist Security Info=True; User ID=test;password=test;multipleactiveresultsets=True; " providerName="System.Data.SqlClient"/>
</connectionStrings>

在你的代码背后

一旦你有连接字符串创建一个SqlConnection实例就好

SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["CostAllocationEntities2"].ConnectionString);

打开连接

connection.Open();

回复于 2024-05-12T07:01:46+08:00

无法从app config读取连接字符串

1 回答

相关问题