SSRS ODBC Connectivity

• jayanta.sarkar01

  SSC Veteran

  Points: 251

  More actions

  May 12, 2013 at 1:48 pm

  #272467

  Hi

  I have create a ODBC connection for Sybase Db and Develop my RDL file. Its working fine when I am executing in local db.

  Now I wants to Upload the RDL in Report Manager. I am facing problem when I wants to create a ODBC DataSource in Report Manager (SSRS 2008R2).

  In DataSourceType: Selected ODBC

  In Connection String: What I needs to mention. Can anybody please explain me in details.

  I needs to implement it, I have done few rnd but no such environment available in personal to test and confirm.

  What I understood is in Connection string: I can mention the xxxxxxxx text from my RDS (created for ODBC - sybase connection) xml output file <ConnectString>Data Source=xxxxxxxxxx</ConnectString>

  Please correct me.

  Thanks in advance

  Jayanta