I have a connection to a DBF file via an ODBC connection. The job is failing with this error:
ODBC call <SQLDriverConnect> for data source <Sanctions> failed: <[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.>.
[/code]
I am using a mapped drive and have read that a UNC path is needed. That being the case, I can’t figure out how to enter a UNC path for a “Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)” driver. Any ideas?
I would expect it to be something like \server\share\dir
When you say you are using a mapped drive, have you performed that mapping within the ETL job. I’ve used mapped drives in the past and I found that to be on the safe side I mapped the drive within the job.
I prefer using UNC mapping instead of mapped drives.
Thanks. I’m referring to the ODBC window that appears in Microsoft Windows. I have a combo box from which I can select a mapped drive. I don’t have the ability to type one in. I was just wondering if others have run into the same issue.
(BOB member since 2007-09-12)