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 >
