Search found 3 matches

by nettocc
Tue Jun 17, 2003 5:55 am
Forum: HostMonitor
Topic: SQL Test Failed
Replies: 5
Views: 50995

Sorry, that doesn't works.

under miscellaneous i have disabled the box "use fixed Date&Time formats", but the date is still 1.1.1900.
The datetyp in the sql-table is "datetime" with 8 chars.

regards
reto
by nettocc
Mon Jun 16, 2003 6:19 am
Forum: HostMonitor
Topic: SQL Test Failed
Replies: 5
Views: 50995

hi the sql query test works now. but in the filed 'date' he allwys shows the date of 1.1.1900. However, here ist the query Insert into hmlog(datetime, testname, status, reply) VALUES (%DATE%,'%TestName%', '%Status%', '%Reply%') in the table the field 'date' has the format: MM/dd/yyyy and in the tabl...
by nettocc
Fri Jun 13, 2003 5:37 am
Forum: HostMonitor
Topic: SQL Test Failed
Replies: 5
Views: 50995

when i try to test my odbc connection, a error appears:
return code:4294967295
[microsoft][odbc sql server driver][sql server]line 1:bad syntax nearby of '.2003'.

has onyone a idea?
thx

Reto