ODBC DSN w/User Credentials
Good day all,
I have a package that requires creation of an ODBC DSN on the clients. There is a user name and password in this DSN. This DSN uses the SQL Native Client by the way. My quesiton is, how do I include these UID and pwd in the package? I cannot find these parameters within the registry although I do see the server etc listed in HKLM\SOFTWARE\MICROSOFT\ODBC\ODBC.INI.
Thanks for the assist,
Jimm
I have a package that requires creation of an ODBC DSN on the clients. There is a user name and password in this DSN. This DSN uses the SQL Native Client by the way. My quesiton is, how do I include these UID and pwd in the package? I cannot find these parameters within the registry although I do see the server etc listed in HKLM\SOFTWARE\MICROSOFT\ODBC\ODBC.INI.
Thanks for the assist,
Jimm
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
anonymous_9363
16 years ago
Don't quote me, but I *believe* the UN/PW is stored in a Windows Password List. As such, they're not distributable.
Posted by:
JimmPanik
16 years ago
This is out of my area of expertise so my terminology may be off. Here is a better description of what I am trying to do.
Create System DSN in ODBC for SQL Native Client as part of my MST for a vendor supplied MSI. In ODBC, I can create the DSN but it does not have areas to supply configuration parameters (UID and PWD) for the initial connection.As I understand it, this initial connection hits the SQL server and then creates a workstation account allowing future communicaitons between the device and SQL. The configuration uid and pwd are probably not stored as they are one time use items. It would seem that there is a way to do this in MSI I just do not know what I need to do. I tried using a SQL connect string but this also failed.
Jimm
Create System DSN in ODBC for SQL Native Client as part of my MST for a vendor supplied MSI. In ODBC, I can create the DSN but it does not have areas to supply configuration parameters (UID and PWD) for the initial connection.As I understand it, this initial connection hits the SQL server and then creates a workstation account allowing future communicaitons between the device and SQL. The configuration uid and pwd are probably not stored as they are one time use items. It would seem that there is a way to do this in MSI I just do not know what I need to do. I tried using a SQL connect string but this also failed.
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.