Sorry, I didn't post our environment description. Oracle 9.2i on a Solaris 9 platform - ARS (v6.3) is also on this server. MS SQL 2000 on a Win2003 server. What do you think about Remedy Link for SQL Server? Brian, from your post it seems to me that only the third option is suitable for us. Thank you for your answers. Kind Regards / C ????????? Dmitry Bezhenar
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luke, Brian Sent: Friday, November 24, 2006 7:55 AM To: [email protected] Subject: Re: How to access MS SQL tables from Oracle? ** 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___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
