Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error - ODBC DB2

Hi

I’m gettingan error when try to connect to a DB2 database trough ODBC.

This is theerror I get:

“Connection Test Failed

SQL##f - SqlState: 58031,ErrorCode: 4294966265, ErrorMsg: [IBM][CLI Driver] SQL1031N  The database directory cannot be found on theindicated file system.  SQLSTATE=58031”


But I havecheck the ODBC configuration and make some test and its working fine, but not in QlikView.

I will appreciateyour help.

Thanks,

Obed Adames

1 Solution

Accepted Solutions
Not applicable

Error - ODBC DB2

Thanks for answer Ralf,

But I find the solutions,

The solution was, that if you install only the drivers of ODBC for DB2, you need to add the user the Role of DB2ADMIN and DB2USER that it creates in the system. Because theinstallation of the drivers does not auto assign those roles.

One I give that role to the user and restart the computer its start working.

2 Replies
MVP
MVP

Error - ODBC DB2

Hi Obed,

maybe the connect string is wrong. Can you post your script?

- Ralf

Not applicable

Error - ODBC DB2

Thanks for answer Ralf,

But I find the solutions,

The solution was, that if you install only the drivers of ODBC for DB2, you need to add the user the Role of DB2ADMIN and DB2USER that it creates in the system. Because theinstallation of the drivers does not auto assign those roles.

One I give that role to the user and restart the computer its start working.

Community Browser