Agreed, I usually create a local view in these instances. I have found it
give me a bit more flexibility and it you don't have to make changes to the
View Form when things change on the remote side; just the View needs
updating.
Try <linkname>*..*<owner>.<table>
Notice there are two dots between the linkname and owner (schema if I
remember my Oracle terminology correctly) name. I don't remember exactly
why this is I just remember to try it when I have issues doing this kind of
work. (maybe because I am skipping one of the parameters {db?})
Jason
On Thu, Feb 2, 2012 at 1:59 PM, Grooms, Frederick W <
[email protected]> wrote:
> I believe it is Case sensitive. All Oracle table and view names are
> uppercase. Try link.db.OWNER.TABLE
>
> You may find it cleaner to create a local database view that does the
> remote query. Then you should not have to worry about the case sensitivity
> from Remedy.
>
> Fred
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList) [mailto:
> [email protected]] On Behalf Of Reiser, John J
> Sent: Thursday, February 02, 2012 3:50 PM
> To: [email protected]
> Subject: Create a View form of a remote oracle DB on ARSystem (MS SQL)
>
> Hello Listers,
> MS SQL 2005 on a SAN
> MS Windows 2003 Enterprise
> AR System 7.6.03 Build 001
>
> Our system connects to a remote Sybase DB via the DB Link for ARS Croom
> Consulting.
> The Sybase DB is being replaced by an Oracle DB.
>
> We only need to read data so I am trying to make the oracle connection
> with a View form.
> The MS SQL dba created a Linked server to the Oracle DB and confirmed the
> connectivity.
> In the View form should I use the MS SQL connection string or an Oracle
> connection string?
>
> <linkname>.<db_name>.<owner>.<table> or <db_name>.<table>@<linkname>
>
> The value that I tried to load was the ORAORQ10.propmgt.propmgt.equipment.
> That gives an ARERR 552 message
> I have also tried propmgt.equipment@ORAORQ10
> That gives ARERR 481 but I'm not sure if the "table not found" is because
> of case sensitivity or just the wrong connection string format.
>
> I've successfully connected to a different linked db but it is a remote MS
> SQL so I use the link.db.owner.table format for that.
>
> Thanks in advance.
> ---
> John J. Reiser
> Remedy Developer/Administrator
> Senior Software Development Analyst
> Lockheed Martin - MS2
> The star that burns twice as bright burns half as long.
> Pay close attention and be illuminated by its brilliance. - paraphrased by
> me
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
