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