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: [email protected] 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 <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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
