topic Error while changing the database connection in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Error-while-changing-the-database-connection/m-p/140266#M758 <HTML><HEAD></HEAD><BODY><P>Dear Community, </P><P></P><P>I have a strange problem, I developed a new dashboard using QlikSense Desktop and it worked well. When I changed the database connection to point to the production database, I got this error</P><P></P><P>"<SPAN style="color: #242729; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 15px;"> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed " </SPAN></P><P></P><P>the strange thing that I can test the connection and it works properly but when I click "save" I got the above error!</P><P></P><P>Both databases are Oracle 11g and on the same server.</P><P></P><P>I've checked the community posts about the error message but my case is different as it was working properly and without any change, the error occurred.</P><P></P><P>Any help will be appreciated. </P></BODY></HTML> Mon, 30 Jul 2018 19:34:18 GMT Anonymous 2018-07-30T19:34:18Z Error while changing the database connection https://community.qlik.com/t5/Connectivity-Data-Prep/Error-while-changing-the-database-connection/m-p/140266#M758 <HTML><HEAD></HEAD><BODY><P>Dear Community, </P><P></P><P>I have a strange problem, I developed a new dashboard using QlikSense Desktop and it worked well. When I changed the database connection to point to the production database, I got this error</P><P></P><P>"<SPAN style="color: #242729; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif; font-size: 15px;"> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed " </SPAN></P><P></P><P>the strange thing that I can test the connection and it works properly but when I click "save" I got the above error!</P><P></P><P>Both databases are Oracle 11g and on the same server.</P><P></P><P>I've checked the community posts about the error message but my case is different as it was working properly and without any change, the error occurred.</P><P></P><P>Any help will be appreciated. </P></BODY></HTML> Mon, 30 Jul 2018 19:34:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Error-while-changing-the-database-connection/m-p/140266#M758 Anonymous 2018-07-30T19:34:18Z Re: Error while changing the database connection https://community.qlik.com/t5/Connectivity-Data-Prep/Error-while-changing-the-database-connection/m-p/140267#M759 <HTML><HEAD></HEAD><BODY><P>The problem was resolved by connecting via TNS service name instead of connecting directly via host name &amp; service name. </P></BODY></HTML> Tue, 31 Jul 2018 08:17:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Error-while-changing-the-database-connection/m-p/140267#M759 Anonymous 2018-07-31T08:17:57Z