ODBC driver issue in IDT

[former_member456005]

Hi,

We are facing ODBC driver error in audit universe from IDT:

Error : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Database : MS SQL Server 2017

Datasource Name : AUDIT_SQL

Can anyone let us know what could be the issue and what action we have to take.

[DellSC]

When running reports from BOBJ, you need a 64-bit ODBC DSN. But the IDT is 32-bit software, so you have to configure a 32-bit ODBC DSN to connect to the database. I suspect you may have a 64-bit DSN configured, but not the 32-bit version. You can use the same name for both.

-Dell