Re: ODBC Trace not creating log file

Never mind. It started working (and the log file includes the results of both excel imports). Weird. -- 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" "William Fields" <Bill_Fields@azb.uscourts.gov> wrote in message news:bupmlu$f8e$1@apollo.nyed.circ2.dcn... > 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" > > > >