tracker issue : CF-3492620

(Filing this b/c I don't think I ever actually filed a bug about it)

First, an important note: DataDirect SequeLink runs as a 32-bit process in 64-bit Windows.

Issue: When creating an ODBC data source in 64-bit Windows, CF10 creates 32-bit Windows registry entries. This is why ODBC data sources fail to work in CF10 by default.

Steps to Reproduce:

1) Create an ODBC data source in 64-bit CF10's CF Admin

Actual Result: "Unable to update the NT registry. Variable DRIVERPATH is undefined." is displayed in CF Admin and data source does not work

Expected Result: CF Admin should always create the proper 32-bit registry entries for ODBC data sources, so that the data sources can work.

Temporary Workaround: http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess

Adding an ODBC data source in 64-bit CF10 creates these incorrect registry entries:

- key: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\{Data Source Name here}
- value: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\{Data Source Name here}

However, it should create these correct registry entries:

- key: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\{Data Source Name here}
- value: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources\{Data Source Name here}

To verify, just delete the 64-bit registry entries (after following the steps in that blog article to add the 32-bit registry entries) and see that the ODBC data source still works.

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

Watson Bug ID:	3492620

External Customer Info:
External Company:  
External Customer Name: itisdesign
External Customer Email:

Attachments:

Comments: