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
SQL Test Failed
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
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
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.
<font size=-1>[ This Message was edited by: Marcus on 2003-06-17 09:37 ]</font>
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.
<font size=-1>[ This Message was edited by: Marcus on 2003-06-17 09:37 ]</font>