RSView SE 4.00 and SQL SERVER 2000

Hello,

I use an ODBC database in RSView SE 4.00 to log factory talk messages and errors to a sql server 2000 database.
But, there is an error in the column "Timestamp" (that log the date and time), i have the good date but not the good time. The time is always 00:00:00 and then dont appear in the column.

- I work on Windows 2003 server SP2.
- I have installed sql server 2000 and the SP4 for SQL server.
- I have installed the patch roll up for RSView
- ...

Can you help me ?

Have you seen this before ?

Thank you for your help.

The Rockwell definition of the 'timestamp' data format and the sql definition for datetime/smalldatetime are different.
There are some tech notes on ABs website about how to get around this.