Re: Updating a table in other MS Sql 7 DB

[Franck Masson <franck.masson@BRIO.COM>]

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
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
org:            Brio Technology EMEA
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
title:          Sales Manager Northern Europe
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard