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
