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.

Problems with Crystal 8.5

3 posts in General Discussion Last posting was on 2003-12-31 13:53:26.0Z
Dr. Traugott Ziegler Posted on 2003-12-27 13:38:15.0Z
Newsgroups: ianywhere.public.general
From: praxis.ziegler@tesionmail.de (Dr. Traugott Ziegler)
Distribution: world
Subject: Problems with Crystal 8.5
X-Newsreader: EmTec News for OS/2 [version: 4.6f]
Lines: 14
NNTP-Posting-Host: pd9e4bf7c.dip.t-dialin.net
X-Original-NNTP-Posting-Host: pd9e4bf7c.dip.t-dialin.net
Message-ID: <3fed8b47@forums-1-dub>
Date: 27 Dec 2003 05:38:15 -0800
X-Trace: forums-1-dub 1072532295 217.228.191.124 (27 Dec 2003 05:38:15 -0800)
X-Original-Trace: 27 Dec 2003 05:38:15 -0800, pd9e4bf7c.dip.t-dialin.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2225
Article PK: 4431

After conversion of our database to ASA 8.02 ( build 4332 ) we are not able to
use Crystal Reports 8.5 ( 8.5.3.975 ) , all our reports are crashing with the
following message : ODBC Fehler: Sybase ODBCDriver [Adaptive Server
Anywhere]Syntax error or acess violation-permission denied-you do not have
permission to execute the procedure "usp-Dku CharTo PHBoolean". What is the
cause of the error?
Regards
Dr. Traugott Ziegler
Praxis Bommer & Ziegler
Bergheimerstrasse 59/61
69115 Heidelberg
Tel: 06221-97900
Fax: 06221-184085
Mail : praxis.ziegler@tesionmail.de


Nick Elson Posted on 2003-12-29 14:41:08.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3fed8b47@forums-1-dub>
Subject: Re: Problems with Crystal 8.5
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <3ff03d04@forums-1-dub>
Date: 29 Dec 2003 06:41:08 -0800
X-Trace: forums-1-dub 1072708868 172.31.143.54 (29 Dec 2003 06:41:08 -0800)
X-Original-Trace: 29 Dec 2003 06:41:08 -0800, nicelson-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2226
Article PK: 4432

You may just need to

grant execute permissions to the sproc
usp-Dku CharTo PHBoolean

Try granting the group PUBLIC that permission.

It could also have something to do with all those
spaces in that name. Does CrystalR 8.5
delimit all their sproc names on the call (an
ODBC trace will show you that ... so too
would adding a -zr SQL to the dbsrv8/dbeng8
command line)

"Dr. Traugott Ziegler" <praxis.ziegler@tesionmail.de> wrote in message
news:3fed8b47@forums-1-dub...
> After conversion of our database to ASA 8.02 ( build 4332 ) we are not
able to
> use Crystal Reports 8.5 ( 8.5.3.975 ) , all our reports are crashing with
the
> following message : ODBC Fehler: Sybase ODBCDriver [Adaptive Server
> Anywhere]Syntax error or acess violation-permission denied-you do not have
> permission to execute the procedure "usp-Dku CharTo PHBoolean". What is
the
> cause of the error?
> Regards
> Dr. Traugott Ziegler
> Praxis Bommer & Ziegler
> Bergheimerstrasse 59/61
> 69115 Heidelberg
> Tel: 06221-97900
> Fax: 06221-184085
> Mail : praxis.ziegler@tesionmail.de
>


Dr. Traugott Ziegler Posted on 2003-12-31 13:53:26.0Z
Newsgroups: ianywhere.public.general
From: praxis.ziegler@tesionmail.de (Dr. Traugott Ziegler)
Subject: Re: Problems with Crystal 8.5
References: <3fed8b47@forums-1-dub> <3ff03d04@forums-1-dub>
X-Newsreader: EmTec News for OS/2 [version: 4.6f]
Lines: 59
NNTP-Posting-Host: p5084346b.dip.t-dialin.net
X-Original-NNTP-Posting-Host: p5084346b.dip.t-dialin.net
Message-ID: <3ff2d4d6@forums-1-dub>
Date: 31 Dec 2003 05:53:26 -0800
X-Trace: forums-1-dub 1072878806 80.132.52.107 (31 Dec 2003 05:53:26 -0800)
X-Original-Trace: 31 Dec 2003 05:53:26 -0800, p5084346b.dip.t-dialin.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2231
Article PK: 4438

Hello Nick,
thanks for your note. Our software vendor send a patch to me, which corrected
the database and the problem.
Regards
Traugott

Dr. Traugott Ziegler
Praxis Bommer & Ziegler
Bergheimerstrasse 59/61
69115 Heidelberg
Tel: 06221-97900
Fax: 06221-184085
Mail : praxis.ziegler@tesionmail.de


In message <3ff03d04@forums-1-dub> - "Nick Elson"
<no_spam_nicelson@sybase.com> writes:
:>
:>You may just need to
:>
:> grant execute permissions to the sproc
:> usp-Dku CharTo PHBoolean
:>
:>Try granting the group PUBLIC that permission.
:>
:>It could also have something to do with all those
:>spaces in that name. Does CrystalR 8.5
:>delimit all their sproc names on the call (an
:>ODBC trace will show you that ... so too
:>would adding a -zr SQL to the dbsrv8/dbeng8
:>command line)
:>
:>
:>
:>"Dr. Traugott Ziegler" <praxis.ziegler@tesionmail.de> wrote in message
:>news:3fed8b47@forums-1-dub...
:>> After conversion of our database to ASA 8.02 ( build 4332 ) we are not
:>able to
:>> use Crystal Reports 8.5 ( 8.5.3.975 ) , all our reports are crashing with
:>the
:>> following message : ODBC Fehler: Sybase ODBCDriver [Adaptive Server
:>> Anywhere]Syntax error or acess violation-permission denied-you do not have
:>> permission to execute the procedure "usp-Dku CharTo PHBoolean". What is
:>the
:>> cause of the error?
:>> Regards
:>> Dr. Traugott Ziegler
:>> Praxis Bommer & Ziegler
:>> Bergheimerstrasse 59/61
:>> 69115 Heidelberg
:>> Tel: 06221-97900
:>> Fax: 06221-184085
:>> Mail : praxis.ziegler@tesionmail.de
:>>
:>
:>