Easysoft ODBC-Access Driver

Why do I get error "[Easysoft ODBC]General error: Unable to open working file for LONGVARCHAR field"?

Article:
01016
Last Reviewed:
26th January 2024
Revision:
1

This error indicates that the Easysoft ODBC-Access Driver was unable to create a temporary working file in the current working directory of the process using the ODBC driver (the default location). This will often occur when using the driver with a daemon process such as Apache. The solution to this is to provide the driver with a location where it is able to create working files. A directory should be chosen that has sufficient free space, and also has create privileges assigned to the user the driver will be run as.

To set the working directory, add the following lines to the ODBC-Access Driver DSN in the odbc.ini file:

work_dir_path=/tmp
blob_path=/tmp

where /tmp in this example is the location chosen for the working files.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)