ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Trigger Setup
DrillDown Icon System Setup
DrillDown Icon General Setup
DrillDown Icon General Setup Introduction
DrillDown Icon Number System
DrillDown Icon Adminstrative and Production Calendar
DrillDown Icon Administrative Departments
DrillDown Icon Designate a PDF directory
DrillDown Icon Payment Terms
DrillDown Icon Sales Tax Authority Table
DrillDown Icon Standard Foot Notes
DrillDown Icon User Defined Reports Setup
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields & Definitions
DrillDown Icon How To .....
DrillDown Icon Setup the User Defined Reports
DrillDown Icon Setup the ODBC for Crystal Reports
DrillDown Icon Custom Crystal Reports Created by Manex
DrillDown Icon System Appearance
DrillDown Icon Wireless Interface to ManEx Development
DrillDown Icon Sales
DrillDown Icon Production
DrillDown Icon Material
DrillDown Icon FAQs
DrillDown Icon Quick Start
DrillDown Icon Operations Manuals
DrillDown Icon Accounting Manuals
DrillDown Icon System Utilities
DrillDown Icon Definitions
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Setup the ODBC for Crystal Reports
 Check setting for an ODBC data source, which is usually found under:
      Start > Programs > Administrative Tools> Data Sources(ODBC), or 
      Start > Settings > Control Panel > Data Sources (ODBC).
 
 If you cannot find it under either of these locations you may want to go to the "Start" and do a search:
 
 
 
 
To download and run the    drivers click here

 
Enter the "System DSN" tab:
 
 
 
Click “Add” and you will see the New Data Source wizard, select “Microsoft Visual FoxPro Driver”, and click “Finish”
 
 
 
ODBC Visual FoxPro Setup pops up. Enter a name and description. The Database type should be “Visual FoxPro database (.DBC), and you should select “Manex.DBC” in server Manex DBFS folder.
 
 
 
Depress OK, the setup process is complete and the new file should display in the ODBC Data Source Administrator/System DSN. 
 
 
 
 
  • If the end machine is setup as a 64 Bit machine and it is not making available the VFP ODBC drivers for you to select from, Download and install odbcad32.exe on the 64 bit machine. The VFP ODBC drivers should now be available to select from. Make sure that the drivers are configured to match the report as it was originally designed. The same reports should now work on both 32 bit and 64 bit machines.
  • The VFP ODBC Driver can be installed under 64-bit Windows but 64-bit applications cannot access VFP ODBC driver because it comes only in 32-bit version. For 32-bit applications under 64-bit Windows there's ODBC Data Source Administrator for the 32-bit ODBC drivers. Download and install odbcad32.exe

 
Article ID: 3055