FW_OpenAdoExcelSheet with error ADO ERROR - Solved

FW_OpenAdoExcelSheet with error ADO ERROR - Solved

Postby Maurizio » Wed Jun 30, 2021 9:34 am

Hello

I use FW_OpenAdoExcelSheet and on some PC (with same version of Office) I have this error

ADO ERROR UNKNOWN

what can cause this error ?

FW February 2021

Maurizio
Last edited by Maurizio on Wed Jun 30, 2021 3:30 pm, edited 1 time in total.
User avatar
Maurizio
 
Posts: 823
Joined: Mon Oct 10, 2005 1:29 pm

Re: FW_OpenAdoExcelSheet with error ADO ERROR

Postby nageswaragunupudi » Wed Jun 30, 2021 2:34 pm

Please make sure Microsoft.ACE.OLEDB provider is downloaded and installed on the PC.
Also, make sure you provide that the excel file name is given with full path and really exists before you call the function.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10619
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: FW_OpenAdoExcelSheet with error ADO ERROR - Solve

Postby Maurizio » Wed Jun 30, 2021 3:30 pm

Grazie RAO

I had to install Microsoft.ACE.OLEDB 32 bit, on some pc there was 64bit

https://datasavvy.me/2017/07/20/install ... rocessing/

Maurizio
User avatar
Maurizio
 
Posts: 823
Joined: Mon Oct 10, 2005 1:29 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 49 guests