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
HXTT Access Questions
Michael Germann
2007-01-23 06:56:17.0
Hello

We are evaluating HXTT Access 2.1 and have the
following questions:

1. Does HXTT Access 2.1 run with JRE 1.6.0 ?
2. We had problems to issue sql-select statments
with blanks or special characters in where
clause strings ie.

select x,y,objid from gs_street where street='Am Wasser Weg'

The same select without blanks in where clause
returned with success. We are using Access 97
.mdb files on windows xp. Is this a known problem ?

Thank you for your help.

Regards,

Michael Germann
Re:HXTT Access Questions
HXTT Support
2007-01-23 07:31:55.0
1.Does HXTT Access 2.1 run with JRE 1.6.0?
Yes.

2. We had problems to issue sql-select statments with blanks or special characters in where clause strings ie.

Please zip your access file and send it to our email box(webmaster@hxtt.com or webmaster@hxtt.net). We will check and fix it.

Re:Re:HXTT Access Questions
HXTT Support
2007-01-24 19:30:10.0
I guess that you should have an index on street column. Because Access 97 will use different index encoding for different charSet, so we need to check your mdb sample.
Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-25 01:49:22.0
Hello

As we had problems to send you the
requested file by email (virus alert),
you can download the requested file
from our webserver:

http://www.infogrips.ch/download/test.zip

Regards,

Michael Germann
Re:Re:Re:Re:HXTT Access Questions
HXTT Support
2007-01-25 06:32:11.0
Thanks for your sample. Supported. Please download the latest package.
Re:Re:Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-25 06:36:03.0
Hello

We downloaded the package yesterday.
Do you say: we have to download it
again (new version) ?

Regards,

Michael Germann
Re:Re:Re:Re:Re:Re:HXTT Access Questions
HXTT Support
2007-01-25 18:03:43.0
Yeah. You need to redownload.
Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-26 00:33:46.0
Hello

Thank you for the fix. Now
blanks are no problem anymore,
but special german characters
(Umlaut) still do not work ie.

'Alte Z��rcherstrasse'

You can find serveral examples
in the test .mdb file.

Regards,

Michael Germann
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
HXTT Support
2007-01-28 06:04:57.0
>but special german characters (Umlaut) still do not work ie.
Supported. Please download the latest package.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-29 01:09:29.0
Hello

We downloaded the new version. Now
it somewat better, but still not
perfect. For example

'Alte Z��rcherstrasse' is found

but

'R��tiweg' is not found.

There is still a problem with german
Umlaut characters. Do we have to specify
the characterset by calling some
java function ?

Regards,

Michael Germann
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
HXTT Support
2007-01-29 02:54:13.0
>'Alte Z��rcherstrasse' is found
>but 'R��tiweg' is not found.
What's your Access 97 local version? What's your sort order for mdb file?
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-29 04:06:43.0
Hello

See the test .mdb at

http://www.infogrips.ch/download/test.zip

It has to be possible to select any
street value (with or without Umlaut or
Blank / special character).

Regards,

Michael Germann
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
HXTT Support
2007-01-29 04:26:29.0
I download http://www.infogrips.ch/download/test.zip on 25th, and you can remove it to avoid your sensitive information leak. I wonder just what's your Access 97 local version because some index rules for your local language need to be cracked again:)
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-29 05:58:00.0
Hello

We used Access 97 SR-1 german version to
create the database. The database
was filled only by ODBC calls through
the Microsoft Access ODBC driver (not
with Access user interface). I hope this
helps.

Regards,

Michael Germann, infoGrips GmbH
Re:HXTT Access Questions
HXTT Support
2007-01-29 08:20:34.0
Supported. Thanks.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-30 02:29:28.0
Hello

You say "supported". Is there a new version
available for download ?

Regards,

Michael Germann
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
HXTT Support
2007-01-30 03:54:28.0
Yeah.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions
Michael Germann
2007-01-30 04:02:16.0
Hello

Now it works. Thank you very much
for your quick help.

Regards,

Michael Germann

PS: You can keep the test.mdb for
test purposes. This is not
productive data.

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