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

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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
Answered 03/20/2008 by: JimmPanik
Orange Belt

Please log in to comment
0
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?
Answered 03/21/2008 by: aogilmor
Ninth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity