Report Design: Logon failed. Details: ADO Error Code

Print Page | Close Window

Logon failed. Details: ADO Error Code

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5193
Printed Date: 04 May 2024 at 12:39pm

Topic: Logon failed. Details: ADO Error Code

Posted By: qasimali84
Subject: Logon failed. Details: ADO Error Code
Date Posted: 13 Jan 2009 at 5:49am

I am using VS 2005 and built in Crystal reports in VS 2005

I am developing a crystal reports for multiple sections of an organization.
My reports contain five sub reports. And for some calculation I am passing 7 parameters from outside.

It is working fine in Crystal report preview.
But when I am calling this report in my web page. It shows the following error
Logon failed. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Login failed for user 'sa'. SQL State: 42000 Native Error: Error in File C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\rptDailyIncomeHospital {3307C835-FD2D-43DD-84D0-7A90C11811CE}.rpt: Unable to connect: incorrect log on parameters.

Although I am passing correct connection parameters and reports parameters

Help me in this matter please.

Print Page | Close Window