Re: How to access MS SQL tables from Oracle? - SOLVED
Thank you, Carey. Now it works. Additionaly I had to substitute * with column names in quotes. Otherwise only "select * from" worked with the view. Kind Regards / C уважением Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, November 27, 2006 5:49 PM To: arslist@ARSLIST.ORG Subject: Re: How to access MS SQL tables from Oracle? - SOLVED Dmitry, You could try creating a local view object in the ARS DB. Have the view do all of the "fancy DB LINK stuff". This way ARS only sees a simple table and does not have to do anything special to select/update the "linked table". -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 11/27/06, Bezhenar, Dmitry <[EMAIL PROTECTED]> wrote: > ** > > 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 .; > > 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: How to access MS SQL tables from Oracle? - SOLVED
Dmitry, You could try creating a local view object in the ARS DB. Have the view do all of the "fancy DB LINK stuff". This way ARS only sees a simple table and does not have to do anything special to select/update the "linked table". -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 11/27/06, Bezhenar, Dmitry <[EMAIL PROTECTED]> wrote: ** 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 .; 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
Re: How to access MS SQL tables from Oracle? - SOLVED
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 .; 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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"