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["Bill"]);
CrystalReportViewer1.ReportSource = rptDoc;
CrystalReportViewer1.DataBind();
}
error is:
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.
On Fri, Feb 27, 2009 at 12:34 PM, Ram Mohan Rama Chandran <
[email protected]> wrote:
> 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
>
