I need to distribute an ODBC that has username and password authentication. Anybody shed any light or wisdom on the best and easiest way to do this. I am trying to use WinInstall LE, if there is a better way any advice would be appreciated.

Thanks
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
there are lots of info on odbc if you do a search

on a clean workstation create the odbc settings
then go into the registry and import your settings into your msi
Answered 02/05/2010 by: cygan
Fifth Degree Brown Belt

Please log in to comment
0
i have done a bit of research and am having trouble with the password part of the connection....don't see where that gets saved in the registry (or anywhere for that matter). Was also curious if anybody had specifically built a connection from scratch inside of Wininstall LE.

Thanks
Answered 02/05/2010 by: Stanimosity
Senior Yellow Belt

Please log in to comment
0
If I recall correct; you need to enter the authentication information using the Registry table as the ODBC related tables do not support that "info".
Answered 02/05/2010 by: AngelD
Red Belt

Please log in to comment
0
Stanimosity

One of the easy methods to know where password get saved is, run (taking first snap shot of machine) a "picture taker" or "InstallRite" before entering the connection password and re-run (second snap shot) the same tool after entering password. It will give you the correct result. Import/add them in the your MSI.
Hope this helps you.
Cheers,
Answered 02/07/2010 by: Harsha Gurugunti
Senior Yellow Belt

Please log in to comment
0
I believe Passwords will not be saved anywhere
Answered 02/07/2010 by: mekaywe
Brown Belt

Please log in to comment
0
You could try this:

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<MyConnectionName>]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Description"="MyConnection"
"Server"="<Server IP/Name>"
"Database"="<Default Database Name>"
"LastUser"="<userid you want>"
"UserName"="<userid you want>"
"Password"="<password you want>"

The username and password keys are not created by default - I've got someone doing some UAT/OAT on a package at the moment with the DSN settings populated as above.

Works fine in my Dev Lab - waiting to see how the user experience is.

Hope this helps,

Dunnpy
Answered 02/08/2010 by: dunnpy
Red Belt

Please log in to comment
0
When you go back into ODBC settings, does the password field show as being populated as mine is still clear...?
Answered 12/12/2011 by: DazFrost
Yellow Belt

Please log in to comment
0
Daz,

I think that opening up the ODBC GUI may not show you the password - check the registry keys noted above and test that the DSN makes a connection on a box with backend connectivity.

How's things? Long time no speak :)

Thanks,

Dunnpy
Answered 12/14/2011 by: dunnpy
Red Belt

Please log in to comment
0
Capture all the registries changes made by the Source application. On a clean workstation create the odbc connection manually and than import the ODBC "HKLM\Software\Microsoft\ODBC" registry hive. Password never reflect in registries hive however it store there. There is small chance of some files getting captured, you should include any file if newly created or changed.
Answered 03/29/2015 by: vibhor
White Belt

  • This thread is nearly 4 years old - please don't resurect old threads.
Please log in to comment
Answer this question or Comment on this question for clarity