Hi List, I've created a link from Oracle on Solaris to MS SQL database using one additional Oracle-on-Windows server (with tg4msql installed). Now I can make SQL requests to MS SQL database from sqlplus - for example, select * from <Tablename>.<DBlink-name>; Now I need to create a view form in Remedy Administrator. There is a statement in Basic manual that I should use the following format for the table name - [EMAIL PROTECTED]
Whatever I try to input here the following error occurs - Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). Should I do anything else with a DBLink? Thank you. 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"
