Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating Datasource for DB2 database Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 1:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 6:58 AM
Points: 130, Visits: 258
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
Posted Tuesday, February 19, 2013 2:07 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, September 27, 2014 4:20 AM
Points: 223, Visits: 1,726
eg.: http://www.mssqltips.com/sqlservertip/2151/how-to-create-a-sql-server-link-server-to-ibm-db2/
Post #1421846
Posted Tuesday, February 19, 2013 2:47 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 6:58 AM
Points: 130, Visits: 258
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
Posted Wednesday, February 20, 2013 9:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 6:58 AM
Points: 130, Visits: 258
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 »

Add to briefcase

Permissions Expand / Collapse