Best way to modify a Client user DSN remotely using VB6

We have a MERANT 3.70 ODBC driver installed on several clients with a same name user DSN to access a Progress database.  I'm needing to modify the user DSN for several clients and I want to batch process the modification.  Can someone put me on track to information on programatically modifying "User DSN".  I should be able to push the user DSN modification program out to the clients using the PsExec in PsTools from Sysinternals but I need to find information on modifying the DSN.  Any help would be appreciated.
LVL 4
abbdanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

abbdanAuthor Commented:
I think I just found my own answer.  Thanks anyways.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q171146
0
abbdanAuthor Commented:
Actually if someone can show me how to modify a user DSN programatically rather than delete and recreate I'll accept that as an answer.
0
Marv-inCommented:
the values for the dns are stored in the regestry

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

you could edit them that way
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
abbdanAuthor Commented:
I've already found the answer I was needing.

Best way to do it is to make the modifications on your local machine in the ODBC administrator program.  Run Regedit, go to either HKey_LOCAL or HKey_USER depending on if its a system DSN = LOCAL or user DSN = USER.  Highlight the folder in \SOFTWARE\ODBC\ODBC.INI\yourdsnname and export a backup of that to your desktop.  Then push it out to all the clients using the logon script or psexec in pstools.  I appreciate the help anyways but I've resolved this myself.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.