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.

compaitbility between SQL Anywhaere and Crystal Reports

7 posts in General Discussion Last posting was on 2007-09-21 19:04:36.0Z
April Jones Posted on 2007-09-12 16:07:16.0Z
From: "April Jones" <a.jones@mtcworldwide.com>
Newsgroups: ianywhere.public.general
Subject: compaitbility between SQL Anywhaere and Crystal Reports
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: mail.mtcworldwide.com
X-Original-NNTP-Posting-Host: mail.mtcworldwide.com
Message-ID: <46e80eb4$1@forums-1-dub>
Date: 12 Sep 2007 09:07:16 -0700
X-Trace: forums-1-dub 1189613236 66.196.16.128 (12 Sep 2007 09:07:16 -0700)
X-Original-Trace: 12 Sep 2007 09:07:16 -0700, mail.mtcworldwide.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6280
Article PK: 2809

I am looking for a listing of the version compatibilities between SQL
Anywhere and Crystal Reports. IN particular I need ot know what versions of
Crystal will work with SQL Anywhere 9.0.2 and what versionof Crystal will
work with SQL Anywhere 10.0.

Thank you,

April Jones


"Stephen Rice" Posted on 2007-09-12 17:22:10.0Z
From: "Stephen Rice" <srice[at]sybase[dot]com>
Newsgroups: ianywhere.public.general
References: <46e80eb4$1@forums-1-dub>
Subject: Re: compaitbility between SQL Anywhaere and Crystal Reports
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: srice-pciii.sybase.com
X-Original-NNTP-Posting-Host: srice-pciii.sybase.com
Message-ID: <46e82042$1@forums-1-dub>
Date: 12 Sep 2007 10:22:10 -0700
X-Trace: forums-1-dub 1189617730 10.25.98.226 (12 Sep 2007 10:22:10 -0700)
X-Original-Trace: 12 Sep 2007 10:22:10 -0700, srice-pciii.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6281
Article PK: 2808

I'm not aware of any incompatibilities. I have used Crystal 8.x with SQL
Anywhere 8, 9, and 10 at various times without issue. I would be very
surprised if the Crystal folks broke things in later versions

You may get a core complete response by posting this question to the
sqlanywhere specific newsgroup at sybase.public.sqlanywhere.general

--
/steve
Stephen Rice
Sybase iAnywhere

"April Jones" <a.jones@mtcworldwide.com> wrote in message
news:46e80eb4$1@forums-1-dub...
>I am looking for a listing of the version compatibilities between SQL
>Anywhere and Crystal Reports. IN particular I need ot know what versions of
>Crystal will work with SQL Anywhere 9.0.2 and what versionof Crystal will
>work with SQL Anywhere 10.0.
>
> Thank you,
>
> April Jones
>


Geoffrey Chambers Posted on 2007-09-12 19:39:34.0Z
Sender: 7ff5.46e83eb2.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: compaitbility between SQL Anywhaere and Crystal Reports
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46e84076.16f.1681692777@sybase.com>
References: <46e80eb4$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Sep 2007 12:39:34 -0700
X-Trace: forums-1-dub 1189625974 10.22.241.41 (12 Sep 2007 12:39:34 -0700)
X-Original-Trace: 12 Sep 2007 12:39:34 -0700, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6282
Article PK: 4687


> I am looking for a listing of the version compatibilities
> between SQL Anywhere and Crystal Reports. IN particular I
> need ot know what versions of Crystal will work with
> SQL Anywhere 9.0.2 and what versionof Crystal will work
> with SQL Anywhere 10.0.
>
> Thank you,
>
> April Jones
>
>

I have successfully used Crystal 10 with SQL Anywhere 9 and
10. I have also used Crystal XI (with the latest SP) with
SQL Anywhere 10. Crystal XI can't seem to read the password
from the DSN, everytime you load a report it will ask you
for the password and sometimes during refreshes. This was
not the case in prior versions of Crystal Reports. The
Crystal Reports help team is no help. In my developemnet App
I can program it to assign the password, but can't fix it
when I'm designing reports.


Breck Carter [Team iAnywhere] Posted on 2007-09-12 20:39:45.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: compaitbility between SQL Anywhaere and Crystal Reports
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <c4jge35ctajn70kqij80k7q6j9un9obs1e@4ax.com>
References: <46e80eb4$1@forums-1-dub> <46e84076.16f.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 12 Sep 2007 13:39:45 -0700
X-Trace: forums-1-dub 1189629585 64.7.134.118 (12 Sep 2007 13:39:45 -0700)
X-Original-Trace: 12 Sep 2007 13:39:45 -0700, bcarter.sentex.ca
Lines: 44
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6283
Article PK: 4688

