“初始目录"有什么意义?在 SQL Server 连接字符串中? [英] What is the point of "Initial Catalog" in a SQL Server connection string?

问题描述

我见过的每个 SQL Server 连接字符串看起来都像这样:

Every SQL Server connection string I ever see looks something like this:

Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database;
    Integrated Security=SSPI;

我需要初始目录设置吗?(显然不是，因为我正在开发的应用程序似乎没有它就可以工作.)

Do I need the Initial Catalog setting? (Apparently not, since the app I'm working on appears to work without it.)

那么，它有什么用?

推荐答案

如果连接字符串中的用户名可以访问多个数据库，则必须指定希望连接字符串连接到的数据库.如果您的用户只有一个可用的数据库，那么您是对的，这无关紧要.但最好将其放入连接字符串中.

If the user name that is in the connection string has access to more then one database you have to specify the database you want the connection string to connect to. If your user has only one database available then you are correct that it doesn't matter. But it is good practice to put this in your connection string.

这篇关于“初始目录"有什么意义?在 SQL Server 连接字符串中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！