Reading sql server, inserting into oracle.

Just as information. Changing the driver from the MS provider to the Oracle provider will not solve the issue. MS refuses to provide a value outside what it thinks is...

Yes, the MS date works just fine. That is the issue. Even though the linked server is Oracle, MS will not use any date range except an MS date range

ISNULL(sold_date,'1/1/1700 12:00:00.000 AM')

Error

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.(22007,242)

provider='MSDAORA'

Oracle 10

I did not even have to finish the artical in the paper to know the contractor respinsable for the code. It is the same contractor that failed to fulfill their...

To get around this issue, I created a template on the server. Create a copy of the spreadsheet without data and place it on the server. I copy a...

I don't want to send SSN to a vendor.