locked
Error "Selected collating sequence not supported by the operating system." RRS feed

  • Question

  • User1270199477 posted

    here's hte problem I have.

    I create a simple page inserting data to Microsoft access 2007.  On my local computer, I have no problem inserting both arabic and english. but after i upload the app on production server. its not working.

    heres' the error message " 

    Selected collating sequence not supported by the operating system.

     

    After hours searching on google,  alot ppl said its version issue, but I have english access 2007 installed on my computer and admin told me they have english access 2007 installed on the server too.

     

    what else should i check???????

     

     

    Wednesday, March 2, 2011 5:13 PM

Answers

  • User-2064262021 posted

    Hi,

    It seems that you have a "simple page inserting data to Microsoft Access 2007"
    This works on your local machine, but fails with the following error on the production server:
    "Selected collating sequence not supported by the operating system."

    To get a better idea of the issue so I can better help you, please answer the following questions:
    =========================
    In what language is the "simple page" written?
    Is this an ASP page running on a Web Server?
    Is the server running a 32-bit or 64-bit version of Windows?

    If the server is running on a 64-bit version of Windows the key you are looking for is under:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\

    More importantly though is, as noted in bullet 4 in the following page, we do not support using the ACE driver (i.e. Access 2007) from a web application:

    2007 Office System Driver: Data Connectivity Components
    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891

    Thanks,

    Cathy Miller

    Microsoft Online Community Support

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 7, 2011 11:47 AM

All replies

  • User1867929564 posted

    read this,

    http://msdn.microsoft.com/en-us/library/bb210414(v=office.12).aspx

    http://msdn.microsoft.com/en-us/library/bb221810(v=office.12).aspx

    http://support.microsoft.com/kb/202150

    http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21319011.html

     

    Thursday, March 3, 2011 1:58 AM
  • User1270199477 posted

    thank you, KumarHarsh

     

    http://msdn.microsoft.com/en-us/library/bb210414(v=office.12).aspx

    this page just one line.  "You tried to link a Paradox table that was created with an international sort order that is not the same as the one you are using."  didn't tell me how to fix it.

     

    http://msdn.microsoft.com/en-us/library/bb221810(v=office.12).aspx

    this one has detail solution, but its not working.

    "Start the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Paradox key, and select the CollatingSequence value."

     

    I went there "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\", there's no Access Connectivity Engine.

     

    http://support.microsoft.com/kb/202150

     

    already checked this page, not working.

     

    http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21319011.html

     

    this one needs  you to sign up and give them your credit card number.  not comfortable doing that.

     

     

    Thursday, March 3, 2011 10:22 AM
  • User1867929564 posted

    http://forum.gsmhosting.com/vbb/archive/t-475653.html

    http://www.bigresource.com/Tracker/Track-ms_access-xPwms015/

    http://support.jodohost.com/showthread.php?t=3445

    http://www.xtremevbtalk.com/archive/index.php/t-221944.html (read last)

    http://www.aspspider.com/qa/Question510.aspx

     

    Friday, March 4, 2011 1:18 AM
  • User-2064262021 posted

    Hi,

    It seems that you have a "simple page inserting data to Microsoft Access 2007"
    This works on your local machine, but fails with the following error on the production server:
    "Selected collating sequence not supported by the operating system."

    To get a better idea of the issue so I can better help you, please answer the following questions:
    =========================
    In what language is the "simple page" written?
    Is this an ASP page running on a Web Server?
    Is the server running a 32-bit or 64-bit version of Windows?

    If the server is running on a 64-bit version of Windows the key you are looking for is under:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\

    More importantly though is, as noted in bullet 4 in the following page, we do not support using the ACE driver (i.e. Access 2007) from a web application:

    2007 Office System Driver: Data Connectivity Components
    http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891

    Thanks,

    Cathy Miller

    Microsoft Online Community Support

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, March 7, 2011 11:47 AM