Hello all,

we want to deploy ODBC- Settings for a Connection to a SQL- Server. Its very simple with Wise, but how can I deploy the Passwort for the SQL- Authentification? I can put the Username into the LastUser- Attribut (HKLM/Software/ODBC/ODBC.INI/MyEntry/ LastUser=test)... but where I can set the password?

Thx much.
private
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
The password will not be retained.The user should always input the password.
Answered 12/08/2005 by: shogun_ro
Orange Belt

Please log in to comment
0
no chance? any vbs that could create the entry?
Answered 12/08/2005 by: private
Senior Yellow Belt

Please log in to comment
0
ORIGINAL: private
no chance? any vbs that could create the entry?


vbscipt might be able to do it with regwrite, but why would you want to? violating security just to make things a little easier on the user?...

Just enter it the first time, and it should stick around thereafter. At least I think that's how it works..
Answered 12/14/2005 by: aogilmor
Ninth Degree Black Belt

Please log in to comment
0
If there's a specific account used in order to establish ODBC connection, wouldn't it be just a bit more secure to push the logon and password as part of a package, rather than give those out to a user?
Answered 12/14/2005 by: revizor
Third Degree Blue Belt

Please log in to comment
0
Hi @ll,

->aogilmor

"violating security just to make things a little easier on the user"
In our Enviroment the User have no permission to set ODBC- Setting....

Now we have a solutions: The Application which use this ODBS- Entry can set it by self... :-)
Answered 12/15/2005 by: private
Senior Yellow Belt

Please log in to comment
0
Microsoft's SQL driver does not retain password information in the registry. You can try connecting with a connection string in your actual application or use a different SQL ODBC driver, or of course the best suggestion is just to have your users enter the password when they connect
Answered 12/15/2005 by: xythex
Orange Senior Belt

Please log in to comment
0
Thanks to everyone!
Answered 12/15/2005 by: private
Senior Yellow Belt

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