ODBC DSN for different users

  • Thread starter Thread starter Phu
  • Start date Start date
P

Phu

We have an appication that uses System ODBCs. On change of the ODBC
server location we need to manually go into each users profile and
make the change to all users. Is there a registry entry or a special
way in which this can be done automatically?

Thanks in advance.
 
Not sure what you mean, as System DSNs are per machine, not per user? Is
there perhaps an ini file that references the DSN that you need to change?

Patrick Rouse
Microsoft MVP - Terminal Server
http://www.workthin.com
 
Thanks for the reply Patrick.

I didnt make myself too clear on this, a new system dsn is required.
In order to change to the new name, each user profile needs to login
individually and use the application to set the new DSN name. As the
HKCU\Software\VB and VBA Program Settings\<appname>\Connection
registry setting is not available by logging in as a different user or
by administrator. This an application issue. What is Microsofts
recommendation on storing user data, registry? profile path i.e. ini?
We only have 10 users to change so it is not too bad to do this
manually.
 
You could set these in your profile, export the registry key, then import it
via logon script using regedit /s RegFile.reg (RegFile.reg is whatever name
you give to your exported registry file).

I'm not a huge fan of ini files, but I know a lot of apps still use them.
 
Back
Top