Here is a WAG: Use regedit to modify the DSN. Delete the PWD string
value. Create a new string value called Password holding the password.
Maybe Crystal will pick that up.

Note that if you use the ODBC Administrator GUI to change the
password, it will put PWD into the registry entry, but AFAIK both PWD
and Password are acceptable. You can prove this by using regedit as
above, then using ODBC Adminisrator - Test Connect.

The "Delete the PWD" step above may be optional.

Breck

On 12 Sep 2007 12:39:34 -0700, Geoffrey Chambers wrote:

>> I am looking for a listing of the version compatibilities
>> between SQL Anywhere and Crystal Reports. IN particular I
>> need ot know what versions of Crystal will work with
>> SQL Anywhere 9.0.2 and what versionof Crystal will work
>> with SQL Anywhere 10.0.
>>
>> Thank you,
>>
>> April Jones
>>
>>
>
>
>I have successfully used Crystal 10 with SQL Anywhere 9 and
>10. I have also used Crystal XI (with the latest SP) with
>SQL Anywhere 10. Crystal XI can't seem to read the password
>from the DSN, everytime you load a report it will ask you
>for the password and sometimes during refreshes. This was
>not the case in prior versions of Crystal Reports. The
>Crystal Reports help team is no help. In my developemnet App
>I can program it to assign the password, but can't fix it
>when I'm designing reports.

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


"Stephen Rice" Posted on 2007-09-14 15:58:02.0Z
From: "Stephen Rice" <srice[at]sybase[dot]com>
Newsgroups: ianywhere.public.general
References: <46e80eb4$1@forums-1-dub> <46e84076.16f.1681692777@sybase.com> <c4jge35ctajn70kqij80k7q6j9un9obs1e@4ax.com>
Subject: Re: compaitbility between SQL Anywhaere and Crystal Reports
Lines: 64
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.3138
NNTP-Posting-Host: srice-pciii.sybase.com
X-Original-NNTP-Posting-Host: srice-pciii.sybase.com
Message-ID: <46eaaf8a$1@forums-1-dub>
Date: 14 Sep 2007 08:58:02 -0700
X-Trace: forums-1-dub 1189785482 10.25.98.226 (14 Sep 2007 08:58:02 -0700)
X-Original-Trace: 14 Sep 2007 08:58:02 -0700, srice-pciii.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6286
Article PK: 2812

In ODBC there is no need for Crystal to read the password. Assmebly of the
ODBC conenct string is the responsibility of the Driver Manager and the
Driver. In theory this "should just work"

Can you take an ODBC trace of Crystal connecting to a database that exhibits
this problem and post it (or email it to me).

Based on that I may be able to figure out what is going on

--
/steve
Stephen Rice
Sybase iAnywhere
sriceNOSpamATsybaseDOTcom

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:c4jge35ctajn70kqij80k7q6j9un9obs1e@4ax.com...
> Here is a WAG: Use regedit to modify the DSN. Delete the PWD string
> value. Create a new string value called Password holding the password.
> Maybe Crystal will pick that up.
>
> Note that if you use the ODBC Administrator GUI to change the
> password, it will put PWD into the registry entry, but AFAIK both PWD
> and Password are acceptable. You can prove this by using regedit as
> above, then using ODBC Adminisrator - Test Connect.
>
> The "Delete the PWD" step above may be optional.
>
> Breck
>
> On 12 Sep 2007 12:39:34 -0700, Geoffrey Chambers wrote:
>
>>> I am looking for a listing of the version compatibilities
>>> between SQL Anywhere and Crystal Reports. IN particular I
>>> need ot know what versions of Crystal will work with
>>> SQL Anywhere 9.0.2 and what versionof Crystal will work
>>> with SQL Anywhere 10.0.
>>>
>>> Thank you,
>>>
>>> April Jones
>>>
>>>
>>
>>
>>I have successfully used Crystal 10 with SQL Anywhere 9 and
>>10. I have also used Crystal XI (with the latest SP) with
>>SQL Anywhere 10. Crystal XI can't seem to read the password
>>from the DSN, everytime you load a report it will ask you
>>for the password and sometimes during refreshes. This was
>>not the case in prior versions of Crystal Reports. The
>>Crystal Reports help team is no help. In my developemnet App
>>I can program it to assign the password, but can't fix it
>>when I'm designing reports.
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-09-14 19:08:26.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: compaitbility between SQL Anywhaere and Crystal Reports
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <qtmle3pclk4cob6m7vbevbu9ip2osek6ai@4ax.com>
References: <46e80eb4$1@forums-1-dub> <46e84076.16f.1681692777@sybase.com> <c4jge35ctajn70kqij80k7q6j9un9obs1e@4ax.com> <46eaaf8a$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 14 Sep 2007 12:08:26 -0700
X-Trace: forums-1-dub 1189796906 64.7.134.118 (14 Sep 2007 12:08:26 -0700)
X-Original-Trace: 14 Sep 2007 12:08:26 -0700, bcarter.sentex.ca
Lines: 25
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6289
Article PK: 4690

