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 - #Error fields in database
David Teller
2008-02-14 10:55:34
I'm trying out your driver as a speed improvement to an existing project where I'm using the jdbc-odbc bridge to connect to Access.

I'm basically copying a bunch of data from SQL server into Access.

When I use your driver and bulk insert from a jdbc recordset:

// Record set from sql server
rsSQL = stmtSQL.executeQuery(t.selectSQL);
// Prepared statement from HXTT driver
stmtAccess = aConn.prepareStatement("INSERT INTO mytable ( columns...) ?;");
stmtAccess.setObject(1, rsSQL);
int result = stmtAccess.executeUpdate();

Some of the fields in Access show up as "#Error" and clicking on them tells me that the database can't be opened.
It seems to happen with memo/longvarchar fields.
And not every record is affected.

Thanks

Dave Teller
Re:HXTT Access Driver - #Error fields in database
HXTT Support
2008-02-15 01:19:33
Another user reported also "Error" in Access 2007 using Vista and Windows Server 2003, while is normal in Access 2003 in Windows XP SP2. May be this is result of latest updates from Microsoft. What's your MS Access version?
Re:Re:HXTT Access Driver - #Error fields in database
David Teller
2008-02-15 05:51:53
I am using an Access 2000 format database.
Re:Re:Re:HXTT Access Driver - #Error fields in database
HXTT Support
2008-02-15 16:38:54
Yeah. Are you using that database in MS Access 2000? You can remove those irrelative table and sensitive data, then zap and email us that file so that we can see where's your issue.
Re:Re:Re:HXTT Access Driver - #Error fields in database
HXTT Support
2008-02-15 16:39:18
BTW, please remember to backup your database.
Re:Re:Re:Re:Re:HXTT Access Driver - #Error fields in database
David Teller
2008-02-19 09:47:10
I've mailed a zipped access database file to your support address since there is no way to attach it here.

Thanks

Dave Teller


Re:Re:Re:Re:Re:Re:HXTT Access Driver - #Error fields in database
David Teller
2008-02-19 10:09:23
Sorry, your mail server wouldn't accept my attachment because it is too large.
If I compact the access database the error is lost.
Is there any way I can upload it via ftp?
Re:Re:Re:Re:Re:Re:Re:HXTT Access Driver - #Error fields in database
HXTT Support
2008-02-21 06:39:32
You can zip and upload your sample into:
ftp site: ftp.hxtt.com
ftp user: anonymous@hxtt.com
ftp password: (empty)
login mode: normal (not anonymous)
ftp port:21
upload directory: incoming
transer mode: binary (not ASCII)
After upload, you can't see that upload file, but it has been upload.

You can try webmaster.hxtt@gmail.com too.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Driver - #Error fields in database
David Teller
2008-02-21 13:27:55
I have some additional information on this.
Apparently, Access does not like fields with inline data more than 64 bytes (32 characters) long and writing a field like that produces the symptom.

I'll try to put together a fairly simple test case.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Driver - #Error fields in database
HXTT Support
2008-02-21 19:04:36
Yeah. But that issue exists only for MS Access 2007 using Vista and Windows Server 2003, and have been supported since Junly, 2007. Maybe you're using an older package, and you can download that latest package, and run "update yourtable set thatvarcharcolumn=thatvarcharcolumn+'' to see whether your issue disappear.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Driver - #Error fields in database
HXTT Support
2008-03-01 07:24:01
Thanks for your patience. Supported. We will release a latest package in about 48 hours. Then you can run once update contact set yourvarcharcolumn=yourvarcharcolumn+''; with HXTT Access to disappear all Data Error messages.

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