Solved

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

Posted on 2004-09-08
11
3,141 Views
Last Modified: 2013-12-20
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
Comment
Question by:welcomm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
11 Comments
 
LVL 17

Expert Comment

by:Tacobell777
ID: 12011404
Did the collation of the database change somehow?
0
 

Author Comment

by:welcomm
ID: 12011506
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
 
LVL 10

Expert Comment

by:Mause
ID: 12015072

What is the query cf trying to run?
0
Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

 

Author Comment

by:welcomm
ID: 12017510
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
 
LVL 10

Expert Comment

by:Mause
ID: 12019338
0
 

Author Comment

by:welcomm
ID: 12019565
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
 
LVL 10

Expert Comment

by:Mause
ID: 12019583
maybe it's just that table of your DB
0
 

Author Comment

by:welcomm
ID: 12023643
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
 
LVL 10

Accepted Solution

by:
Mause earned 350 total points
ID: 12023956
Have you tried to rebuild it?

Are there more tables in your db that give the same error?
0
 

Author Comment

by:welcomm
ID: 12070326
I ended up just rebuilding (using Access) the entire database and that solved that problem.
0
 
LVL 10

Expert Comment

by:Mause
ID: 12072159
Why a C?

0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question