• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1426
  • 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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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