can you paste the code and error here. On Fri, Feb 27, 2009 at 7:36 AM, vanitha palanisamy <[email protected]>wrote:
> Hi, > > I tried both methods. > But still the problem remains constant. > > > On Wed, Feb 25, 2009 at 10:27 PM, 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 >> > > -- R.Ram Mohan Kuwait. Mobile :-00965-94063743
