Skip to main content
A
Anonymous
April 5, 2010
Question

HXTT JDBC driver for MDB access on 64-bit CF9

  • April 5, 2010
  • 3 replies
  • 2738 views

Does anyone have the HXTT driver installed on Coldfusion 9 64-bit?

I still need MS access as we use it to export as a feed to our partners.

This topic has been closed for replies.

3 replies

J
jchahine
Participating Frequently
October 17, 2011

I did not get a key, instead I just got another .jar file from HXTT

Eval was Access_JDBC30.jar

Full was Access_JDBC40.jar

i copied it over to \WEB-INF\classes\ directory

then reconfigured the class path in "Java and JVM" section of CF Administrator. It works. 

- Joe Chahine

-
-__cfSearching__-
Inspiring
October 17, 2011

i copied it over to \WEB-INF\classes\ directory

Just FYI, jars should be placed in the \WEB-INF\lib\ directory (not "classes").  \WEB-INF\classes\ is for individual .class files.  Jars in \WEB-INF\lib\ should be picked up automatically. No fiddling with the class path necessary. Just restart CF.

Message was edited by: -==cfSearching==-

Message was edited by: -==cfSearching==-

J
jchahine
Participating Frequently
October 17, 2011

Interesting. 

I followed instructions from HXTT but it's good to know this info for future JAR installs.

J
jchahine
Participating Frequently
August 12, 2011

Thanks for the info and updates -- it's good to know the drivers work. 

I'm about to install the Eval copy now.  Was it just a matter of

entering a key when you wanted to convert to full license?

Joe Chahine

Operations / Developer - IT Division

Blue Cross Blue Shield of Michigan (BCBSM)

A
Anonymous
August 12, 2011

Yes

J
jchahine
Participating Frequently
August 16, 2011

Thanks.  I have the EVAL working.  Had to re-create the CF DSNs as "other" per HXTT's instructions.

Just waiting to get the license key - I have to go thru a corporate purchasing process to get it.  Except the EVAL is v3 and when I make my purchase it will be for v5.  (there was no v5 Eval).  So I guess I'll have to copy over a new .jar file for v5

I'll follow up when all that happens.

- Joe Chahine

A
Anonymous
April 21, 2010

4/21/10

The new Windows 2008 R2 server came in yesterday.  I installed CF9 and downloaded the HXTT JDBC driver.  It does seem to work but the evaluation version of the driver is limited to 1000 records.  So I am not sure if the performance is going to be ok. 

Do I risk the $370 to get a full working version.  Will my boss think I am nuts for buying software from a company in China?

4/28/10 - The boss says do it.

5/1/10

Results look good.  Everything seems to work.  Performance might even be better than the jet 32 bit drivers.

5/10/10 - First issue found

The MS Access "Make Table Query" that uses non-standard syntax   SELECT * INTO Target FROM Source   does not work in the HXTT driver.  This syntax worked with both Access Jet and CF8 32 bit drivers.  So it looks like I will be forced to make some code changes.  INSERT INTO Target SELECT * FROM SourceTable   looks like the best bet.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices