Programmatically add new data source name?

[dana]

Is there any way to script the addition of data source names? I have
several I need to add for a number of users. It would be a lot easier
to hand them a script to execute vs. having them add the names
manually through the Control Panel.

Is this possible through "DOS" or must it be done in something like
VBscript?

Thanks.

Dana

[Pak-Ming Cheung - MSFT]

The recommended way is to use the API: SQLConfigDataSource(with fRequest =
ODBC_ADD_DSN)
http://msdn.microsoft.com/en-us/library/ms716476(VS.85).aspx

You can write a simple C++ program taking command-line arguments. Then, your
script can simply call that program with different input argument.

Thanks,
Ming.
WDAC Team, Microsoft.

P.S. We recommend customers to use the forum to ask questions in the future,
where you can obtain a faster response (Forum is at:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/)