Ok in WinXP, but error in Win10 - Microsoft ODBC dBase Driver (*.DBF) Datasource name not found and no default driver specified

[SevenDP]

Hi Guys

I have maintenance old macro, this macro work in WinXP 32bit & Office 2010
but now user need to upgrade computer into Win10 x64 & Office 365

there are a problem when accessing this code

data_path = Left(ThisWorkbook.Path, 31)

cn_bank.Open "driver={Microsoft dBase Driver (*.dbf)};" & _
    "driverid=277;dbq=" & data_path
   
   rs_bank.Open "select * from GBANKTRN.DBF", cn_bank, , , adCmdText

the error was:

Run-time error -2147467259 (80004005): [Microsoft] [ODBC Driver Manager] Datasource name not found and no default driver specified

debugger got yellow line in this line:

cn_bank.Open "driver={Microsoft dBase Driver (*.dbf)};" & _
    "driverid=277;dbq=" & data_path

this dbf file is compatible with Clipper/Foxplus/Foxbase
the macro code needs to read & modify this dbf file

should i need to install some driver or should I change the code ?
any advice ?

i already checked the reference all references is checked in both windows, but the office 365 got newer version

please help & thanks before

 

[SevenDP]

solved,
change the connection string from

cn_bank.Open "driver={Microsoft dBase Driver (*.dbf)};" & _
    "driverid=277;dbq=" & data_path

to

cn_bank.Open "driver={Microsoft Access dBase Driver (*.dbf, *.ndx, *.mdx)};" & _
    "driverid=277;dbq=" & data_path

thanks guys