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 Driver capabilities
Tim Valentine
2010-05-25 10:44:02.0
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.0
>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.0
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.0
>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
 

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