Dean,

You probably have tracing on in your ODBC Data Source Administrator. By default, it is off, largely because tracing can result in massive files, and will negatively impact the performance of your ODBC queries. It should only be used when you are trying to troubleshoot an ODBC problem.

Find the ODBC Control Panel - you can access this via SPSS by clicking on the Add Data Source button in the Database Wizard. Click on the Tracing tab. Depending on your version of Microsoft's Data Access Components, this tab can vary. In the latest version, you'll see a button that toggles between Start Tracing Now and Stop Tracing now. Click on Stop Tracing Now. If you have an earlier version, I think there are a series of radio buttons that lets you choose your tracing mode. Then exit the control panel. If you have SPSS open and have performed a query, you'll probably need to exit out of SPSS. Then, you should be able to delete the sql.log file.

Gail Lucas Technical Account Manager SPSS, Inc.

-----Original Message----- From: Nelson, Dean [mailto:dean.nelson@EMAIL.STVINCENT.EDU] Sent: Friday, April 05, 2002 8:42 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: sql.log

I have a file in my root directory called sql.log. It has been growing ever since I started using GET CAPTURE ODBC. It is now 98 Mbytes and I can't delete it. Does anyone know how to purge this file periodically?

Thanks, Dean