Patrick,
I did what you suggested and I was am able to run any select statement from
the link and get valid returns.
But, when I try to create the View form in ARS I am getting the ORA-00904
Invalid Identifier on the key field.
I have verified that the Key field on the SQL table is set up
Gary,
Croom Consulting's Link to External Databases can do what you are looking at
and
with significant less headache.
Contact me off list if you would like to arrange an evaluation.
Regards...Gidd
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED]
Gary,
The short answer is yes a view of a view can be modified. There are a
couple caviates here.
One. The request ID field in remedy. I suspect from your error message that
you have the address1 column matched to column 1 on the view form. even
with view forms, Remedy needs a unique
Gary,
I understand the budget crunch !! Solution cost is $4999.00 + support
Here is a link for more detailed information.
http://www.buoyantsolutions.net/External_DB.html
BTW: There are many on the ARS List that use this solution and swear by it
...
not at it !!
HTH
Regards...Gidd
What I've had to do in the past in a similar situation is to have the
view form referencing a view on my DB that was using a linked server.
If you get that part, you can at least see the data.
However, if you have issues modifying or submitting the data,
unfortunately the next best solution is
Brian,
I saw this also and sent it to my DBA, he found it interesting also. The
only quick explanation we could come up with is that something is happening
to the Column Name in translation via the DBLink. Now this has one flaw,
and that is the fact that the field that do not error have very
You know, I am wonderingSometimes I have seen Oracle return the wrong
piece of code for the error. Is there any field on the list that might be a
reserved word for Oracle? Were you going with just the error, or did you
turn on server sql logging and capture the sql code that Remedy was
Just create a view on the db side, create a dblink, then create a synomn on
the ars side.
Test link.. select * from synonm... ( I know I cannot spell .. ;-)
then create a view form.. watch out of Date fields.. and use an escalation
or a filter to write back..
voila .. works great.. been doing
do you have encryption turned on between the links ?
this could be your issue as well. I have seen a required on one side and a
requested on the other.. cause issues..
On 4/2/08, patrick zandi [EMAIL PROTECTED] wrote:
Just create a view on the db side, create a dblink, then create a synomn
9 matches
Mail list logo