Creating Datasource for DB2 database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Administration » Creating Datasource for DB2 database

Creating Datasource for DB2 database

Rate Topic

Display Mode

Topic Options

Author

Message

Shree-903371

Posted Tuesday, February 19, 2013 1:12 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:26 AM
Points: 123, Visits: 222

Hello,
We want to create new data source connecting to DB2 database. My boss installed OLEDB drivers for IBM DB2 onto the SSRS server.
But I'm not sure on how to create a datasource i.e. connection string? Also whether to use OLEDB or ODBC connection?

Did somebosy has the same issue?

Thanks in adavance.

Post #1421823

e4d4

Posted Tuesday, February 19, 2013 2:07 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:04 AM
Points: 151, Visits: 1,029

eg.: http://www.mssqltips.com/sqlservertip/2151/how-to-create-a-sql-server-link-server-to-ibm-db2/

Post #1421846

Shree-903371

Posted Tuesday, February 19, 2013 2:47 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:26 AM
Points: 123, Visits: 222

In the above link, it showed how to create a linked server. But i need to create a datasource on SSRS server to which my reports needed to be pointed?

Post #1421863

Shree-903371

Posted Wednesday, February 20, 2013 9:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:26 AM
Points: 123, Visits: 222

I used below conncetion string and it worked.

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=0.0.1.23;
Initial Catalog= Adbcfg;Package Collection=Default Schema;Default Schema= adc;User ID=user;
Password=pass;

Post #1422138

« Prev Topic | Next Topic »

Permissions