Discussion Locked

set ODBC entry for all users in WTSRV?

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, I need to set a DSN entry in ODBC on a .mdb database for all the users that connect on my Terminal Server. I set the ODBC with the administrator account but when a normal user log on terminal, he don't keep the DSN entry and cannot connect to the database. When I give the user administrator's rights, everything works fine but when I downgrade him to normal user, The ODBC entry exists no more.How can I set an ODBC entry that will be available for administrators and normal users?

4 replies

by rabbit_runner

Hi,
1. Create a user with the needed ODBC drivers. Set up any parameters you need.
2. Then log out and log back in as the administrator.
3. Explore the c drive (I assume that the Winnt 4 is installed in the default directory of c:\winnt)
4. openwinnt folder
5. open profiles folder
6. find the user you created with the needed ODBC drivers. COPY everything in this entire folder, with everything in it.
7. do a paste of all this information to the 'default user'.
8. This places the information to this profile.
NOTE: any new user who logs in for the first time, will draw their profile from the 'default user'.
9. If your are running win2k, then the location will be c:\documents and settings\default user.
10. Any current users who arehaving the problems, should have their profile deleted, then when they log back in, they will pull the information from the default user profile.

Best of luck

by bergerpeat

I tried that but it did not solve my problem. It looks like the problem don't come from the profiles. Its more like a permission problem because when I give admin rights to a user, the ODBC Settings are OK. If you have another idea, tell me. Thank you

by rabbit_runner

Hi again,
How were the ODBC drivers installed? Were they installed under the Administrator account? Also, when they were installed, was their an option to allow access for all users?
Can you install the ODBC drivers under a Non-administrator account?
Like you say, it appears to be a permissions issue. Check to see if the ODBC drivers have some place for permissions to be assigned. Maybe the DSN entry has a place for account or permissions.
These are just some things to look into. Let me know what you find out.

This discussion is closed to new replies.