I have a view on SQL that I want to load on Remedy so I open the admin tool and
click on new object then I select view form and type in my database table
ARSystem.dbo.MyViewForm and when I click on load I don't get an error but
there's no available columns showing up. MyViewForm is a view I
.
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of tricky maybe
Sent: Friday, May 23, 2008 8:02 AM
To: arslist@ARSLIST.ORG
Subject: No available columns when creating a view form from SQL
** I have a view on SQL that I want to load on Remedy so
Things may be tricky if you don't know where to look below the
surface. Turn on your server sql logs and try to load the columns in
the admin tool; find the statement in the sql logs that attempts to
return the columns, see why it doesn't, then things may not be so
tricky. k, tricky maybe?
Axton
to the requirements for the Request ID field.
-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of tricky maybe
Sent: Friday, May 23, 2008 8:02 AM
To: arslist@ARSLIST.ORG
Subject: No available columns when creating a view form
] On Behalf Of tricky maybe
Sent: Friday, May 23, 2008 8:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: No available columns when creating a view form from SQL
**
Remedy 6.3 on SQL 2005. Which manual should I be looking for? Thanks
From: Action Request System discussion list(ARSList)
[mailto
If you are attempting to create a view form from an external sql database
For SQL Server—
TABLENAME or DATABASENAME.OWNER.TABLENAME (Make sure you specify dbo if the
current user is the owner of the table.)
Also make sure ARAdmin has permissions to the sql db you are attempting to
create a
:[EMAIL
PROTECTED] On Behalf Of tricky maybe
Sent: Friday, May 23, 2008 8:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: No available columns when creating a view form from SQL
** Remedy 6.3 on SQL 2005. Which manual should I be looking for? Thanks
From: Action Request System discussion
) [mailto:[EMAIL
PROTECTED] On Behalf Of Kevin Pulsen
Sent: Friday, May 23, 2008 7:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: No available columns when creating a view form from SQL
**
If you are attempting to create a view form from an external sql
database...
For SQL Server
)
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jason Tricky
Sent: Friday, May 23, 2008 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: No available columns when creating a view form from SQL
**
I was able to create a view from the external
Here is a screen shot. You will need to select one of the columns as a
designated Key field.
Kevin P.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where
:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: No available columns when creating a view form from SQL
**
Here is a screen shot. You will need to select one of the columns as
a designated Key field.
Kevin P.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Just want to make sure of a couple of items.
1. You have created a Linked Server (From the AR database server) to your
external database. (Are both of these db's SQL 2005?)
2. ARAdmin has rights to access the external database.
Kevin P.
**
When I hit load nothing shows up on the available
]gt;
Subject: Re: No available columns when creating a view form from SQL
To: arslist@ARSLIST.ORG
Date: Friday, May 23, 2008, 3:29 PM
Just want to make sure of a couple of items.
1. You have created a Linked Server (From the AR database server) to your
external database. (Are both of these db's SQL
(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of Kevin Pulsen
Sent: Friday, May 23, 2008 8:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: No available columns when creating a view form from SQL
**
Without the REQUIREMENTS of the external db not having any column
(field) that enforces non
AM
To: arslist@ARSLIST.ORG
Subject: Re: No available columns when creating a view form from SQL
**
Here is a screen shot. You will need to select one of the columns as a
designated Key field.
Kevin P.
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
__Platinum
15 matches
Mail list logo