以编程方式从窗口服务中选择数据源 [英] Programmatically selecting data source from a window service

问题描述

database.OpenEx(_T("Provider = SQLOLEDB.1; DSN = XXX; Data Source =(local)\ SQLEXPRESS; Initial Catalog = XXX"));

上面的连接在独立的mfc应用程序下很好，但是在窗口服务中时，总是弹出选择数据源窗口，让用户从
中进行选择
thx

JS

database.OpenEx(_T("Provider=SQLOLEDB.1;DSN=XXX;Data Source=(local)\SQLEXPRESS;Initial Catalog=XXX"));

above connecting is good under a standalone mfc application but when in window service it always pop up select data source window let user choice from

thx

JS

推荐答案

如果这是您的整个连接字符串，则可能需要为数据源添加登录信息.默认情况下，该服务将以LOCAL SERVICE帐户运行，而SQL Server可能不喜欢该帐户.

"Provider = SQLOLEDB.1; DSN = XXX;数据源=(本地)\ SQLEXPRESS;初始目录= XXX;用户ID = 用户名;密码= 密码"

或...具有集成安全性(将使用运行该服务的帐户)

提供程序= SQLOLEDB.1; DSN = XXX;数据源=(本地)\ SQLEXPRESS;初始目录= XXX;集成安全性= SSPI"

HTH！

杰森

If that is your entire connection string, you probably need to add login information for the datasource. By default, the service would run as the LOCAL SERVICE account and the SQL Server probably doesn''t like that.

"Provider=SQLOLEDB.1;DSN=XXX;Data Source=(local)\SQLEXPRESS;Initial Catalog=XXX;User ID=username;Password=password"

OR... with integrated security (will use the account the service is run under)

"Provider=SQLOLEDB.1;DSN=XXX;Data Source=(local)\SQLEXPRESS;Initial Catalog=XXX;Integrated Security=SSPI"

HTH!

Jason

这篇关于以编程方式从窗口服务中选择数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！