Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
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
" Driver's SQLAllocHandle on SQL_HANDLE_ENV failed "
the strange thing that I can test the connection and it works properly but when I click "save" I got the above error!
Both databases are Oracle 11g and on the same server.
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.
Any help will be appreciated.
The problem was resolved by connecting via TNS service name instead of connecting directly via host name & service name.