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.
|
one more thing:
How can I set the "CollatingOrder" parameter of an Access DB?
I think I need it to be "General".
|
|
Changed. With the latest package, all created mdb file will use General. Now CollatingOrder isn't supported to as a connection property.
|
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?
|
>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.
|
>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.
|
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.
|
>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.
|
It works!
Thanks a lot for your help.
|
Main
webmaster@hxtt.com