Professional Web Applications Themes

MS Access query in MX 7 - Coldfusion Database Access

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 ...

  1. #1

    Default MS Access query in MX 7

    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 Guest

  2. #2

    Default MS Access query in MX 7

    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 Guest

  3. #3

    Default Re: MS Access query in MX 7

    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 ?
    guanghuijin Guest

Similar Threads

  1. Access Query
    By dave in forum Coldfusion Database Access
    Replies: 5
    Last Post: February 21st, 08:20 PM
  2. Access 2003 query not same as in CF
    By dtubbs in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 21st, 06:19 PM
  3. Access query help
    By Brandon Taylor in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 12th, 09:52 PM
  4. Access Query in ASP
    By Ambassador in forum ASP Database
    Replies: 2
    Last Post: March 2nd, 06:08 AM
  5. MS access SQL query help!
    By Ralph Sharett in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 28th, 12:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139