Freeware Custom LogParser Input - OLEDB (e.g. query Excel, Access, MS...
Re: Freeware Custom LogParser Input - OLEDB (e.g. query Excel, Access...
Sep 05, 2008 08:03 AM|gluegood|LINK
Seems like a limitation within the iQuery e.g.
LogParser.exe -i:COM "select * From 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb;'" -iProgId:Gluegood.LogParser.OLEDB -iCOMParams:iQuery="SELECT [EmployeeId],[LastName]
FROM [Employees]" -o:DataGrid
Doesn't seem to work. Putting in
[EmployeeId]\,[LastName] (LogParser thinks an additional parameter) or
[EmployeeId] \u002C [LastName] (Query isn't recognised) doesn't seem to work either.
Think I'll have to make an enhancement to the component to support replacing Unicode character (e.g. \U002C) so you
can put in commas. I'll get a compile out shortly.