Hi,

We're trying to select data from tables residing in an Oracle9i rel.2
database (9.2.0.5) through linked servers in SQL Server 2k. When we
select data that are defined as DATE variables in Oracle we get this
message:

Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Any ideas how to overcome this problem?

Morten Grimnes :-)


**********************************************************************
This footnote confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
Questions can be forwarded to [Email address protected]
**********************************************************************


MS Sql Server LazyDBA home page