Crystal Report Logon Failure

1
votes

I am getting error while opening Crystal Report from my asp.net application at production server. Credentials are define in web.config. In web.config we have userid, password, server and database name. here is the error:

Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Error in File C:\Windows\TEMP\OrderAudit {5A4491A4-BFD5-4EA4-8806-94A7CED3467A}.rpt: Unable to connect: incorrect log on parameters.

When I connected to my production database server from my localhost reports are opening okay. any solution?

2
c#asp.netcrystal-reports
can you run the report on the production server in crystal reports? it may be a config error somewhere – MD-Tech

2 Answers

2
votes

Crystal is trying to tell you that the ADO database provider is not installed on the machine.

For example, if you are connecting to an Oracle database, then the Oracle driver needs to be installed on the ASP.Net server.

1
votes

Download and install sqlncli.msi (SQL Native Client driver) from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15748