Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
HXTT Access Driver capabilities
Tim Valentine
2010-05-25 10:44:02
We are using the HXTT MS Access Embedded driver to build mobile applications for a U.S. Gov't customer.

Currently, we have a successful implementation of the HXTT MS Access Embedded driver for standard MS Access databases (i.e. with file extension .MDB) on mobile devices.

We now have a requirement to use an older mobile format of the MS Access database in a compacted structure (i.e. with file extension .CDB) which is produced by Microsoft ActiveSync version 4.2 and older. I tried to connect to, load, and query the MS Access compacted database and the driver failed. I set the driver property "otherExtension" to "CDB" and the driver again failed.

I suspect the HXTT MS Access Embedded driver does not have the capability to handle the MS Access compacted mobile database format and structure.

Your response and insight into this matter is greatly appreciated.

Thank you.

Following is the exception encountered when trying to connect to and use an MS Access compacted mobile database:

java.sql.SQLException: Failed to load database IMA! For more information, please use SQLException.getNextException().
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.aw.int(Unknown Source)
at com.hxtt.sql.access.aw.for(Unknown Source)
at com.hxtt.sql.access.aw.(Unknown Source)
at com.hxtt.sql.access.au.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.aw.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.bc.a(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
at com.hxtt.sql.bq.if(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.bq.a(Unknown Source)
at com.hxtt.sql.bq.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.dk.executeQuery(Unknown Source)
at gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataTransactor.selectUsingParameters(FSAccessDataTransactor.java:159)
at gov.usda.fs.iweb.mobile.utils.managers.BaseDatabaseDataTransactor.processTransaction(BaseDatabaseDataTransactor.java:61)
at gov.usda.fs.iweb.mobile.utils.managers.BaseDatabaseDataManager.processEvent(BaseDatabaseDataManager.java:160)
at gov.usda.fs.iweb.mobile.framework.FSMobileFramework.processDataEvent(FSMobileFramework.java:558)
at gov.usda.fs.iweb.mobile.framework.FSMobileFramework.run(FSMobileFramework.java:390)
at java.lang.Thread.run(Thread.java:619)

DEBUG 25 May 2010 13:20:58,730 [Thread-2]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataTransactor ->
msg = FSAccessDataTransactor.selectUsingParameters() : SQLException : Failed to load database IMA! For more information, please use SQLException.getNextException().

DEBUG 25 May 2010 13:20:58,730 [Thread-2]=>
class = gov.usda.fs.iweb.mobile.utils.managers.msaccessdatamanager.FSAccessDataTransactor ->
msg = FSAccessDataTransactor.selectUsingParameters() : SQLException.nextException : An unknown Access database file
Re:HXTT Access Driver capabilities
HXTT Support
2010-05-26 08:18:34
>We now have a requirement to use an older mobile format of the MS Access
>database in a compacted structure (i.e. with file extension .CDB) which is
>produced by Microsoft ActiveSync version 4.2 and older.
CDB from Pocket Access is another database format.
Re:Re:HXTT Access Driver capabilities
Tim Valentine
2010-05-26 08:28:33
I understand your response to be that "this database format is not supported with our MS Access driver". Is that correct?
Re:Re:Re:HXTT Access Driver capabilities
HXTT Support
2010-06-01 07:21:16
>I understand your response to be that "this database format is not supported with
>our MS Access driver". Is that correct?
Yeah. HXTT Access supports MDB(ACCDB) format from MS Access 95~2007. But Pocket Access is another database with different format. If there're many customers need such a JDBC driver, maybe we will try to crack that format.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap