SAP Knowledge Base Article - Public

1370559 - ODBC Export: Limit on Number of DSN = 100

Symptom

  • A machine that has more than 100 ODBC DSNs
  • Only the first 100 ODBC DSNs (chronologically) show up in the ODBC export dialog.

Reproducing the Issue

  • Crystal Reports XI R2
  •  RDC
  • Visual Basic 6.0 application

Cause

  • In the source to allocate the number of DSN Crystal Reports will populate the drop down list 
  • Crystal Reports is limited to 100 entries

Keywords

Export, DSN, RDC, ODBC , KBA , BI-DEV , Business Intelligence Software Development Kits (SDKs) , How To

Product

SAP Crystal Reports XI R2