Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

m_irfan360
Contributor

need help connecting as400 db2

guys i need to connect with as400 db2 to fetch the data. so far my findings is one need to create an ODBC dsn so that u can use ODBC call to connect to the db2 now what i dont know is how to get the driver for ODBC of db2 so that i can create my own dsn and one more thing is there any thing specific i need to take care when creating my own dsn(data source name). if any has done it kindly help me out.

Regards,

irfan

1 Solution

Accepted Solutions
magavi_framsteg
Contributor III

need help connecting as400 db2

Hi again.

I used the "iSeries Access ODBC Driver" v12.64.

Works like a charm!

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

5 Replies
magavi_framsteg
Contributor III

need help connecting as400 db2

Hi Muhammad.

We use three ODBC drivers at my client:

- iSeries Access ODBC Driver v12.64

- IBM DB2 ODBC Driver

- Client Access ODBC Driver v12.64

I didn't install them myself, and they're named like that.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Not applicable

need help connecting as400 db2

Easiest way is to install some native drivers. If you have a Client access license for example, install the 32 / 64 bit (depending on the type of machine/Windows you have) ODBC drivers from your Client Access installation disk. The only thing you need to do then is create an ODBC connection.

1 tip : If you need several datalibraries that look alike (example : 1 library per company), just create 1 ODBC connection and give it a generic name. Open up the connection in your script and afterwards you will be able to change the library inside the script.

m_irfan360
Contributor

need help connecting as400 db2

so which driver you used to create the dsn

magavi_framsteg
Contributor III

need help connecting as400 db2

Hi again.

I used the "iSeries Access ODBC Driver" v12.64.

Works like a charm!

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Not applicable

Re: need help connecting as400 db2

Hi Guys,

I also want to connect to DB2/Iseries database from QlikView Server windows 2008 server 64 bit machine with QlikVIew 10 SR4,

kindly suggest the driver name which needs to be installed to connect DB2 database, also Is it a freeware ?

Also if possible kindly suggest the freeware, Many many thanks in advance !!!!!!

Best Regards,

Arun Gupta

Community Browser