Article ID	1856
Article Title	PROBLEM: DataFlex is not Displayed in Crystal 9 "New Connection" Tree
Article URL	http://www.dataaccess.com/KBasePublic/KBPrint.asp?ArticleID=1856
KBase Category	Crystal Reports
Date Created	07/16/2003
Last Edit Date	05/31/2007

Article Text
PROBLEM:
After installing Crystal 9 and the Connectivity Kit, I do not see "DataFlex" listed in the Set Datasource Location tree under "Create New Connection" (From the Designer, selecting Database | Set Datasource Location -- the tree will be displayed in the "Replace with" window). What should I do?

SOLUTION:
You need to make sure all the files (i.e. apidll.dll, df_collate.cfg, p2bdfapi.dll and crdb_p2bdfapi.dll) are in place and Crystal can find them. Check if there is no other version of the Connectivity Kit files in other drectories -- like c:\Winnt\System32 or c:\Windows\System, depending on the version of Windows.

Also, double-check your registration information -- you need to enter the Crystal Reports Connectivity Kit registration iformation when installing Crystal Reports Connectivity Kit. Do not enter Crystal's or Visual DataFlex registration, they may be accepted by the registration program but will cause errors and not print your reports.

To check the registration you entered, go to Crystal's directory (default C:\Program Files\Crystal Decisions\Crystal Reports X -- where X is the version of Crystal you installed) and see if the .DFR file present in that directory is CR<CK Serial Number>.DFR. If it is not, re-register the Connectivity Kit using the CK's registration information.


Refer to the Connectivity Kit User's Guide for more information.


Note1:
Add Crystal's bin directory (default C:\Program Files\Common Files\Crystal Decisions\2.0\bin) to the PATH environment variable so that the Crystal files can be easily found.

Note2:
To have the .DAT files listed when clicking on "DataFlex" from the "Create New Connection" tree, make sure you add
;*.dat
to the "Database File Filter" form (File | Options | Data Source Defaults tab).


Important!
Make sure you have only one copy of each Crystal or Connectivity Kit files -- Example: Having crdb_p2bdfapi.dll in multiple locations will generate errors (DataFlex will not be displayed in the "New Connection" tree, error "The database DLL 'crdb_p2bdfapi.dll' could not be loaded." or even "Failed to Create the Crystal Query Engine" may be displayed when trying to run a report)



KEYWORDS:
new connection tree, DataFlex connection, DataFlex tree


Contributed By:
Marcia Booth
Company: Data Access Worldwide
Web Site: http://www.dataaccess.com

Links Related to this Article
DAW Knowledge Base article 1695: HOWTO: Check DLLs necessary for Deployment
DAW Knowledge Base article 1854: PROBLEM: Exporting Crystal 9 Reports from VDF Applications
DAW Knowledge Base article 1871: HOWTO: Add DataFlex File Extensions to Crystal Reports 9
DAW Knowledge Base article 1968: HOWTO: Avoid Problems with Crystal Reports 9 running from VDF

Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2024 Data Access Corporation. All rights reserved.

The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.