If you see this error on a Crystal Reports step, Crystal Reports is unable to log on to the database tables. This article explains how to check and update the connection type.
There are several possible causes, but all relate to Crystal Reports being unable to connect to the database. Codeless Platforms advise using an OLEDB connection within the report, as this is the most stable option. Follow these steps to check or update the connection type:
Open the report in Crystal Designer.
In the menu bar, click Database and select Set Datasource Location.
On the Current Data Source, expand the properties node. The details of the connection saved in the report are now displayed.
To change the connection type, follow these steps:
In the Replace With pane, expand OLE DB.
Double-click Make New Connection.
Enter the Server details, user credentials of an account to log into the SQL server and select the database to connect to.
Click **Next**.
Click Finish.
Expand your new connection, dbo, tables.
Update each table by selecting it in the Current Data Source pane.
Select the relevant table under the Replace With pane and click Update.
When all tables have been updated, click Close.
Save the report template.
Open the failing task in TaskCentre.
Open the crystal report step.
Import the updated report template into the task.
Apply the credentials in the Database Tables Logon Information.
Apply any Mapped Report Parameters.
Click OK to save the step.
Click **OK** to save the task.
Queue the task.