3
Reply

Crystal Report Generating error for push model while printing or exporting

Ezhar Anasri

Ezhar Anasri

May 6 2011 7:50 AM
3k
HI
 I have created a Crystal report using push model. While viewing the data I am getting the correct output as I have already used
SetDatabaseLogon() method.
But While I am trying to print or export I am getting this 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\3edge\LOCALS~1\Temp\Form-3A {ED78A428-2AA9-40FD-9D61-16D33D548D83}.rpt: Unable to connect: incorrect log on parameters.

While I check then I found that I am using OLE DB connectivity to SQL Server (SQL Authentication) and my SQL db is in a server. And the Database expert in not saving my password when ever I am creating a Connection

Please help me how to come out this problem.
Thnx in Advance.

Answers (3)