Re: Updating a table in other MS Sql 7 DB

[Doug Nichols <drnichols@ATT.NET>]

        I'm using the version of SQR that comes with Peoplesoft 7.5, it's 
4.3.2. I
can read the table fine, it won't do the update to the table that is on
another server(both NT and SQL). The server is on another physical machine.
I'm not using an odbc string inside my sqr, i have created a linked server
using enterprise manager in sql 7. I have all the appropriate permissions,
because i can run the same update using the sql server query tool. But that
doesn't use ODBC, whereas SQR does when it runs.


-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Franck Masson
Sent: Tuesday, January 02, 2001 3:36 PM
To: SQR-USERS@list.iex.net
Subject: Re: Updating a table in other MS Sql 7 DB


Doug,

What version of SQR are you using ?
in the samplew directory you have a sqr sample LoadAll.sqr that create
table.
Have you tested it ?

Can you read and update using the same DSN ?

Franck,

Doug Nichols wrote:
>
>         Hi,
>
>         I am running an sqr against one database and want to select data
from and
> update a table in another
>         database on a different sql server. I am runnin Sql server 7.0. I
have set
> up a link between both database
>         servers and can select data fine. It's the update that fails. If I
use
> isql/w, the update query works fine, it just
>         doesn't work when I run it in my sqr program.
>         Does anybody have any tips?
>
>         thanks a lot,
>         Doug