Knowledgebase: EC Enterprise - v6
EC Enterprise: Datasource list is empty in Windows 7
Posted by Ryan Ohlson, Last modified by Joel Brickell on 27 June 2012 02:48 PM
Problem:  In Windows 7 (64bit) it is possible that you've created System DSN ODBC connections but they are not listed in the Datasource drop-down in the EnergyCAP login screen.

Solution:  Since your Windows 7 machine is 64-bit based, by default the ODBC administrator that's linked through the start menu is the older 32-bit version that doesn't play entirely well with the 64-bit registry. Instead, you have to run a modified version of the 32-bit ODBC Administrator from another folder. Why Microsoft did this since the system knows it's a 64-bit system is beyond our comprehension! So, to correct the problem, please LOGIN AS A SYSTEM ADMINISTRATOR and follow these steps:

Using Windows Explorer, go to the folder: %systemroot%\Windows\SysWoW64

Which likely translates to: c:\Windows\SysWoW64.

Run the application: odbcad32.exe

Re-setup your System DSN ODBC Datasource and all should be OK.

Written 4/16/2010 by Ryan Ohlson with information from Ryan Booz
(201 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: