Symptom
- When using Microsoft JDBC Driver to connect to MS SQL 2008 images do not show up
Environment
- SQL Server 2008
- SAP Crystal reports 2011
- Crystal Reports 2008
- Microsoft JDBC Driver
Cause
- The following table structure is used:
UserID | int |
BLOBData | varbinary |
UpdateDate | datetime |
Resolution
- The datatype (SQL type) must be defined as image and not as varbinary
Keywords
pic picture var binary , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011