Hi Folks...
I am having a little trouble creating and saving a View Form based on a
MSSQL to MSSQL database link.
Environment:
- Windows Server 2008
- ARS 7.5 Patch 2
- MSSQL Server 2008
Preface:
We have followed what is outlined in the manual for this procedure:
======================================================
Setting up a remote database for view forms
======================================================
*SQL Server Setup*
- Create a link to the remote database and either give ARAdmin an
account on the remote database or use the proper login credentials.
- Turn on Distributed Transaction Coordinator for both the local and the
remote databases.
- Specify the following server configuration setting in the ar.conf (
ar.cfg) file:
SQL-Server-Set-ANSI-Defaults: T
This setting enables the DB-Library connection that AR System uses to
use ANSI-NULLs and ANSI warnings. There should be no impact on the
performance of the database. For more information about the ar.conf (
ar.cfg) file, see the*Configuration Guide*.
The format for the table name is:
LINKNAME.DATABASENAME.OWNER.TABLENAME
======================================================
What happens:
1. We try to connect to this table:
swarsdog23\inac.arsystem.dbo.INAC_SDS_DATA_PPL_People
2. The available columns that are returned are all Integers.
3. We try to go ahead and create the View Form anyway.
4. When we try to save we get a save failed error 552. that references
SQL Server 102: Failure during SQL operation to the database syntax near
'\'. (SQL Server 102).
5. The CREATE statement in the SQL Log uses the table name:
swarsdog23\inac.arsystem.dbo.INAC_SDS_DATA_PPL_People
6. When I run straight SQL from the calling database we can execute and
return entries: SELECT * from "swarsdog23\inac".arsystem.
dbo.INAC_SDS_DATA_PPL_People
Conclusions:
1. Somehow the Linked Server Name is creating a problem.
2. We have tried "[ ]" and using double quotes in the View Table
creation wizard and this fails; therefore, we cannot alter the naming.
3. Somehow in the CREATE statement - ARS fails to place quotes around
the LINKNAME.
4. swarsdog23 is the name of our production database server (not the
real name, but the syntax is correct) - we cannot change this right now.
Query:
1. Is it the name of the database server that poses the probem? OR
2. Is this a bug?
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
