KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

SQL Test Failed

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    KS-Soft Forum Index -> HostMonitor
View previous topic :: View next topic  
Author Message
nettocc



Joined: 12 Jun 2003
Posts: 3

PostPosted: Fri Jun 13, 2003 5:37 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
KS-Soft



Joined: 03 Apr 2002
Posts: 12791
Location: USA

PostPosted: Fri Jun 13, 2003 11:56 am    Post subject: Reply with quote

Some error in SQL Query. But nobody will be able to say what's wrong until you provide this query. Could you please provide it?

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
nettocc



Joined: 12 Jun 2003
Posts: 3

PostPosted: Mon Jun 16, 2003 6:19 am    Post subject: Reply with quote

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 table is the fatetyp 'DATETIME'.

thank you verymuch.

reto
Back to top
View user's profile Send private message Send e-mail
Marcus



Joined: 18 Nov 2002
Posts: 367

PostPosted: Mon Jun 16, 2003 9:35 am    Post subject: Reply with quote

Remove the format of the datefield and you should see the correct value.
Back to top
View user's profile Send private message
nettocc



Joined: 12 Jun 2003
Posts: 3

PostPosted: Tue Jun 17, 2003 5:55 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Marcus



Joined: 18 Nov 2002
Posts: 367

PostPosted: Tue Jun 17, 2003 9:32 am    Post subject: Reply with quote

If you use this exact statement:
Insert into hmlog(datetime, testname, status, reply) VALUES (%DATE%,'%TestName%', '%Status%', '%Reply%')

You need to ad the quotes for the %DATE% macro variable.

We use the %datetime% macro.

[ This Message was edited by: Marcus on 2003-06-17 09:37 ]
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    KS-Soft Forum Index -> HostMonitor All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index