Antonio,
What permissions are defined for the table? Your AR Server should connect
to the MS-SQL Server 2000 database as "ARAdmin" or "<domain>\ARAdmin", and
this is the same account that is used to read from any local or external
linked tables. Does this account have select permissions on the table?
--Thomas
----- Original Message -----
From: "Antonio Acosta" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
Sent: Thursday, May 04, 2006 22:02
Subject: Problem creating a View Form
Hello listers,
ARS 6.0.3
Windows XP SP2
SQL 2000 SP4
When I try to create a View form, based on a table defined in the same
Database used by the ARSystem, and click on the load button, I getting the
following error :
Requested database table not found. Please check the spelling (table name
is case-sensitive).(ARERR 481)
I can´t see the column of the table selected to create the Form. This
table used is not part of the ARSystem structure, but resides in the same
database.
When I repeat the process to create a View Form and select form example
the arschema table, when I press the load botton I get the columns of the
mentioned table and I able to create the View Form.
Turning on the sql log, I can see that in the first scenario the ARSystem
run a sql statement like this:
*/ SELECT id from sysobjects where name = 'Tabla1'
but nothing else happens
However when is used the arschema or any other table or view that is part
of the arsystem I obtain somtehig like this:
*/SELECT id from sysobjects where name = 'arschema'
*/SELECT count(*) from syscolumns where id = 1397580017
*/SELECT name,xtype,length,xprec,xscale from syscolumns where id =
1397580017
If I run the firts sql statement (*/ SELECT id from sysobjects where name
= 'Tabla1') with the sql client I can see too the expected result.
I´ve already check all the requirements for the table in order to be used
to create a View form (Dev_basic Document).
What else I need to check to crate the View Form properly?
Any hints will be really appreciate.
Antonio Acosta
Consultant
Caracas - Venezuela
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
