[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface] Out of Disk space writing temporary sort file. The tempfileDirectory = variable in odbc.ini can be used to specify different drive/directories". (#0)
After a little investigation I discovered that a query had gone awry, the user had rebooted and this left a 1 gig dead swap file on the boot drive of my app server in the Winnt directory. I looked at the Pervasive Console and could not find anywhere to set the swap file directory to a different drive.
Does anyone know anything about how to set this ? Does the ODBC.ini file on the server actually control this?