Deploy ODBC- Settings
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
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
Answers (7)
Please log in to answer
Posted by:
shogun_ro
18 years ago
The password will not be retained.The user should always input the password.
Posted by:
aogilmor
18 years ago
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..
Posted by:
revizor
18 years ago
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?
Posted by:
private
18 years ago
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... :-)
->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... :-)
Posted by:
xythex
18 years ago
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.