Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem With IBM (DB2) connection

Hi everyone ,
I'm new consultant in Qlikview and I have a problem with one of my clients.

In the server , I have an application , reloading works randomly.

this is what I have in log file :

Error: SQL##f - SqlState: 28000, ErrorCode: 8018, ErrorMsg: [IBM][Pilote ODBC System i Access]Echec de liaison. comm rc=8018 - CWBSY1040 - Accréditations de connexion Windows non disponibles, Password length = 0, Prompt Mode = Never, System IP Address = 192.168......

someone can help me please ?

3 Replies
petter
Partner - Champion III
Partner - Champion III

The error message seems to indicate that you are trying to use integrated security (Windows authentication) against the IBM DB2 database which DB2 is not set up to handle. Do you know if the DB2 server is running on Windows and that it is set up for integrated (Windows Authentication / Active Directory use) ?

If not you will have to provide a username and a password as your credentials in your ODBC connection in QlikView...

best regards

Petter

Not applicable
Author

Thank you for your answer. I provided the credentials.
The thing that is strange is that sometimes it work and sometimes not.
I'll check in the coming days .

petter
Partner - Champion III
Partner - Champion III

If this answered your question please mark the question as answered