Open Crystal and select a report to open in Design view. From the Database main menu, select Set Database Locatio n. When an ODBC connection in History or Current Connections is not present: a.Expand the Create New Connection folder. Expand the ODBC (RDO) folder within the Create New Connection folder to open the ODBC (RDO) screen. Using an ODBC connection to load a Crystal Report in Code-Behind. For legacy reports with SQL Server ODBC, using 'SQL Server Native Driver 11.0' might be needed. Jul 31, 2012 1. Open Crystal and select a report to open in Design view. From the Database main menu, select Set Database Locatio n. When an ODBC connection in History or Current Connections is not present: a.Expand the Create New Connection folder. Expand the ODBC (RDO) folder within the Create New Connection folder to open the ODBC (RDO) screen. The Data Direct ODBC drivers are only enabled for data retrieval by Crystal Reports, in Crystal Reports designer, Crystal Reports when viewed in BusinessObjects Enterprise, or Crystal Reports when viewed in SAP BusinessObjects Business Intelligence Platform, and Crystal Servers, and are not enabled for use by any other BusinessObjects products.
1. Open Crystal and select a report to open in Design view.
2. From the Database main menu, select Set Database Location.
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.
c. Select the “Enter Connection String” radio button.
d. Enter the connection string asDriver=Pervasive ODBC Client Interface;ServerName=xxx;dbq=rdp01where xxx is your computer name).
Crystal Reports Odbc Driver Download
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
5. Click on Update to change the data source of the report.
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
I run Office 2016 64-bit, including Access, on Windows 10.
I have an Access *.accdb database maintained by this MS Access instance.
And I have a 32-bit application (Crystal Reports 2008) which should access this db.
Therefore I tried to setup an ODBC DSN with the 32-bit Access driver using the 32-bit variant of the ODBC Administrator. This didn't work as apparently the relevant driver file odbcji32.dll is missing (discussed in http://answers.microsoft.com/en-us/office/forum/office_2016-access/unable-to-load-odbcji32dll/de67abd0-f4d8-40af-8e5f-1922b8393d7e) - and I installed an Access 2013 64-bit runtime. Sunix comhub driver.
Crystal Reports Odbc Driver 2016
Now I have the odbcji32.dll (version 10.00.10586.00) on my system and created a system DSN for this database - the ODBC Admin is happy with that.
But when I try to access the db by Crystal Reports I get an error 'Unrecognized database format ..' and the filename. Then I tried to use this system DSN with other 32-bit applications: the same error.
The very unfortunate status is now that I have to use 32-bit applications which should access *.accdb Access databases and can't get it working for unknown reasons.