Hi I get this error with one my MFC application -

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve the collation conflict between "SQL_Latin1_General_CP1254_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"

I am trying to address once for all at application irrespecitve what collation the database is using - as this app can be used in diffrent places , also the user may want to support local language chars in the application - which have to be stored , fetched from DB.

As of now my DB is built with SQL_Latin1_General_CP1_CI_AS - which is a default.

I am trying to figure out what changes i would have to do in Application to achive this goal.

Or tweaking - international settings of ( PC host which hosts my application)

under HKEY_CURRENT_USER\Control Panel\International

any advise - is much awaited .. thanks 🙂