ColdFusion Error - Selected collating sequence not supported by the operating system.
Posted on 2004-09-08
After copying the entire wwwroot directory from our old web-server (2k SBS) to our new 2003 box, one of our websites decided not to work anymore. When it is viewed on the 2003 box, this error appears:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system.
This error only occurs on one website, in one section (that section being the front-end; the back-end administration section works just fine, go figure). I know for a fact that the coldfusion running on my 2003 machine can successfully access databases (MS Access databases) because it works without a hitch on some of out other coldfusion based websites located in wwwroot on this server.
I've checked and rechecked the ODBC Data Sources in 2003, and the Data Sources in the ColdFusion administrator, all verify just fine.
I'm at my wit's end with this problem, any help will be appreciated greatly.