Hi, I am using a thin three-tier client configuration and have set the client to trace all SQL statements to file, but I cant seem to find the log anywhere. I have looked in both the log directory on the client machine (which is totally empty) and also in the log directory under the specified system directory (this contains a number of AOC files and a few trace files, but not the sqltrace log). Where does the file get created? And does it make a difference that I have left the Query time limit blank (I want to trace ALL executed statements)? Thanks, Matt
Check also the log direcotory of the AOS, because with 3-tier setup the AOS generates the SQL statements.
Thanks, that was the problem. I had enabled logging on the client, but did not realize I had to enable it on the server as well. Matt