I have started experiencing some problems with using mydatamart. When I reach to the excel and I import one year data I get an error message (error 7) and when I click ok it also tells me problem obtaining data.
Thanks
···
Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare
Republic of Liberia
+231-886-847-915
skype: mambu9the data
Can you share some information form the log (press F2 in mydatamart).
What is this error 7 - an excel error? Perhaps also can you provide a
sample of an offending xlsx file.
Regards
Bob
···
On 21 September 2012 11:06, Stephen Gbanyan <mambu9@gmail.com> wrote:
Hi All,
I have started experiencing some problems with using mydatamart. When I
reach to the excel and I import one year data I get an error message (error
7) and when I click ok it also tells me problem obtaining data.
Thanks
__________________________________
Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare
Republic of Liberia
+231-886-847-915
skype: mambu9the data
I have also obtained the same error during training,but depends on how many bit your Operating system has you can install sqliteodbc_win_32bit.exe or sqliteodbc_win_64bit.exe.for me i installed sqliteodbc_win_32bit.exe cause my operating System has 32bit and the problem resolved.in exel.
— En date de : Ven 21.9.12, Stephen Gbanyan mambu9@gmail.com a écrit :
I have started experiencing some problems with using mydatamart. When I reach to the excel and I import one year data I get an error message (error 7) and when I click ok it also tells me problem obtaining data.
Thanks
Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare
Republic of Liberia
+231-886-847-915
skype: mambu9the data
Ah! That does explain it - thanks Venuste (see you next week … ).
The database connection strings which are embedded in the excel files make use of the 32 bit driver. So as Venuste says, install that (regardless of your operating system), not the 64 bit one.
We could make mydatamart a bit smarter in terms of checking to see which odbc drives are installed or not before producing the excel file, but in the meantime stick to the 32 bit driver.
Bob
···
On 21 September 2012 11:32, nsanzumuhire venuste vensanze@yahoo.fr wrote:
Hi?
I have also obtained the same error during training,but depends on how many bit your Operating system has you can install sqliteodbc_win_32bit.exe or sqliteodbc_win_64bit.exe.for me i installed sqliteodbc_win_32bit.exe cause my operating System has 32bit and the problem resolved.in exel.
— En date de : Ven 21.9.12, Stephen Gbanyan mambu9@gmail.com a écrit :
I have started experiencing some problems with using mydatamart. When I reach to the excel and I import one year data I get an error message (error 7) and when I click ok it also tells me problem obtaining data.
Thanks
Stephen M. Gbanyan, Jr.
Assistant Director
Health Management Information System
Ministry of Health and Social Welfare
Republic of Liberia
+231-886-847-915
skype: mambu9the data