Clearly Crystal-challenged I am. Resist further temptation to respond
to such questions I shall :)

Breck More Like Watto Than Yoda



On 14 Sep 2007 08:58:02 -0700, "Stephen Rice"

<srice[at]sybase[dot]com> wrote:

>In ODBC there is no need for Crystal to read the password. Assmebly of the
>ODBC conenct string is the responsibility of the Driver Manager and the
>Driver. In theory this "should just work"
>
>Can you take an ODBC trace of Crystal connecting to a database that exhibits
>this problem and post it (or email it to me).
>
>Based on that I may be able to figure out what is going on

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Geoffrey Chambers Posted on 2007-09-21 19:04:36.0Z
Sender: 48cc.46efe810.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: compaitbility between SQL Anywhaere and Crystal Reports
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46f415c4.34d6.1681692777@sybase.com>
References: <46eaaf8a$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Sep 2007 12:04:36 -0700
X-Trace: forums-1-dub 1190401476 10.22.241.41 (21 Sep 2007 12:04:36 -0700)
X-Original-Trace: 21 Sep 2007 12:04:36 -0700, 10.22.241.41
Lines: 76
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6307
Article PK: 4697

I stop the service and ran a report but the Sybase startup
dialog did not appear. I have a question though, when in
Crystal I am able to create an ADO connection. Is there a
utility I can use to create this connection instead of the
ODBC connection?

> In ODBC there is no need for Crystal to read the password.
> Assmebly of the ODBC conenct string is the
> responsibility of the Driver Manager and the Driver. In
> theory this "should just work"
>
> Can you take an ODBC trace of Crystal connecting to a
> database that exhibits this problem and post it (or email
> it to me).
>
> Based on that I may be able to figure out what is going on
>
> --
> /steve
> Stephen Rice
> Sybase iAnywhere
> sriceNOSpamATsybaseDOTcom
>
> "Breck Carter [Team iAnywhere]"
> <NOSPAM__bcarter@risingroad.com> wrote in message
> > news:c4jge35ctajn70kqij80k7q6j9un9obs1e@4ax.com... Here
> is a WAG: Use regedit to modify the DSN. Delete the PWD
> > string value. Create a new string value called Password
> > holding the password. Maybe Crystal will pick that up.
> >
> > Note that if you use the ODBC Administrator GUI to
> > change the password, it will put PWD into the registry
> > entry, but AFAIK both PWD and Password are acceptable.
> > You can prove this by using regedit as above, then using
> ODBC Adminisrator - Test Connect. >
> > The "Delete the PWD" step above may be optional.
> >
> > Breck
> >
> > On 12 Sep 2007 12:39:34 -0700, Geoffrey Chambers wrote:
> >
> >>> I am looking for a listing of the version
> compatibilities >>> between SQL Anywhere and Crystal
> Reports. IN particular I >>> need ot know what versions of
> Crystal will work with >>> SQL Anywhere 9.0.2 and what
> versionof Crystal will work >>> with SQL Anywhere 10.0.
> >>>
> >>> Thank you,
> >>>
> >>> April Jones
> >>>
> >>>
> >>
> >>
> >>I have successfully used Crystal 10 with SQL Anywhere 9
> and >>10. I have also used Crystal XI (with the latest SP)
> with >>SQL Anywhere 10. Crystal XI can't seem to read the
> password >>from the DSN, everytime you load a report it
> will ask you >>for the password and sometimes during
> refreshes. This was >>not the case in prior versions of
> Crystal Reports. The >>Crystal Reports help team is no
> help. In my developemnet App >>I can program it to assign
> the password, but can't fix it >>when I'm designing
> reports. >
> > --
> > Breck Carter [Team iAnywhere]
> > RisingRoad SQL Anywhere and MobiLink Professional
> > Services www.risingroad.com
> > The book:
> >
>
http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> > breck.carter@risingroad.com
>
>