To change the date format, the following statement should set it to yyyy/mm/dd:
SET DATEFORMAT ymd
That made a difference -- actually, this was a learning experience with regard to the differences in the two SQL dialects. I was able to get the correct CREATE TABLE syntax the old fashioned way -- I cheated. I created the table in Enterprise manager, then had it create a script, which I cut and pasted into the program source. :)
Anyway, I've successfully got it talking to a MS-Sql server, and it appears to be working OK. I'm gonna let it run all nite to make sure it does the things it's supposed to (and nothing that it's not), but confidence is high.
-- --------------------------------------------------------------------- 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/
