Connection error when creating linked service to on-premise ODBC MS Access DBF with Azure Data Factory V2

Question

Hi,

I have an application folder containing DBF dBASE files in it and I'm trying to use a local runtime instance of ADF and connect using ODBC.

When testing from Excel, it's working fine with this connection string
Driver={Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)}; dsn=Avt; DBQ=C:\Users\benoit\Desktop\Test\

The result in Excel:

When trying this exact connection string in ADF. I'm getting this error:
ERROR [HY024] [Microsoft][ODBC dBASE Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

I suspect the error is around the DBQ parameter because when I remove it, I'm getting not getting any errors. However, I'm not getting a list of tables from the associated Dataset as the location is not specified.

I tried using \ instead of single \ for the path but it's giving the same error.

Any clues?

Best,
Benoit

Answer 1

Hello @BenoitG ,

Welcome to the MS Q&A platform.

It seems like your connection string is wrong. Your not passing the db name in your connection string.

Can you please use the below format on your connection string? I was able to connect using the below format.

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\access\Nutritiondb.accdb;

If you still have issues, please use the network path on the Dbq name

Ex:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=\DESKTOP-name\access\Nutritiondb.accdb;