Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    21

    Question Unanswered: Querying DB2 Database with Reporting Service

    People

    I'm in a trouble.
    So, I need to query some data in DB2 with Reporting Service.
    I don't know if there's a way to do it, without using DTS Package, because if I did it, I'd be replicating it, and it's not the case. 'Cause I just want to query the data in DB2 and not bring the data to SQL.

    There's a provider that I can do it?
    Suppose I use a Linked Server, and add a Net-Library based on their Operational System, it would resolve? If not, what would be the best way of resolving this trouble??

  2. #2
    Join Date
    Dec 2004
    Posts
    21
    I've got it.

    So, for sure I knew that there's a way of doing it without transfer the data with DTS.

    It's simple! Just reference a DB2 database on Report Wizard, and do some little things... and... run!
    Easy so, does't it? =))

    Thank's for all helps... even more mine... lol..

  3. #3
    Join Date
    Oct 2003
    Posts
    60
    You need the OLE driver from DB2, then setup an ODBC connection to the server.
    jaraba

  4. #4
    Join Date
    Dec 2004
    Posts
    21
    Quote Originally Posted by jaraba
    You need the OLE driver from DB2, then setup an ODBC connection to the server.
    For sure.
    But I already have it.
    I did an application, and it was seccessfull.

    Thanks for postered here =)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •