ODBC connection password question
I am trying to put down a SQL ODBC entry and have a question. I know how to configure the data source via Wise Script or how to merge the appropriate registry file for the connection, but my question is specifically about the credentials, and how do you pass them along with the connection? (or can you?)
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
JimmPanik
16 years ago
I am trying to do the same thing basically. Did you ever find an answer to this? Specifically, I need to supply uid and pwd for the SQL configuraiton of a DSN. This is a one time user logon (that I know of) so windows is not holding this name / pwd anywhere. There must be a place to pass the parameters. Perhaps through a SQL script?
Jimm
Jimm
Posted by:
aogilmor
16 years ago
You won't be able to pass the password in the ODBC setup. Username, yes. But the user himself must authenticate. At that point (after first authentication) most ODBC connection drivers do allow for a persistent or cached password.
Doesn't this make sense from a security standpoint?
Doesn't this make sense from a security standpoint?
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
