>>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.


I think I found the primary cause. The .NET app was using a connection string with Collating Sequence=general. The index is MACHINE.