ODBC connection is successful but couldn't able to connect to qlik sense

[laxmanqlik]

Hi everyone,

I am trying to connect to Oracle database, I did a ODBC connection , it showing the connection was successful but here comes the problem when I am trying to connect to that ODBC connection it showing connector connect error:{0}

Please help to resolve it ASAP

THANKD IN ADVANCE

[shraddha_g]

Try to use OLEDB instead

[balabhaskarqlik]

Provide screenshot of the issue, better to understand.

Check this:

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Oracle/Create-Oracle-c...

[balabhaskarqlik]

It's May be a driver compatibility issue. Define a 64 bit DSN but the reference was to a 32 bit DLL in the drivers. Download the 64 bit driver and after that this error may went away. Check your DSN and Driver to ensure they are both 32 or 64 bit. Test the connection.

[laxmanqlik]

Hi Bhaskar,

Thanks for your time, below are screenshots of ODBC connection success status and error i am getting while connecting to ODBC through Qlik sense.