One other thing - it wants dates surrounded by single quotes: eg: '2003/11/14' (assuming you've executed the statement SET DATEFORMAT ymd)
Don -----Original Message----- From: Bud Durland [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 10:38 AM To: [EMAIL PROTECTED] Subject: Re: [IMail Forum] Log Archiver almost ready Bud Durland wrote: > Pat Hastings wrote: > >> Be interesting to see if I can get it working with MS-SQL. > > > With some luck, I'll be testing it with MSSql 2000 today. Preliminary, "I've only got 20 minutes to play with this" testing reveals that MS-Sql compatibility may take longer than expected. Two problems, one small, one large: The program will attempt to create the table it needs if it's not found; I'm still attempting to figure out the CREATE TABLE syntax for MS-Sql. Not a big deal, since most admins can like create the table manually with a minimum of fuss, but it brought to light a couple other issues. MySQL has a DATE and TIME as distinct field types, MS-SQL seems to only have DATETIME. I also didn't see where I could create and auto-increment integer field in MS-SQL, but there is a GUID field. Again, these observations are limited by the amount of time I had to research it. The biggest problem though, is something I remember running into before. MS-SQL seems to expect date values in a completely different format than MySql. MqSQL always handles dates as 'YYYY-MM-DD' (Sybase is the same way). I seem to recall that MS-SQL always wants dates as 'MM/DD/YYYY' or perhaps #MM/DD/YYYY#. I don't recall for sure, and will have to experiment with it. -- --------------------------------------------------------------------- Bud Durland, CNE Mold-Rite Plastics Network Administrator http://www.mrpcap.com --------------------------------------------------------------------- --- [This E-mail scanned for viruses by Declude Virus / Sophos AV] To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ --- [This E-mail scanned for viruses by Declude Virus] To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
