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. | ||
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". | ||
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. | ||
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? | ||
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. | ||
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. | ||
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. | ||
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. | ||
Patrice | 2006-02-14 00:00:00.0 | |
It works!
Thanks a lot for your help. |