• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1467
  • Last Modified:

Oracle ODBC Connection Error DENIED odbcad32.exe

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
SQLState=S1000
[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?
0
ascnd
Asked:
ascnd
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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.
0
 
slightwv (䄆 Netminder) Commented:
>> 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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now