error adding table to data source in cr8.5 1

[robo15717]

Hi,

I am using Crystal Report 8.5 and database as SQL Server 2000.One of my tables is having a field of type binary.While adding this table to report, I am getting the following error message -

Unicode data in a unicode-only collation oe ntext data cannot be sent to clients using DB-library(such as ISQL) or ODBC version 3.7 or earlier.

How to solve this problem so that I can use this table in report?Please guide me.

Thanx in advance

 

[Turkbear]

HI,
Can you update your ODBC to a recent version?
( Are you using Microsoft's or Crystal's ODBC)?

 

[robo15717]

I am using microsoft's