SQL Test Failed

nettocc · Post by **nettocc** » Fri Jun 13, 2003 5:37 am

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

KS-Soft · Post by **KS-Soft** » Fri Jun 13, 2003 11:56 am

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

nettocc · Post by **nettocc** » Mon Jun 16, 2003 6:19 am

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

Marcus · Post by **Marcus** » Mon Jun 16, 2003 9:35 am

Remove the format of the datefield and you should see the correct value.

nettocc · Post by **nettocc** » Tue Jun 17, 2003 5:55 am

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

Marcus · Post by **Marcus** » Tue Jun 17, 2003 9:32 am

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>