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.

Specify SQL Server Password in qConfigData


Question:

I am using the qconfigdata function to modify / create odbc connections for sql server. I know the user attribute is lastuser. I cant figure out how to assign the password with the attr.

Answer:

You might want to examine the documentation for the specific driver you are using. http://msdn.microsoft.com/library/en-us/odbcsql/od_odbc_c_99yd.asp?frame=true

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

Please read:
http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/nftechsupt.web+WIL~Extenders/Odbc~Extender+Create~an~SQL~DSN~with~User~name~and~Password.txt

Note: Maybe use the attribute 'Trusted_Connection=YES'. This causes the SQL server to use the Windows NT logged on user name and password.


Article ID:   W16839
File Created: 2017:07:28:12:58:34
Last Updated: 2014:07:18:08:49:32