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
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
Don't quote me, but I *believe* the UN/PW is stored in a Windows Password List. As such, they're not distributable.
Answered 03/20/2008 by: VBScab
Red Belt

Please log in to comment
0
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
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.
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