Wednesday, March 7, 2012

Join tables in SQL 6.5 with SQL 7.0

I have a table in SQL that contains a timestamp column and I'm traying access it from a select statement in SQL 7.0, but I have a problem..., this is the error message:Server:
Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata for a column. Metadata information was changed at execution time.\
but I can access other table in the same server...Consider simply not selecting the timestamp column. (Do not attempt to update or insert values into timestamp columns either.)

Timestamp columns generally do not need to be accessed for typical user purposes. Timestamp columns are system updated each time a row is inserted or updated (in a table object containing a timestamp column)

No comments:

Post a Comment