----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: ARUNUDAYA Message 1 in Discussion Hi , i have designed a report using the sqlserver say "server1", "Db1", "pw1","Table1" , here i am using Pull method of report generation at run time to show the report i am using this code. crvGrievanceStatus.ReportSource = new GrievancesReportForOfficer(); //setting log in info for report TableLogOnInfos rptTables = crvGrievanceStatus.LogOnInfo; TableLogOnInfo rptTable = rptTables["Table1"]; ConnectionInfo dbConnInfo = rptTable.ConnectionInfo; dbConnInfo.ServerName = "server1" dbConnInfo.DatabaseName = "Db1" dbConnInfo.UserID = "Pw1" dbConnInfo.Password = "Table1" but when i connect to different server, say "server2", "Db2", "pw2","Table1" and i am given the connection info code like this. crvGrievanceStatus.ReportSource = new GrievancesReportForOfficer(); //setting log in info for report TableLogOnInfos rptTables = crvGrievanceStatus.LogOnInfo; TableLogOnInfo rptTable = rptTables["Table1"]; ConnectionInfo dbConnInfo = rptTable.ConnectionInfo; dbConnInfo.ServerName = "server2" dbConnInfo.DatabaseName = "Db2" dbConnInfo.UserID = "Pw2" dbConnInfo.Password = "Table1" but when i run the report it gives me this exception "Failed to open a rowset " how to solve this problem ? i will most thankful if anybody give me the solution Regards, Arun Udaya Shankar.C ____________________________________________ Confidential: This electronic message and all contents contain information from Syntel, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify the sender immediately and destroy the original message and all copies. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
