Post reply

DB2's ODBC connection is not working in report server

  • February 3, 2010 at 9:38 am

    #216410

    Hi,

    A connection problem popped up when I ran my report in the report server. My datasource is using a DB2 database and is connected thru an ODBC with a connection string - "Provider=MSDASQL.1;Persist Security Info=False;Data Source=IBMClient". The error says;

    Cannot create a connection to data source 'IBMClient'

    ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    Same report works fine in the report deisigner, I just don't know why I lost connection when it got deployed to the report server. The report server and IIS is local on my machine.

    Your thoughts on this one.

    Thanks.

  • February 9, 2010 at 10:06 am

    #1116247

    If you are in the Enterprise edition of SQL Server there is a free OLE DB driver for DB2 from Microsoft. See if you can use that to connect without issues.

    Kind regards,
    Gift Peddie

  • April 6, 2010 at 9:07 am

    #1146547

    Did you ever get this working? I'm up against the same issue. However, the Microsoft version of DB2 driver won't work because I'm on standard.

    Thanks,

    Dave

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply