Global ODBC settings??

[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.

 

[Guest]

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

 

[David Mendes]

There is one SystemDSN setting that is used and different UserDSN settings.

 

[David Mendes]

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.

 

[Guest]

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

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

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

 

[David Mendes]

Thanks, I'll give it a shot.....

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.