SAP Knowledge Base Article - Preview

2464854 - ODBC Database Connector Error with Access in Crystal Reports

Symptom

  • When creating Crystal report against MS Access database through ODBC connection the following error occures:
    Database Connector Error: '22007:[Microsoft][ODBC Microsoft Access Driver]Invalid datetime format on column number 3 (F3) [Database Vendor Code: 35 ]'
    ODBCError.png
    (The column number may be different)


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • MS Access 2007

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

crysta, reports, odbc, access, ms, microsoft, db, database, date, time, datetime, field, wrong, records, incorrect, insufficient, , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.