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.

incorrect syntax near ')'

4 posts in DataWindow Last posting was on 2008-11-26 15:10:11.0Z
TonyMIS Posted on 2008-11-25 22:34:18.0Z
From: TonyMIS <aesteves@bostonfinancial.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: incorrect syntax near ')'
Date: Tue, 25 Nov 2008 14:34:18 -0800 (PST)
Organization: http://groups.google.com
Lines: 13
Message-ID: <2a313284-7185-459a-9ebc-7a70e387adf8@j35g2000yqh.googlegroups.com>
NNTP-Posting-Host: 209.0.112.9
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1227652458 15596 127.0.0.1 (25 Nov 2008 22:34:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 25 Nov 2008 22:34:18 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j35g2000yqh.googlegroups.com; posting-host=209.0.112.9; posting-account=XF6ckgoAAACs7hQvjds3XT2_H3YZR6k7
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; InfoPath.1),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!j35g2000yqh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88238
Article PK: 417492

Hello
PB 10 build 4510 / MSsqlServer 8.00.194

I am testing an application that works on other peoples desktops, when
I click buttons that open datawindows I get the message " incorrect
syntax near ')' " . The dw's are built off of sql. There is nothing
wrong with them, it's definetely my local setup. I already went to the
ODBC to my system dsn and un-selected 'Use Ansi Quote Identifiers' and
that eliminated some other errors I was getting previous to this.

Any ideas would be greatly appreciated.
Thanks
Tony


Chris Pollach Posted on 2008-11-26 13:52:54.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <2a313284-7185-459a-9ebc-7a70e387adf8@j35g2000yqh.googlegroups.com>
Subject: Re: incorrect syntax near ')'
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <492d54b6$1@forums-1-dub>
Date: 26 Nov 2008 05:52:54 -0800
X-Trace: forums-1-dub 1227707574 10.22.241.152 (26 Nov 2008 05:52:54 -0800)
X-Original-Trace: 26 Nov 2008 05:52:54 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88239
Article PK: 417494

Tony;

