There are JDBC drivers available for a few $'s that provide you external cross database connectivity. You would need to buy one that provides support for connectivity between Oracle and MS-SQL..
Other than this Gidd has a plugin which I think might work for you.. but you would need to contact him or his company for it. Gidd's product is specifically designed for the ARS and might eliminate the need for you to define your database links etc when you use a JDBC driver to connect to the external database. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of John Kovalcik Sent: Wednesday, April 11, 2007 8:26 AM To: arslist@ARSLIST.ORG Subject: External MS SQL Data/SMS Listers, What is the easiest way to access SMS data that resides in an external MS SQL database ? All I want to do is read the data. Our current environment is ARS 6.3 and Oracle 10g. Thanks, John M. Kovalcik Kennametal Inc. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.2.0/756 - Release Date: 4/10/2007 10:44 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"