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