Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3153
  • Last Modified:

ColdFusion Error - Selected collating sequence not supported by the operating system.

Hi everyone,

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.
0
welcomm
Asked:
welcomm
  • 5
  • 5
1 Solution
 
Tacobell777Commented:
Did the collation of the database change somehow?
0
 
welcommAuthor Commented:
Nothing changed, I did an exact copy/paste of the wwwroot directory (which contains not only the website that now does not work but also its associated database) from the old server to the new server, preserving all file locations relative to the wwwroot directory.
0
 
MauseCommented:

What is the query cf trying to run?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
welcommAuthor Commented:
Here is the only query on the index page:

<cfquery name="GETSPPSAPPS" datasource="#ds2#">
      SELECT * FROM SPPS_APP
      ORDER BY SPPS_APP_TITLE
</cfquery>

It's a simple select all query, and then an order by Title.
0
 
welcommAuthor Commented:
Thanks, but I already looked at that - my database is fine (per that article).

Is it any coincidence that when I remove the line "ORDER BY SPPS_APP_TITLE" from the query that it works just fine?  There are MANY other queries all throughout my other web pages that use the ORDER BY command and they work just fine.
0
 
MauseCommented:
maybe it's just that table of your DB
0
 
welcommAuthor Commented:
Anything I can try in order to figure out if it is the table that is corrupt (by the way, the table is really small, only two fields and five records)?
0
 
MauseCommented:
Have you tried to rebuild it?

Are there more tables in your db that give the same error?
0
 
welcommAuthor Commented:
I ended up just rebuilding (using Access) the entire database and that solved that problem.
0
 
MauseCommented:
Why a C?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now