February 23, 2004 at 6:52 am
Background
We are currently implementing a New Planning system where the Data is stored in Oracle but the Web Interface is Via a SQL Server on the DMZ.
We have added triggers to the Oracle database to populate tables on the Oracle Server with all changes (Inserts, Updates and Deletion) to the Data.
These Tables are then Imported VIA DTS into SQL Server
The Table Has 3 DateTime cols (DATE_ADDED - UNIQUE ORACLE TIMESTAMP, UPDATE_START, UPDATE_END)
The UPDATE_START col is up filled with the current DateTime on the start of the Update run. The UPDATE_END is filled upon successful update of the column.
PROBLEM
How do I update the columns in the oracle DB with the Modified Data.... from within the DTS Package
-------------------------------------------------------------------------
UPDATE
I am going to try using a linked server...
What are the Implications of loading the Oracle Client On the Server??
will the 9x client work with the 8.1.7 Server ????
as we do not have the 8.1.7 client
Thanks in Advance
ANDOI
February 24, 2004 at 11:59 am
Sorry Andoi, I don't know the answer to this one but would like to. The only way I can get an e-mail when members reply to this post, is by posting a reply. So....
February 24, 2004 at 12:25 pm
Andoi,
I can answer part of your question. The 9i client will work okay on the server. The caveat is that you must apply the Oracle client patches to it AND you probably want to make sure that you install the ORACLE OBDC & OLE DB drivers. The MS OLE DB driver for Oracle doesn't always work as well as you might want it to perform. Your milage may vary depending on what you expect to do.
Cheers,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply