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

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

 

 

Answer 1

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

 

Answer 2

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.

 

 

Answer 3

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

 

Answer 4

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