I am trying to import paradox database data in sql server 2005 and ms access. I am getting an error called Incorrect Collating Sequence. Prior my system format it was working perfectly fine but after i formatted the system i am getting that error.
I tried different collating sequences and even tried setting collating sequence through the connection string but the error poped.
What could be the causes and how can i fix this?