View previous topic :: View next topic |
Author |
Message |
harley
Joined: 31 Jul 2002 Posts: 12 Location: Harley Goodwin
|
Posted: Tue Sep 10, 2002 9:08 am Post subject: |
|
|
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
|
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12806 Location: USA
|
Posted: Tue Sep 10, 2002 9:19 am Post subject: |
|
|
'datetime' is reserved word in Access. So, just rename this field, e.g. change name to 'eventtime'
Regards
Alex |
|
Back to top |
|
|
harley
Joined: 31 Jul 2002 Posts: 12 Location: Harley Goodwin
|
Posted: Tue Sep 10, 2002 10:46 am Post subject: |
|
|
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 ! |
|
Back to top |
|
|
harley
Joined: 31 Jul 2002 Posts: 12 Location: Harley Goodwin
|
Posted: Tue Sep 10, 2002 10:50 am Post subject: |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12806 Location: USA
|
Posted: Tue Sep 10, 2002 2:02 pm Post subject: |
|
|
Did you try to disable ODBC logging? If program stops crashing, it means problem in ODBC driver or in Access.
Regards
Alex |
|
Back to top |
|
|
|