Log Analyzer and ODBC

mcclelland2007 · Post by **mcclelland2007** » Tue Feb 27, 2007 12:12 pm

Good afternoon,

I am in the process of setting up Log Analyzer (ver. 5.35) with ODBC logs. I am using SQL 2000 as my database. Whenever I click the "test" button in the ODBC Logs Manager, it comes up with an "Ivalid Date" error message for all the records that it has imported. I have the [Date] and [Time] fields set up as data type of "datetime".

Any help would be greately appreciated.

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Feb 27, 2007 12:43 pm

You may use "Use fixed date&time format" option (LogAnalyzer's menu "Options" > "Interface" tab) to define the date & time formats (e.g. DD/MM/YYYY h:mm:ss AMPM).

Regards,
Max

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Feb 27, 2007 1:12 pm

Could you provide the query you have specified into "SQL Query" box of "Options > Primary Log" tab? Could you send file "odbclogs.lst" from the folder, where Log Analyzer is installed to support@ks-soft.net? What exact Date and Time do you see when you select query from the table using Microsoft Query Analyzer? Could you also provide the structure of the table, that is used for logging?

Regards,
Max

mcclelland2007 · Post by **mcclelland2007** » Tue Feb 27, 2007 1:53 pm

Max,

The query that is specified is as follows:

Insert into logs (eventtime, testname, status, reply, testid, testmethod) VALUES ('%DateTime%', '%TestName%', '%Status%', '%Reply%', %TestID%, '%TestMethod%')

I have sent the odbclogs.lst file to support@ks-soft.net.

When I run that same query, I get the following message:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'TestID'.

Please be patient with me as I am not that experienced with SQL, so I might ask for some clarification.

Thank you for your help.

KS-Soft Europe · Post by **KS-Soft Europe** » Tue Feb 27, 2007 2:43 pm

mcclelland2007 wrote:When I run that same query, I get the following message:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'TestID'.

Where do see such error? When you are pressing "Test" button in HostMonitor's menu "Options" > "Primary Log" tab? Could you send me the structure of the 'logs" table? You may use "Script Table As" > "Create To" option of Microsoft's "Query Analyzer" or "Enterprise Manager" to get such information.

Could you perform the following query using "Query Analyzer" or "Enterprise Manager": select top 10 * from logs
Please, send the output back to us.

mcclelland2007 wrote:Please be patient with me as I am not that experienced with SQL, so I might ask for some clarification.

No problem.

Regards,
Max

mcclelland2007 · Post by **mcclelland2007** » Tue Feb 27, 2007 4:41 pm

I have been looking at the configuration of both the ODBC and the Log Analyzer and found the problem. I didn't have the format set up right in the SQL table. It seems to be working now.

I don't think I would have been able to do it without your help, keep up the good work.

:D