Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 9:18 AM
Points: 17, Visits: 81
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
Post #1451929
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse