Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
error: selected sort order is not supported by the operating system
Patrice
2006-02-13 00:00:00.0
Hi,
I'm using HXTT Access to generate an Access DB from Linux.
Sometimes when I open the generated DB with MS Excel and the ODBC driver I get an error, which translated to english says something like this:

"selected sort order is not supported by the operating system"

This only happens under Windows XP.

I tried using the Cp1252 characted encoding, but I still get the same problem
Properties properties=new Properties();
properties.setProperty("charSet","Cp1252");
conn = DriverManager.getConnection("jdbc:access:///" + dir,properties);

The data contains western european characters.

Any help is very welcome.
Re:error: selected sort order is not supported by the operating system
Patrice
2006-02-13 00:00:00.0
one more thing:
How can I set the "CollatingOrder" parameter of an Access DB?
I think I need it to be "General".

Re:Re:error: selected sort order is not supported by the operating system
HXTT Support
2006-02-13 00:00:00.0
Changed. With the latest package, all created mdb file will use General. Now CollatingOrder isn't supported to as a connection property.
Re:Re:Re:error: selected sort order is not supported by the operating system
Patrice
2006-02-13 00:00:00.0
Thanks for replying.
You said "all created mdb file WILL use General". Does this mean such a driver is not released yet?

I bought the driver a few days ago and it seems the CollatingOrder is not "General".

I don't understand why I get this error only on some DBF files. I generate a collection of DBF files (structure and data) and only a few of them are unreadable under windows XP.

Any idea?
Re:Re:Re:Re:error: selected sort order is not supported by the operating system
HXTT Support
2006-02-13 00:00:00.0
>You said "all created mdb file WILL use General". Does this mean such a driver is not released yet?
You can visit www.hxtt.com site to download the latest package which has supported it.
Re:Re:Re:Re:Re:error: selected sort order is not supported by the operating system
HXTT Support
2006-02-13 00:00:00.0
>I don't understand why I get this error only on some DBF files. I generat
>collection of DBF files (structure and data) and only a few of them are >unreadable under windows XP.
Have you seen "selected sort order is not supported by the operating system" in HXTT DBF too? charSet=Cp1252 should work normally with HXTT DBF.
Re:error: selected sort order is not supported by the operating system
Patrice
2006-02-13 00:00:00.0
I will download the latest package, though I think I'm already using this one.

You said:
Have you seen "selected sort order is not supported by the operating system" in HXTT DBF too?
No, it only happens when I open the MDB file with excel on windows XP for instance.
Re:Re:Re:Re:Re:Re:Re:error: selected sort order is not supported by the operating system
HXTT Support
2006-02-13 00:00:00.0
>I will download the latest package, though I think I'm already using this one.
You haven't download it since the latest package is upload after received your support request.
Re:error: selected sort order is not supported by the operating system
Patrice
2006-02-14 00:00:00.0
It works!
Thanks a lot for your help.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap