https://community.qlik.com/t5/Connectivity-Data-Prep/Problems-establishing-ODBC-connection-to-ORACLE-using-ODBC/m-p/1779000#M5749 <P>So, <A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28597" target="_blank">@Sonja_Bauernfeind</A> or <A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/39663" target="_blank">@Andre_Sostizzo</A>, don't you have any comments about this?&nbsp; We followed the instructions on the articles that you have posted about this and proved that the ORACLE ODBC connections can be used in both QV PE and SQL Runner.&nbsp; What can be causing that the same connections don't work in QSEoW?</P> Mon, 01 Feb 2021 15:15:52 GMT diagonjope 2021-02-01T15:15:52Z https://community.qlik.com/t5/Connectivity-Data-Prep/Problems-establishing-ODBC-connection-to-ORACLE-using-ODBC/m-p/1774899#M5687 <P>Greetings,</P><P>We are running into a problem when using the ODBC Connector and trying to connect to an ORACLE source.&nbsp;</P><P>We have defined the proper service connections in a tnsnames.ora file and the system environment variable TNS_ADMIN has been set to the path where the tnsnames.ora file resides.&nbsp; We can create new connections to the ORACLE source and test them using the Windows Server ODBC manager.&nbsp; We can also use these connections from QlikView PE installed in the same server, as well as with DTM SQL Runner; but we get a basic ORA-12154 error when we try to use the same connection to this source from QSE using the ODBC Connector (please see images attached).</P><P>An interesting aspect of this situation is that we were originally using the Qlik ORACLE Connector in QSE, but the performance is TERRIBLE (data loads that take 2 hours in an equivalently configured QVS server take 4+ hours in QSE, but the throughput results obtained when using SQL Runner are equivalent in both systems); so we installed the ORACLE client in the server in order to compare the performance of both types of connections and then we got this error.</P><P>Does anyone have an idea of what could be happening here?&nbsp; Is this a bug in the ODBC Connector Package?&nbsp; Any thoughts from <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28597">@Sonja_Bauernfeind</a> or <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/39663">@Andre_Sostizzo</a> ?</P><P>Please advise.</P><P>Cheers,</P><P>++Jose</P> Thu, 23 Dec 2021 19:55:44 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Problems-establishing-ODBC-connection-to-ORACLE-using-ODBC/m-p/1774899#M5687 diagonjope 2021-12-23T19:55:44Z https://community.qlik.com/t5/Connectivity-Data-Prep/Problems-establishing-ODBC-connection-to-ORACLE-using-ODBC/m-p/1779000#M5749 <P>So, <A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28597" target="_blank">@Sonja_Bauernfeind</A> or <A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/39663" target="_blank">@Andre_Sostizzo</A>, don't you have any comments about this?&nbsp; We followed the instructions on the articles that you have posted about this and proved that the ORACLE ODBC connections can be used in both QV PE and SQL Runner.&nbsp; What can be causing that the same connections don't work in QSEoW?</P> Mon, 01 Feb 2021 15:15:52 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Problems-establishing-ODBC-connection-to-ORACLE-using-ODBC/m-p/1779000#M5749 diagonjope 2021-02-01T15:15:52Z