View previous topic :: View next topic |
Author |
Message |
nettocc
Joined: 12 Jun 2003 Posts: 3
|
Posted: Fri Jun 13, 2003 5:37 am Post subject: |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Fri Jun 13, 2003 11:56 am Post subject: |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
nettocc
Joined: 12 Jun 2003 Posts: 3
|
Posted: Mon Jun 16, 2003 6:19 am Post subject: |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
Marcus
![](images/avatars/20881619813f37f6f08373e.gif)
Joined: 18 Nov 2002 Posts: 367
|
Posted: Mon Jun 16, 2003 9:35 am Post subject: |
|
|
Remove the format of the datefield and you should see the correct value. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
nettocc
Joined: 12 Jun 2003 Posts: 3
|
Posted: Tue Jun 17, 2003 5:55 am Post subject: |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
Marcus
![](images/avatars/20881619813f37f6f08373e.gif)
Joined: 18 Nov 2002 Posts: 367
|
Posted: Tue Jun 17, 2003 9:32 am Post subject: |
|
|
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 |
|
![](templates/subSilver/images/spacer.gif) |
|