Removing ODBC Entries

G

Guest

I have a user that has an ODBC entry under her ODBC Data Source Administrator
that she's unable to remove. She clicks on the data source and then clicks
on Remove. Nothing happens. She can delete other ODBC entries except this
one. I have tried to remove it myself without success. I was hoping that
someone out there has a regedit that I can use to manually remove the ODBC
connection. Send me an email if you have any ideas or questions. Thank you.

-Shawn
(e-mail address removed)
 
6

'69 Camaro

Hi, Shawn.
Send me an email if you have any ideas or questions.

We do provide this service for paying customers. Your name doesn't ring a
bell on any checks I've cashed recently, but feel free to rectify this.
I have a user that has an ODBC entry under her ODBC Data Source Administrator
that she's unable to remove. She clicks on the data source and then clicks
on Remove. Nothing happens. She can delete other ODBC entries except this
one. I have tried to remove it myself without success.

Is the DSN being used in an active ODBC connection? When attempting to
delete the DSN, you may not get an error message, such as "Permission
denied." Ensure that no computer is currently using the DSN for an active
ODBC connection.

This can also happen when the Windows Registry keys have been secured, even
if you or the user was logged in as a Windows Administrator while attempting
to remove the ODBC entries or the Windows Registry keys. This security
could have been applied from a group policy or on the individual computer.

You can remove the security restriction, but the steps required differ
slightly, depending upon the operating system. If you have Windows XP, try
the following steps.

First, ensure that the computer isn't currently using the DSN for an active
ODBC connection.

Second, back up the Windows Registry. If you don't know how to do this,
then find someone who does, then follow the rest of these steps.

Log on as the Windows Administrator and open Regedt32. Select the Windows
Registry keys that you want to delete. For example, if the System DSN was
named "SPAMMER," the following Windows Registry keys would need to be
deleted:

HKCU\Software\ODBC\ODBC.INI\SPAMMER\Driver
HKCU\Software\ODBC\ODBC.INI\SPAMMER\Server
HKCU\Software\ODBC\ODBC.INI\SPAMMER\Database
HKCU\Software\ODBC\ODBC.INI\SPAMMER\LastUser
HKCU\Software\ODBC\ODBC.INI\ODBC Data Sources\SPAMMER

Right click on the first Registry key and select "Permissions..." from the
pop-up menu. (IIRC Windows 2K uses the Security menu for this.) In the
"Permissions for SPAMMER" dialog window, check that Administrators don't
have the "Deny" check box checked. If it is checked, then change it to
"Allow." You may also need to check "Special Permissions" from the
"Advanced" button to ensure special permissions don't deny the
Administrators group from removing this Windows Registry key. Use the
"Effective Permissions" tab to find out. Select the "OK" button to save any
changes.

Do the same for each of the five Windows Registry keys. Close Regedt32,
then open Regedit. Delete the five SPAMMER Windows Registry keys. If you
are still prevented from doing this, then check the computer's group
policies and disable any policies that are blocking you from deleting the
five Windows Registry keys, then try again.

You may need to reboot the computer for the altered group policies to take
effect. Remember that if the group policies are automated from the network,
then this computer will need to be disconnected from the network before
rebooting, lest your recent Windows Registry changes be removed before you
have a chance to use them.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top