|Date: ||Fri, 5 Apr 2002 10:24:43 -0600|
|Reply-To: ||"Lucas, Gail" <firstname.lastname@example.org>|
|Sender: ||"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>|
|From: ||"Lucas, Gail" <email@example.com>|
|Subject: ||Re: sql.log|
|Content-Type: ||text/plain; charset="iso-8859-1"|
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.
Technical Account Manager
From: Nelson, Dean [mailto:dean.nelson@EMAIL.STVINCENT.EDU]
Sent: Friday, April 05, 2002 8:42 AM
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?