ODBC settings won't change

Posted on 2006-06-21
Last Modified: 2012-05-05
Hey guys,

This is throwing me for a loop.  I'm not sure if it's an active directory thing or an ODBC thing.   A couple days ago, none of the XP desktops could hit the SQL Server 2000 DB using TCP/IP.  Not a big deal, changed it to Named Pipes and it cleaned that right up.  the problem lies in that there's 2 win2k boxes that havn't been upgraded yet and on both of those boxes when I log in as domain admin to change the ODBC connection settings it works fine, but when I logged back in with the user to test everything it's set to "other" in the client configuration screen under ODBC.  I changed it to Named Pipes (or even TCPIP at this point) and when I click OK but go back in there, it sets itself back up as "other".  There's no error message or anything.  any ideas?  its pretty urgent so 500 points to anyone who knows.

Question by:krisstawarz
  • 2
LVL 29

Accepted Solution

QPR earned 500 total points
Comment Utility
When logged in without local admin rights (when logging in with the user I mean) you do not have the ability to change ODBC entries (write to the registry). It would be handy if you got some sort of error or denial message but Windows just appears to do as you ask.
As you say, when you return to the ODBC settings they will have reverted.
You will have to log into the machine with local admin rights, do the change and log back in as the user.

The network admin sets ODBC settings here via a login script, you haven't got that in place have you?
Are you setting a user or a system ODBC?

Author Comment

Comment Utility
It's a System DSN that I'm trying to change.  I figured it would be a permissions thing but also thought that if that was the cause, it would have given me some kind of error to that affect.

Does XP handle this stuff differant that win2k?  when I logged into the XP machines as a domain admin it accepted the changes and applied it to all users logging into that box, but the same doesn't seem to be happening with the 2 win2k boxes.

thanks, I'm going over there in a little while and I'll try this out and let you know if it works.
LVL 29

Expert Comment

Comment Utility
Logging in as domain admin gives you the ability to change settings.
Being a system DSN it means it affects all users who log into that machine not just a certain user.

If you are attempting to change the Win2k ODBC settings while logged on as domain admin (and the changes aren't "sticking") then I'm not sure why you are having the problem. Assuming the Win2k boxes are part of the domain, that a login script isn't setting things and that an application is not changing them on the fly.

To my knowledge XP and Win2k should be the same.
Reading/writing ODBC settings is simply reading/writing a registry key.
LVL 35

Expert Comment

Comment Utility
This question has been classified as abandoned.  I will make a recommendation to the moderators on its resolution in approximately four days.  I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final disposition.

If the asker does not know how to close the question, the options are here:

EE Cleanup Volunteer

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now