[ZBX-17143] Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified] Created: 2020 Jan 06  Updated: 2024 Jun 21  Resolved: 2020 Jan 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: CHAB Narong Assignee: Zabbix Support Team
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

CentOS Linux release 7.6.1810 (Core)
Zabbix Version: 4.4.4-1.el7
Memory: 16GB
CPU: 8 Core
Database Maria-db


Attachments: PNG File Issue ODBC.PNG     PNG File image-2020-01-06-15-32-56-366.png     PNG File image-2020-01-06-15-34-02-874.png    

 Description   

Issue Summary: 

Dear Zabbix Forum, 

I am facing an issue with zabbix monitoring with Oracle database version 12c with ODBC connection for back end I can connect to using driver oracle. But for front end error message below. 

Result:

74395:20200106:103553.974 item ":db.odbc.select[session blockers count,\{$DSN}]" became not supported: Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]


 Comments   
Comment by Edgar Akhmetshin [ 2020 Jan 06 ]

Hello CHAB Narong,

According to the error, please check that macros named {$DSN} has correct value. Note, macros value can be specified on the Global, Template, Host levels (Zabbix documentation: macros).

Please be advised that this section of the tracker is for bug reports only. The case you have submitted can not be qualified as one, so please reach out to [email protected] for commercial support or consultancy services. Alternatively, you can also use our IRC channel or community forum (https://www.zabbix.com/forum) for assistance. With that said, we are closing this ticket. Thank you for understanding.

Regards,
Edgar

Comment by CHAB Narong [ 2020 Jan 06 ]

Hello edgar.akhmetshin, 

I have tried add name DSN, But it still does not work, Please find error below.

Back end ODBC driver it is possible connect to Oracle. 

Zabbix Web Interface
Zabbix web interface using DSN the same with back end and it error as screenshot

Thank for advise !

Comment by Nina Dutra [ 2020 Jan 16 ]

Hello Friend!

Try enabling the "AllowRoot" option in the zabbix proxy or server configuration file and restarting the service.

For me it worked!

Generated at Sun May 11 08:08:10 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.