There are a couple of options: 1.) Purchase Croom Consultings ARDBC adapter for SQL Server, this is an ARS Application level connection. This requires that ARS run on Windows. 2.) Use the MSSQL ODBC Driver with Oracle Heterogeneous Services / Oracle generic connectivity. This requires that Oracle be on Windows. 3.) If Oracle is on Linux/UNIX, you can purchase the DataDirect SQL Server ODBC driver and use it with Oracle Heterogeneous Services / Oracle generic connectivity. -Brian
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Thursday, November 23, 2006 12:12 AM To: [email protected] Subject: OT: How to access MS SQL tables from Oracle? ** Hello List, Is there any third-party products for accessing MS SQL tables from Oracle database? I would like to create an MS-SQL-based view form within Oracle-based ARS. I know that MS SQL allows to create DB-links for accessing Oracle tables. It is a built-in functionality. Thank you. Kind Regards Dmitry Bezhenar __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
