Skip to Content

1. Open Crystal and select a report to open in Design view.

2. From the Database main menu, select Set Database Location.

/wp-content/uploads/2012/07/1_124746.jpg

3. When an ODBC connection in History or Current Connections is not present:

a.Expand the Create New Connection folder.

b.  Expand the ODBC (RDO) folder within the Create New Connection folder to open the ODBC (RDO) screen.

/wp-content/uploads/2012/07/2_124747.jpg

c. Select the “Enter Connection String” radio button.

d. Enter the connection string as Driver=Pervasive ODBC Client Interface;ServerName=xxx;dbq=rdp01 where xxx is your computer name).

/wp-content/uploads/2012/07/3_124751.jpg

e. Click on Finish

4. In the “Current Data Source” section of the screen, highlight “..\..\file.ddf”, and in the Replace With section, select the “Driver=Pervasive ODBC Client Interface;ServerName=xxx;dbq=rdp01” just defined in the ODBC folder

/wp-content/uploads/2012/07/4_124752.jpg

5. Click on Update to change the data source of the report.

/wp-content/uploads/2012/07/5_124753.jpg

Note: You can also directly create report based on ODBC Connection String.

Hope this document will also provide you another way of using the ODBC connection in Crystal Reports.

– Bwuser

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply