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:31ZThis is the accepted answer. This is the accepted answer.Hi 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.