Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-07-30 03:34 PM

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.

781 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-07-31 04:17 AM
Author

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

718 Views
0 Likes