« Previous Next »

• 01-22-2007, 8:52 AM

  Scripted COM Input Reply Contact I registered the QBF.wsc and executed the command line logparser "SELECT * FROM ." -i:COM -iprogid:MSUtil.LogQuery.Sample.QFE  and it worked. I wanted to 'script' the .wsc and so set up cSQL = 'SELECT * FROM .' oLog = CreateObject("MSUtil.LogQuery") oInput = CreateObject("MSUtil.LogQuery.Sample.QFE") oOut = CreateObject("MSUtil.LogQuery.XMLOutputFormat") oLog.ExecuteBatch cSQL, oInput, oOut but get this error which I do not inderstand. Stan

  Tags: COM input format

• 01-22-2007, 10:04 AM

  In reply to

  	RE: Scripted COM Input Mark as Not AnswerMark as Answer... Reply Contact Oh, BTW if I simply script oRS = oLog.Execute cSQL, oInput I can query the recordset object using  GetColumnCount(), GetColumnName() and toNativeString( "," ) to concatenate a .csv file... but the question remains, why doesn't it accept an output format? Stan
  	Tags: COM input format

• 01-22-2007, 1:33 PM

  In reply to

  	RE: Scripted COM Input Mark as Not AnswerMark as Answer... Reply Contact You don't have an INTO clause specified in your query, so I imagine the output format is trying to get a handle to STDOUT and failing. Try changing your query to "SELECT * INTO foo.xml FROM ." and then see if your ExecuteBatch works.
  	Tags: COM input format

• 01-22-2007, 3:37 PM

  In reply to

  RE: Scripted COM Input Mark as Not AnswerMark as Answer... Reply Contact LogParser User : StanL: Quote: You don't have an INTO clause specified in your query, so I imagine the output format is trying to get a handle to STDOUT and failing. Try changing your query to "SELECT * INTO foo.xml FROM ." and th... My bad, I tried SELECT * FROM . INTO and got an error. Just had my SQL parms out of place. Thank You.  Stan

  Tags: COM input format