NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2013-01-22T10:25:08Z by SystemAdmin
Pinned topic Unable to Open Connection to Database
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I am trying to load data from Excel sheet by ODBC,I have selected the excel sheet and defined the name in the name manager,and created the ODBC Connection,but when i am selecting the defined ODBC connection and the name defined in the name manager it is giving me error "Unable to Open Connection to Database".How to resolve this ,please help.Thanks
Updated on 2013-01-22T10:25:08Z at 2013-01-22T10:25:08Z by SystemAdmin
Re: Unable to Open Connection to Database2013-01-21T21:16:31Z in response to SystemAdminHi barrysab,
Most likely, this will be because of a 32 bit / 64 bit issue i.e. you have configured a 32 bit ODBC connection whereas TM1 is expecting a 64 bit connection.
Check that your Excel ODBC drivers are 64 bit, a search of the Microsoft support site can help with this.
Hope this helps.