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
Moderator
http://www.SQL-Server-Performance.Com/forum
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.
Moderator
SQL-Server-Performance.com
]]>