WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

ODBC
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Create an SQL DSN with User name and Password


Question:

I pretty much have this down but I don't know how to create an SQL DSN with a user name and password (not Windows Authenication) What do i use as a keyword for the password?

Answer:

From what I can tell there is really no way to programmatically create a DSN with a password. Probably due to security restraints.

If you just need to give your scripts access to the SQL server, you may not need to create a DSN. Instead you could attach using DSN-Less connection which may allow you to specify username and password. See the function qDriverCon.

Or maybe you can create a UDL with name/password?

Referenced:

http://www.databasejournal.com/features/mssql/article.php/1491051

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=a96a5eb2591dcd65&seekm=985ufv%2413m%40dispatch.concentric.net#s

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=df4b231adaca64d2&seekm=99c901c28ffb%24f1fa6f40%2489f82ecf%40TK2MSFTNGXA01#s


Article ID:   W15843
File Created: 2017:07:28:13:58:32
Last Updated: 2004:03:30:15:41:06