Re: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

Gary, Have you had any luck getting your connection? I was able to make a view of the Linked Oracle Table in MS SQL Management Studio but I had to CAST each column to int or char before the Dev Studio could load the view. I then went back into the MS SQL Manager and queried the remote DB from

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

Hi Gary, Jean-Louis is correct. If my memory serves me well, I have also had to do it like that in the past. Unfortunately, if you want to do this on DB level, the only other alternative in this case, would be to duplicate the data using, for example, a stored procedure, but that is not ideal

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

Hi Gary, How do you do the db-link, are you using linked servers going from SQL to the remote oracle table? Regards Francois -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: 07 March 2012 10:33 AM To:

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

Also make sure all your pre-requisites are met. If I recall right, if there is no character field that is between 5 to 15 characters in length, that is uniquely identifiable, the creation of a view form fails.. Joe -Original Message- From: Francois Seegers Sent: Wednesday, March 07,

Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

John, Have you checked the SQL log when doing the search (Open the Form in the User Tool, Turn on the SQL log, Try the search, Turn off the log) and you can then see exactly what SQL the system is trying to run. It may have something to do with the CAST and if you have the fields set for

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

Thanks for the insight, this is definitely an option. The main concern with this solution is that I am not the SQL DBA and do not have and admin access to the DB or application servers, so I am now dependant on 3 parties to help support this process (myself, Oracle DBA, SQL DBA), plus it adds