ODBC settings won't change
Posted on 2006-06-21
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.