Hi, 

Hopefully this is the right sub forum for this. we have a product that reads/writes to SalesLogix via the SLXOLEDB provider. We are trying to add unicode support, but running into problems. Putting a literal unicode string into a SQL string, you usually add a N into the text. When I pass that through to the provider, I get an error back that says 'Failed to parse SQL'. Code looks vaugly like this (pseudo code, if you will)

This passes, but returns no records:

SELECT * FROM ACCOUNT WHERE NAME ='unicodecharactershere'

This fails with the above exception:

SELECT * FROM ACCOUNT WHERE NAME = N'unicodecharactershere'

i have also tried a parameterized query. But that was the same result. Anyone have thoughts or am i sol?

thanks.