Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

DWSyntax fails if user is not sysadmin

5 posts in DataWindow Last posting was on 2008-09-24 12:13:16.0Z
NUtshell Posted on 2008-09-23 09:51:14.0Z
Sender: 2b5c.48d8b84a.1804289383@sybase.com
From: nutshell
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: DWSyntax fails if user is not sysadmin
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48d8bc12.2bd3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Sep 2008 02:51:14 -0700
X-Trace: forums-1-dub 1222163474 10.22.241.41 (23 Sep 2008 02:51:14 -0700)
X-Original-Trace: 23 Sep 2008 02:51:14 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87826
Article PK: 417083

Hi,

I use the SyntaxFromSQL("select * from MyTable") to
dynamically create a data object. The problem is that I get
different dataobject results on different servers. When
failing PB does not detect the key column, resulting in a
non updateable dw. As far as I can tell the table
definitions are identical on the two servers, with key,
columns properties etc.

If I change the user to SysAdmin everything works well.

Thank's for any ideas or tips.

/Nut


NUtshell Posted on 2008-09-23 12:09:26.0Z
Sender: 2b5c.48d8b84a.1804289383@sybase.com
From: nutshell
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: DWSyntax fails if user is not sysadmin
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48d8dc76.3074.1681692777@sybase.com>
References: <48d8bc12.2bd3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Sep 2008 05:09:26 -0700
X-Trace: forums-1-dub 1222171766 10.22.241.41 (23 Sep 2008 05:09:26 -0700)
X-Original-Trace: 23 Sep 2008 05:09:26 -0700, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87827
Article PK: 417081

I'm using PB 11.2, MS SQL Server 2005 on Windows NT Server
5.1.

> Hi,
>
> I use the SyntaxFromSQL("select * from MyTable") to
> dynamically create a data object. The problem is that I
> get different dataobject results on different servers.
> When failing PB does not detect the key column, resulting
> in a non updateable dw. As far as I can tell the table
> definitions are identical on the two servers, with key,
> columns properties etc.
>
> If I change the user to SysAdmin everything works well.
>
> Thank's for any ideas or tips.
>
> /Nut


Roland Smith [TeamSybase] Posted on 2008-09-23 13:47:20.0Z
From: "Roland Smith [TeamSybase]" <rsmith_at_trusthss_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48d8bc12.2bd3.1681692777@sybase.com> <48d8dc76.3074.1681692777@sybase.com>
Subject: Re: DWSyntax fails if user is not sysadmin
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48d8f368$1@forums-1-dub>
Date: 23 Sep 2008 06:47:20 -0700
X-Trace: forums-1-dub 1222177640 10.22.241.152 (23 Sep 2008 06:47:20 -0700)
X-Original-Trace: 23 Sep 2008 06:47:20 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87828
Article PK: 417095

The user may not have select permission to a system table, sysobjects for
example.

Try running a database trace, it should tell you exactly where the problem
is.

<nutshell> wrote in message news:48d8dc76.3074.1681692777@sybase.com...
> I'm using PB 11.2, MS SQL Server 2005 on Windows NT Server
> 5.1.
>
>> Hi,
>>
>> I use the SyntaxFromSQL("select * from MyTable") to
>> dynamically create a data object. The problem is that I
>> get different dataobject results on different servers.
>> When failing PB does not detect the key column, resulting
>> in a non updateable dw. As far as I can tell the table
>> definitions are identical on the two servers, with key,
>> columns properties etc.
>>
>> If I change the user to SysAdmin everything works well.
>>
>> Thank's for any ideas or tips.
>>
>> /Nut