MSSQL 2000 Linked to Oracle 8 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MSSQL 2000 Linked to Oracle 8

I have linked my sql windows 2000 sp3 server to a vendors read-only
Oracle 8 server (soon to be 9), using OLEDB and MDAC downloaded and installed in dec 2003. The problem I am having is with the Oracle DateTime fields, as some
dates are out of MS Datetime Range. I using openQuery as
a work around with the following code for all date fields GREATEST(anyDateField, TO_DATE(””1753-01-01””,””yyyy-MM-DD””)) "anyDateField". Is there any better solution? Thanks Quentin
What is the level of service pack on SQL and how about the error indication during this process? Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Have you tried Data Transformation Services (DTS)? Nathan H.O.