I am trying to access LogParser 2.2 through the COM
interface provided and I am having a bit of a problem. Here is what is going
on: First up is the _vbscript_ version of the code then comes the Python version.
Set objLogParser = CreateObject("MSUtil.LogQuery")
Set objInputFormat =
_
CreateObject("MSUtil.LogQuery.FileSystemInputFormat")
objInputFormat.recurse = 0
Set objOutputFormat = _
CreateObject("MSUtil.LogQuery.NativeOutputFormat")
objOutputFormat.rtp = -1
strQuery = "SELECT Name, Size FROM 'C:\Program Files\Log Parser 2.2\*.*'
ORDER BY Name ASC"
objLogParser.ExecuteBatch strQuery, objInputFormat, objOutputFormat
When I installed Log Parsers 2.2 on WinXP home edition SP1 version 2002
it went in c:\Program Files\Log Parser 2.2 and then I ran regsvr32
LogParser.dll from that directory. The error I get is :
Error executing query:Error while writing to file: The handle is
invalid.
NOW!! This occurs when I run the script from the command line just by typing
the script name and letting XP load cscript. However if I type:
cscript test.vbs from the command line it runs ok. Now what I am trying to do
is program this interface from ActiveState python 2.3 with win32com extentions.
Everything works fine but when I run the script I get the same error I get when
I type 'test.vbs' at the command line. Python is my main language and I would
really like to make it work. It seems like there is some condition of having
the script directly called from 'cscript' for the COM interface to work. Does
anyone know the workings of the COM interface. I understand the API, but how
are the calls being made. Here is the python code for the same example:
>>> import win32com.client
>>> objLogParser =
win32com.client.Dispatch("MSUtil.LogQuery")
>>> objOutput =
win32com.client.Dispatch("MSUtil.LogQuery.NativeOutputFormat")
>>> objOutput.rtp = -1
>>> objInput = win32com.client.Dispatch("MSUtil.LogQuery.FileSystemInputFormat")
>>> objInput.recurse = 0
>>> myquery = "SELECT Name, Size FROM 'C:/lame/misc/*.*' ORDER BY
Name ASC"
>>> objLogParser.ExecuteBatch(myquery, objInput, objOutput)
Traceback (most recent call last):
File "", line 1, in ?
File
"C:\Python23\Lib\site-packages\win32com\gen_py\A7E75D86-41CD-4B6E-B4BD-CC2ED34B3FB0x0x1x0.py",
line 819, in ExecuteBatch
return self._oleobj_.InvokeTypes(2, LCID, 1, (11, 0), ((8, 1), (13, 49), (13,
49)),szQuery, pObjectInputContext, pObjectOutputContext)
com_error: (-2147352567, 'Exception occurred.', (0, 'CLogQueryClass', 'Error
executing query: Error while writing to file: The handle is invalid. [The
handle is invalid.]', None, 0, -2147024890), None)
Any ideas would be appreciated. I can run the select command at the
command line using LogParser.exe and all is well but not with COM.
Thank you,
Ronnie Jones
