命令行使用sql身份验证创建数据源？ [英] command line to create data source with sql authentication?

问题描述

我想在Windows xp专业版上运行一个批处理文件，它为sql服务器连接创建一个系统odbc数据源。我可以这样做：

ODBCCONF.exe CONFIGSYSDSNSQL ServerDSN = Kappa |说明= Kappa数据源| SERVER = 10.100.1.10 | Trusted_Connection =但是我需要一种方法来将sql server认证设置为使用用户输入的登录ID和密码进行SQL Server身份验证。设置和预设登录ID和密码。

有关如何做的任何想法？

提前感谢

解决方案

ODBCConf ConfigSysDSNSQL Server DSN = xxxxx | SERVER = yyyyy | Trusted_Connection = No

似乎对我有用。

I'm looking to run a batch file on windows xp professional which creates a system odbc data source for a sql server connection. I can do that with:

ODBCCONF.exe CONFIGSYSDSN "SQL Server" "DSN=Kappa| Description=Kappa Data Source | SERVER=10.100.1.10 | Trusted_Connection=Yes | Database=subscribers"

However I need a way to set the sql server authentication to be "With SQL Server authentication using a login ID and password entered by the user." to be set and preset the login id and pass.

Any ideas on how to do this?

thanks in advance

解决方案

ODBCConf ConfigSysDSN "SQL Server" "DSN=xxxxx|SERVER=yyyyy|Trusted_Connection=No"

seemed to work for me.

这篇关于命令行使用sql身份验证创建数据源？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！