tracker issue : CF-3691289

select a category, or use search below
(searches all categories and all time range)
Title:

Microsoft Access with Unicode driver not available on 64 bit platform

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/ThirdParty

Reporter/Name(from Bugbase): Tom Kostiainen / Tom Kostiainen (devdumper)

Created: 01/10/2014

Components: Database

Versions: 10.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 3

Problem Description:

The Microsoft Access with Unicode database driver is no longer available. The only available driver does not support unicode.

Driver availablility is mentioned in Adobe help http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe6.html

Steps to Reproduce:

1. Install ColdFusion server 64 bit on a 64 bit server.
2. Try adding a data source and selecting "Microsoft Access with Unicode" as driver.

Actual Result:

Driver not available.

Expected Result:

Driver selectable.

Any Workarounds:

Well known issue e.g. http://forums.adobe.com/message/5906504
Not real work around as requires running CF as 32 bit.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3691289

External Customer Info:
External Company:  
External Customer Name: devdumper
External Customer Email:  
External Test Config: See "Language and platforms" info

Attachments:

Comments:

Please provide workaround! Unable to update server platform due to this.
Comment by External U.
13709 | January 10, 2014 01:08:22 AM GMT
Hallucinating that Adobe took out 3 lines of code in the install routines to get rid of all the customers who are using MSAccess with Unicode. By default, this also doesn't work for Coldfusion 10 32bit, but there is an undocumentated workaround by using Coldfusion 32bit given in the Adobe forum link. If the Coldfusion 10 64bit on MSAccess doesn't work, it should at least be fixed in the install routine for Coldfusion 10 32bit.
Comment by External U.
13710 | January 10, 2014 02:30:03 AM GMT
Same problem
Comment by External U.
13711 | January 14, 2014 03:01:57 AM GMT
+1 vote. Bring back the 'Microsoft Access with Unicode' driver for backward compatibility and to cater for languages that have non-ASCII characters.
Vote by External U.
13714 | January 19, 2014 03:46:48 AM GMT
Cannot get Access to work on CF10 (32 or 64 bit) and I understand that this driver would have solved the problem.
Vote by External U.
13715 | April 26, 2014 08:59:19 AM GMT
This should help. http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess
Comment by Himavanth R.
13712 | November 18, 2014 07:40:30 AM GMT
The JDBC driver is not available on 64-bit platform and hence this can't be fixed.
Comment by Rupesh K.
13713 | November 18, 2014 07:43:55 AM GMT
Very annoying, as I'll have to reinstall Coldfusion 9 in order to support an old client system. Not have the Access driver with unicode option means that there's no support for right-to-left languages.
Vote by External U.
13716 | June 30, 2015 07:08:15 AM GMT