>>I am not sure, I am not the one accessing the data. I have to assume it is the default settings.
>>
>>>
>>>What are SET EXACT settings in OLE DB? And SET ANSI?
>
>I think in these settings (and also deleted settings) may be a problem.

Thanks, I will look into these and see if it helps.