Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error while changing the database connection

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.

1 Reply
Anonymous
Not applicable
Author

The problem was resolved by connecting via TNS service name instead of connecting directly via host name & service name.