ODBC Trace not creating log file
Posted in 2004
Hi Everyone, I'm using "MDAC 2.7 SP1 ON WINDOWS XP SP1" according to the component checker found at http://support.microsoft.com/default.aspx?scid=kb;[LN];307255 When I start an ODBC Trace from the ODBC Data Source Administrator, no log file is ever created. I've done two tests, one with a DSN using the Visual FoxPro ODBC driver (pointing to VFP tables on our Netware server), and one with the IBM INFORMIX 3.82 32 BIT driver (pointing to tables on a Unix box). I've downloaded tables with both DSN's to an excel spreadsheet, but no log file is created. I saw other posts on Google noting that the logfile is not always created where the path indicates, so I did a filesearch and there is no logfile on any of my drives. I've also checked the HKEY_LOCAL_MACHINE\\Software\\ODBC\\ODBC.ini\\ODBC registry key and the values look right (Trace = 1 (when supposedly tracing, 0 when not), TraceDll = c:\\windows\\system32\\odbctrac.dll, TraceFile = c:\\odbc.log). Any suggestions? -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ quote of the day - "It's not cynicism if you're right"