Crystal Report Generating error for push model while printing or exporting
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.