Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS ODBC Connectivity Expand / Collapse
Posted Sunday, May 12, 2013 1:48 PM


Group: General Forum Members
Last Login: Thursday, May 26, 2016 12:47 PM
Points: 19, Visits: 97

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

Post #1451929
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse