topic need help connecting as400 db2 in QlikView

need help connecting as400 db2

Anonymous — Fri, 09 Mar 2012 09:19:57 GMT

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

need help connecting as400 db2

magavi_framsteg — Fri, 09 Mar 2012 09:45:42 GMT

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.

need help connecting as400 db2

Fri, 09 Mar 2012 09:47:24 GMT

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.

need help connecting as400 db2

Anonymous — Fri, 09 Mar 2012 10:16:06 GMT

so which driver you used to create the dsn

need help connecting as400 db2

magavi_framsteg — Fri, 09 Mar 2012 10:26:29 GMT

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.

Re: need help connecting as400 db2

Thu, 13 Jun 2013 09:31:39 GMT

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