FWIW: Make sure that you have the same runtime (support DLL's) for the
PBVM on the failing machine that you use on the ones that work OK.

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"TonyMIS" <aesteves@bostonfinancial.com> wrote in message
news:2a313284-7185-459a-9ebc-7a70e387adf8@j35g2000yqh.googlegroups.com...
> Hello
> PB 10 build 4510 / MSsqlServer 8.00.194
>
> I am testing an application that works on other peoples desktops, when
> I click buttons that open datawindows I get the message " incorrect
> syntax near ')' " . The dw's are built off of sql. There is nothing
> wrong with them, it's definetely my local setup. I already went to the
> ODBC to my system dsn and un-selected 'Use Ansi Quote Identifiers' and
> that eliminated some other errors I was getting previous to this.
>
> Any ideas would be greatly appreciated.
> Thanks
> Tony


Scott Morris Posted on 2008-11-26 14:40:43.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <2a313284-7185-459a-9ebc-7a70e387adf8@j35g2000yqh.googlegroups.com>
Subject: Re: incorrect syntax near ')'
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <492d5feb$1@forums-1-dub>
Date: 26 Nov 2008 06:40:43 -0800
X-Trace: forums-1-dub 1227710443 10.22.241.152 (26 Nov 2008 06:40:43 -0800)
X-Original-Trace: 26 Nov 2008 06:40:43 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88240
Article PK: 417495


"TonyMIS" <aesteves@bostonfinancial.com> wrote in message
news:2a313284-7185-459a-9ebc-7a70e387adf8@j35g2000yqh.googlegroups.com...
> Hello
> PB 10 build 4510 / MSsqlServer 8.00.194
>
> I am testing an application that works on other peoples desktops, when
> I click buttons that open datawindows I get the message " incorrect
> syntax near ')' " . The dw's are built off of sql. There is nothing
> wrong with them, it's definetely my local setup. I already went to the
> ODBC to my system dsn and un-selected 'Use Ansi Quote Identifiers' and
> that eliminated some other errors I was getting previous to this.

If you did this without understanding the impact, then I suggest you go back
and undo it. This setting (ON) is the default setting for most types of
connections and is required in some cases. In addition, the values you set
in the transaction object before connecting (as well as the pbodbxxx.ini
file) can override the DSN settings. In general, you should have a VERY
GOOD reason for choosing to access a sql server database with this setting
off. One last comment - if you didn't need to do this on the other
desktops, then you shouldn't need to do it here either.

>
> Any ideas would be greatly appreciated.

1. It would help to see the exact query that causes the error. Strange
things like this can happen when you change the quoted_identifier setting,
causing SQL Server to intrepret something as a string constant that was
formerly an object name (or vice versa).
2. You should get in the habit of posting the details about your DB
connection (the values you set in the transaction object attributes dbms,
dbparm, server, lock, etc.) when discussing DB related issues. These often
have significant bearing on the issue (or its resolution).
3. 8.00.194 is the original version of SQL Server 2000. There is a severe
security risk with this version. You really need to keep up with the
service packs.


TonyMIS Posted on 2008-11-26 15:10:11.0Z
From: TonyMIS <aesteves@bostonfinancial.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: incorrect syntax near ')'
Date: Wed, 26 Nov 2008 07:10:11 -0800 (PST)
Organization: http://groups.google.com
Lines: 54
Message-ID: <d6caf923-f9da-41b0-a3d4-b90bda815b00@r40g2000yqj.googlegroups.com>
References: <2a313284-7185-459a-9ebc-7a70e387adf8@j35g2000yqh.googlegroups.com> <492d5feb$1@forums-1-dub>
NNTP-Posting-Host: 209.0.112.9
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1227712212 21495 127.0.0.1 (26 Nov 2008 15:10:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 26 Nov 2008 15:10:12 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r40g2000yqj.googlegroups.com; posting-host=209.0.112.9; posting-account=XF6ckgoAAACs7hQvjds3XT2_H3YZR6k7
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; InfoPath.1),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!r40g2000yqj.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88243
Article PK: 417499


On Nov 26, 9:40 am, "Scott Morris" <bo...@bogus.com> wrote:
> "TonyMIS" <aeste...@bostonfinancial.com> wrote in message
>
> news:2a313284-7185-459a-9ebc-7a70e387adf8@j35g2000yqh.googlegroups.com...
>
> > Hello
> > PB 10 build 4510 / MSsqlServer 8.00.194
>
> > I am testing an application that works on other peoples desktops, when
> > I click buttons that open datawindows I get the message " incorrect
> > syntax near ')' " .  The dw's are built off of sql. There is nothing
> > wrong with them, it's definetely my local setup. I already went to the
> > ODBC to my system dsn and un-selected 'Use Ansi Quote Identifiers' and
> > that eliminated some other errors I was getting previous to this.
>
> If you did this without understanding the impact, then I suggest you go back
> and undo it.  This setting (ON) is the default setting for most types of
> connections and is required in some cases.  In addition, the values you set
> in the transaction object before connecting (as well as the pbodbxxx.ini
> file) can override the DSN settings.  In general, you should have a VERY
> GOOD reason for choosing to access a sql server database with this setting
> off.  One last comment - if you didn't need to do this on the other
> desktops, then you shouldn't need to do it here either.
>
>
>
> > Any ideas would be greatly appreciated.
>
> 1.  It would help to see the exact query that causes the error.  Strange
> things like this can happen when you change the quoted_identifier setting,
> causing SQL Server to intrepret something as a string constant that was
> formerly an object name (or vice versa).
> 2.  You should get in the habit of posting the details about your DB
> connection (the values you set in the transaction object attributes dbms,
> dbparm, server, lock, etc.) when discussing DB related issues.  These often
> have significant bearing on the issue (or its resolution).
> 3.  8.00.194 is the original version of SQL Server 2000.  There is a severe
> security risk with this version.  You really need to keep up with the
> service packs.

Thanks for all the feed-back--very useful. I will followup on that and
see what happens.
thanks again!
Sincerely,
Tony