Ok Man, try Out cr.Database.SetLogonInfo and give username and password you given at time of creating crystal report.
On Feb 26, 11:27 am, Ram Mohan Rama Chandran <[email protected]> wrote: > hi... > > try this > > Its Setdatabaselogin(id,pw) , this part of the reportdocument class. > > or > > 1. Open SQL Server Management Studio > 2. Select database engine (server) where database is created. > 3. Select “Security” folder. Followed by “Logins” folder. > 4. Check if there is “<server name>\ASPNET” as user exists. > - If not then right click on “Logins” folder & select “New Login”. > - User “Search” button if you want to make sure correct username path > is added to the “Logins” list. > > Crystal report uses ASPNET user hence SQL server must user login for ASPNET > account. > > On Thu, Feb 26, 2009 at 8:08 AM, vanitha palanisamy > <[email protected]>wrote: > > > > > > > HI > > > I changed table name as *"Bill"* but still the problem remains constant. > > > On Wed, Feb 25, 2009 at 2:33 AM, Jackie <[email protected]> wrote: > > >> Hi Vanitha, > > >> Your query is "Select * from Bill" but you are setting the datasource for > >> table "Products" (in code: rptDoc.SetDataSource(ds. > > >>> Tables["*product*"])), so can you try changing it to "Bill". The error I > >>> think is bcoz the dataset doesn't have the products table. > > >> * > >> Jasmin* > > >> On Wed, Feb 25, 2009 at 6:44 AM, vanitha palanisamy > >> <[email protected]>wrote: > > >>> Hi, > > >>> my code is > > >>> protected void Page_Load(object sender, EventArgs e) > >>> { > > >>> DataSet1 ds = new DataSet1(); > >>> string strConn = > >>> ConfigurationManager.ConnectionStrings["BillDtsConnectionString"].ConnectionString; > >>> SqlConnection conn = new SqlConnection(strConn); > >>> string str = "select * from bill"; > >>> SqlDataAdapter da = new SqlDataAdapter(str, conn); > >>> da.Fill(ds, "Bill"); > > >>> ReportDocument rptDoc = new ReportDocument(); > > >>> rptDoc.Load(Server.MapPath("CrystalReport1.rpt")); > >>> rptDoc.SetDataSource(ds.Tables["product"]); > >>> CrystalReportViewer1.ReportSource = rptDoc; > >>> CrystalReportViewer1.DataBind(); > >>> } > > >>> When i run this code am getting error as > > >>> Logon failed. Details: crdb_adoplus : Object reference not set to an > >>> instance of an object. Error in File C:\DOCUME~1\AS\LOCALS~1\Temp\ > > >>> CrystalReport1 {786134AC-53BE-4210-9505-FC7F13188C03}.rpt: Unable to > >>> connect: incorrect log on parameters. > > >>> Can u say how to clear this one? > > >>> On Tue, Feb 24, 2009 at 9:01 PM, Manikandan .C > >>> <[email protected]>wrote: > > >>>> Dear Vanitha > > >>>> Are you created a object of Crystal report? > > >>>> Then set file Properties of Crystal report object like as Database, etc > > >>>> Manikandan.C > > >>>> On 2/25/09, vanitha palanisamy <[email protected]> wrote: > > >>>>> Hi folks, > > >>>>> Am using crystal report in asp.net.Am <http://asp.net.am/> dynamically > >>>>> creating dataset for crystal report. > > >>>>> But when i run the report am getting error as > > >>>>> Logon failed. Details: crdb_adoplus : Object reference not set to an > >>>>> instance of an object. Error in File > >>>>> C:\DOCUME~1\AS\LOCALS~1\Temp\CrystalReport1 > >>>>> {786134AC-53BE-4210-9505-FC7F13188C03}.rpt: Unable to connect: > >>>>> incorrect log > >>>>> on parameters. > > >>>>> Could anyone help? > > -- > R.Ram Mohan > Kuwait. > Mobile :-00965-94063743- Hide quoted text - > > - Show quoted text -
