1.

How To Create An Odbc Dsn For Dbase File?

Answer»
  1. Click Start -> Control panel -> ADMINISTRATIVE tools ->Data sources (ODBC) 
  2. Click ‘Add’, Select ‘Microsoft dBase Driver’ from the driver LIST, Click ‘Finish’. 
  3. A new dialog window will appear, give a name to DATASOURCE name, eg “Dbase” 
  4. Now check off ‘Use Current Directory’, Click on ‘Select Directory’ and provide the path where your dbase file resides. 
  5. Click ‘OK’, Click ‘OK’, Click ‘OK’. 
  6. Now open Crystal REPORTS.
  7. Click ‘Blank REPORT ‘, you will see a ‘Database Expert’ dialog box. 
  8. double click on ‘ODBC(RDO)’ 
  9. A ‘ODBC(RDO)’ dialog box will appear, select your DSN from the list. 
  10. Click ‘Finish’ 
  11. Now you will see the ‘Table’ under your DSN name. 
  12. Now select tables you want for reporting. 
  13. Click ‘Finish’.



Discussion

No Comment Found