topic Re: ODBC connection is successful but couldn't able to connect to qlik sense in App Development

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

laxmanqlik — Wed, 29 Aug 2018 10:22:49 GMT

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

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

shraddha_g — Wed, 29 Aug 2018 10:26:13 GMT

Try to use OLEDB instead

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

BalaBhaskar_Qlik — Wed, 29 Aug 2018 14:41:19 GMT

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-connection.htm

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

BalaBhaskar_Qlik — Wed, 29 Aug 2018 14:41:56 GMT

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.

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

laxmanqlik — Thu, 30 Aug 2018 06:08:07 GMT

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.