Oracle ODBC Connection Error DENIED odbcad32.exe

Posted on 2011-05-05
Last Modified: 2012-06-27
I am wondering if the IT department has cut off my access to the Oracle server because I am getting an error message I have never encountered before.  I have been using this connection for weeks and yesterday afternoon I got cut off.  I tested the connection via the MS "Data Sources (ODBC)" aka odbcad32.exe.  I created a DNS connection using "Oracle in OraClient10g_home1" driver.

The error message says (I also attached an image):
Unable to connect
[Oracle][ODBC][Ora]ORA-00604: error occured at recursive SQL level 1
ORA-20001: Denied!  You are not allowed to logon to the database using odbcad32.exe
This incident has been logged.
ORA-06512: at line 56

Can anyone tell me if they did cut me off if so what do I need to communciate to the IT department to get the connection working again?
Question by:ascnd
    LVL 76

    Accepted Solution

    Oracle error messages in the 20,000 range (ORA-20001) are commonly reserved for user defined errors.

    Based on the custom message, yes, someone has put some custom security in place to keep odbcad32.exe from connecting.

    You will need to check with the IT Department.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >> what do I need to communciate to the IT department to get the connection working again?

    You need to validate your reasons for needing ODBC connectivity.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now