Set up the OLE DB (ADO) for SQL Crystal Reports : Support

Set up the OLE DB (ADO) for SQL Crystal Reports Print

Modified on: Thu, 30 Jun, 2022 at 1:30 PM

To setup the OLE DB, complete the following steps:

1. Within Crystal Report Designer, depress the "Add/New report" icon at the top of the screen.

The Standard Report Creation Wizard will display.

Select the "Create New Connection" option.

2. Scroll down through the available options until you find the folder name, "OLE DB(ADO)"

Then, select "OLE DB(ADO)."

3. Select SQL Server Native Client 11.0

4. Next, populate your SQL Server information. See example below:

5. On the next screen, select "Finish."

6. The Standard Report Creation Wizard will then proceed to walk you through the Table/Procedure selection.

Did you find it helpful? Yes No

Set up the OLE DB (ADO) for SQL Crystal Reports Print