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.



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


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?


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?


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