ODBC Log file using MS Access ...

harley · Post by **harley** » Tue Sep 10, 2002 9:08 am

I was successful in creating HM log entries using the following sql statement on an ODBC connection to a "local computer" MS Access Database. (Windows 98 + Access 2000)

Insert into hmlog (testname, status, commentline) VALUES ('%TestName%', '%Status%', '%CommentLine1%')

I then used the following SQL and tried to insert log records into an .mdb MS Access file.

Insert into hmlog (testname, datetime, status, commentline) VALUES ('%TestName%', '%DateTime%', '%Status%', '%CommentLine1%')

This gave an error # of 4294967295 with an error messsage of: [Microsoft][ODBC Microsoft Access Driver]Syntax error in Insert Into Statement

The Access column datetime was defined as a date/time field. I tried with it defined as "text", and "numberic" and got bad results too. I also tried using the %Date% varialbe with no success.

Any suggestions?

Harley

KS-Soft · Post by **KS-Soft** » Tue Sep 10, 2002 9:19 am

'datetime' is reserved word in Access. So, just rename this field, e.g. change name to 'eventtime'

Regards
Alex

harley · Post by **harley** » Tue Sep 10, 2002 10:46 am

That worked ... but... under Windows 98..

I can now start up HM 3.22, and click the refresh button ok, and then simply try to Exit HM, and get a Windows Blue-Screen with an 0E error ..... I'd like Bill Gates to pay me for the time I waste running his buggy OS !

harley · Post by **harley** » Tue Sep 10, 2002 10:50 am

For What its worth .. the Blue screen message contains ... VXD Vwin32(05) 000012D0

And sometimes will let me type a key to kill the HM program .. and other times I have to power off ...

Harley

KS-Soft · Post by **KS-Soft** » Tue Sep 10, 2002 2:02 pm

Did you try to disable ODBC logging? If program stops crashing, it means problem in ODBC driver or in Access.

Regards
Alex