MS Access query in MX 7

[Eric Hung]

Hi, Please help me.
Oour company's websit was located in HostMySite. In the recently, they upgrade
their server to Windows 2003 and upgrade ColdFusion from MX6.1 to MX7.0. Before
that, our website doesn't have any problem. After their upgrade, some of
function get the error message as below example: Could any one help me to solve
the problem?

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Selected collating sequence not supported by the operating
system.

The error occurred in C:\websites\iponlyChen\CF\VSL\VSLWKcn.cfm: line 110

108 : SELECT *
109 : FROM SAILINGS
110 : WHERE WEEK = #WEEKNO#
111 : ORDER BY CLOSINGDATE,VESSEL
112 : </CFQUERY>




--------------------------------------------------------------------------------

SQL SELECT * FROM SAILINGS WHERE WEEK = 11 ORDER BY CLOSINGDATE,VESSEL
DATASOURCE DBMTGVSL
VENDORERRORCODE -5026
SQLSTATE HY000

[Eric Hung]

Hi, Please help me.
Oour company's websit was located in HostMySite. In the recently, they upgrade
their server to Windows 2003 and upgrade ColdFusion from MX6.1 to MX7.0. Before
that, our website doesn't have any problem. After their upgrade, some of
function get the error message as below example: Could any one help me to solve
the problem?

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Selected collating sequence not supported by the operating
system.

The error occurred in C:\websites\iponlyChen\CF\VSL\VSLWKcn.cfm: line 110

108 : SELECT *
109 : FROM SAILINGS
110 : WHERE WEEK = #WEEKNO#
111 : ORDER BY CLOSINGDATE,VESSEL
112 : </CFQUERY>




--------------------------------------------------------------------------------

SQL SELECT * FROM SAILINGS WHERE WEEK = 11 ORDER BY CLOSINGDATE,VESSEL
DATASOURCE DBMTGVSL
VENDORERRORCODE -5026
SQLSTATE HY000

[guanghuijin]

I met same error before. I guess you used language other than english in your database. Check if your new installed windows, Access and CF support multi-language or not ?