Global ODBC settings??

  • Thread starter Thread starter David Mendes
  • Start date Start date
D

David Mendes

We have 2 Windows 2000 Servers with Terminal Services. How do I configure
the ODBC settings to be global? When I log on to the server and configure
the settings at the desktop my application works fine. When a user launches
the application via an RDP or ICA session the ODBC settings are all wrong.
I have over 400 users so I don't want to configure the settings for each
person on each server. Any thoughts are more than appreciated. Thanks.
 
Does a system DSN not work

Patrick Rous
Microsoft MVP - Terminal Serve
http://www.workthin.co

----- David Mendes wrote: ----

We have 2 Windows 2000 Servers with Terminal Services. How do I configur
the ODBC settings to be global? When I log on to the server and configur
the settings at the desktop my application works fine. When a user launche
the application via an RDP or ICA session the ODBC settings are all wrong
I have over 400 users so I don't want to configure the settings for eac
person on each server. Any thoughts are more than appreciated. Thanks
 
Let me clarify a bit more. I don't want any settings under User DSN and I
need one under System DSN. I have over 400 users that have entries under
UserDSN on two Windows 2000 Terminal Servers. I need to remove all User DSN
entries and keep the single System DSN entry.
 
Add a line to your logon script to delete entries from this location

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Source

Patrick Rous
Microsoft MVP - Terminal Serve
http://www.workthin.co

----- David Mendes wrote: ----

Let me clarify a bit more. I don't want any settings under User DSN and
need one under System DSN. I have over 400 users that have entries unde
UserDSN on two Windows 2000 Terminal Servers. I need to remove all User DS
entries and keep the single System DSN entry


Patrick Rouse said:
Does a system DSN not work
Patrick Rous
Click to expand...
Microsoft MVP - Terminal Serve
http://www.workthin.co
----- David Mendes wrote: ----
We have 2 Windows 2000 Servers with Terminal Services. How do
Click to expand...
configur
the ODBC settings to be global? When I log on to the server an configur
the settings at the desktop my application works fine. When a use launche
the application via an RDP or ICA session the ODBC settings are al wrong
I have over 400 users so I don't want to configure the settings fo eac
person on each server. Any thoughts are more than appreciated Thanks
Click to expand...
 
Thanks, I'll give it a shot.....


Patrick Rouse said:
Add a line to your logon script to delete entries from this location:

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources

Patrick Rouse
Microsoft MVP - Terminal Server
http://www.workthin.com

----- David Mendes wrote: -----

Let me clarify a bit more. I don't want any settings under User DSN and I
need one under System DSN. I have over 400 users that have entries under
UserDSN on two Windows 2000 Terminal Servers. I need to remove all User DSN
entries and keep the single System DSN entry.


do I
configure and user are all
wrong. settings for
each appreciated.
Click to expand...
 
Back
Top