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.

Version 10

9 posts in General Discussion Last posting was on 2007-05-13 15:12:05.0Z
Geoffrey Chambers Posted on 2007-05-08 16:46:07.0Z
Sender: 3dd7.463f657b.846930886@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Version 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4640a94f.6497.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 May 2007 09:46:07 -0700
X-Trace: forums-1-dub 1178642767 10.22.241.41 (8 May 2007 09:46:07 -0700)
X-Original-Trace: 8 May 2007 09:46:07 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5987
Article PK: 2446

I have 2 issues with the trial version

1) Only one person can access the database at a time
2) When opening a Crystal report, the ODBC pops up
requesting a password, even though I have stored it in the
DSN.

When I actually purchase a 5 license server copy, will these
things go away?


Greg Fenton Posted on 2007-05-09 02:59:38.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Version 10
References: <4640a94f.6497.1681692777@sybase.com>
In-Reply-To: <4640a94f.6497.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <4641391a$1@forums-1-dub>
Date: 8 May 2007 19:59:38 -0700
X-Trace: forums-1-dub 1178679578 74.122.201.248 (8 May 2007 19:59:38 -0700)
X-Original-Trace: 8 May 2007 19:59:38 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5988
Article PK: 2447


Geoffrey Chambers wrote:
> I have 2 issues with the trial version
>
> 1) Only one person can access the database at a time

Nope, this is not a limitation. What are the symptoms of "only one
person can access"?

What is the *exact* command line you are using to start the server?
What client are you using?

> 2) When opening a Crystal report, the ODBC pops up
> requesting a password, even though I have stored it in the
> DSN.

You'll need to provide more information as to what it is you are doing
and exactly the contents of the ODBC DSN. You can get the contents of
the DSN in news-friendly postable format using the command:

dbdns -gs <system_dsn_name>

or

dbdsn -gu <user_dsn_name>

(depending on whether it is a system or user DSN you are using. If
Crystal is connecting to a server other than the one talked about in #1,
please provide server startup command for this one too.


g.f
--
Greg Fenton
Some Random Dude


Geoffrey Chambers Posted on 2007-05-09 18:14:37.0Z
Sender: 3dd7.463f657b.846930886@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: Version 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46420f8d.f06.1681692777@sybase.com>
References: <4641391a$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 May 2007 11:14:37 -0700
X-Trace: forums-1-dub 1178734477 10.22.241.41 (9 May 2007 11:14:37 -0700)
X-Original-Trace: 9 May 2007 11:14:37 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5990
Article PK: 2448

C:\Program Files\SQL Anywhere 10\win32\dbsrv10.exe -c 8m

This worked for version 9

AS far as Crystal Report goes it's using the same DSN, never
had to worry about entering a password.


Reg Domaratzki (iAnywhere Solutions) Posted on 2007-05-10 13:24:51.0Z
From: "Reg Domaratzki \(iAnywhere Solutions\)" <FirstName.LastName@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4641391a$1@forums-1-dub> <46420f8d.f06.1681692777@sybase.com>
Subject: Re: Version 10
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: rdomarat-xp.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-xp.sybase.com
Message-ID: <46431d23@forums-1-dub>
Date: 10 May 2007 06:24:51 -0700
X-Trace: forums-1-dub 1178803491 10.25.99.188 (10 May 2007 06:24:51 -0700)
X-Original-Trace: 10 May 2007 06:24:51 -0700, rdomarat-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5991
Article PK: 2449

If you are accessing the network database server from multiple machines and
testing with the development version, you can increase the number of
licenses seats using the dblic utility.

If you are being prompted for the password by the SQL Anywhere ( are you
sure it's a SQL Anywhere prompt and not a Crystal Reports prompt ), then it
means the password in the DSN is likely not correct. Are you sure you have
the correct case of all the letters in the dsn? All password in v10 are now
case sensitive, even if the database itself is not. Can other ODBC
application connect using this same DSN?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

<Geoffrey Chambers> wrote in message
news:46420f8d.f06.1681692777@sybase.com...
> C:\Program Files\SQL Anywhere 10\win32\dbsrv10.exe -c 8m
>
> This worked for version 9
>
> AS far as Crystal Report goes it's using the same DSN, never
> had to worry about entering a password.


Geoffrey Chambers Posted on 2007-05-10 18:26:47.0Z
Sender: 3dd7.463f657b.846930886@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: Version 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <464363e7.3a17.1681692777@sybase.com>
References: <46431d23@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 May 2007 11:26:47 -0700
X-Trace: forums-1-dub 1178821607 10.22.241.41 (10 May 2007 11:26:47 -0700)
X-Original-Trace: 10 May 2007 11:26:47 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5992
Article PK: 2450

I tried setting it up as a service, but when I try to create
the ODBC connection, I get the error message "request to
start or stop database denied. I'll still think it's the
trial version. I tried running the system commands but they
kept executing the version 9 and it couldn't read my version
10 database.


Breck Carter [Team iAnywhere] Posted on 2007-05-11 09:21:58.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Version 10
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <tbd843pd5d23224ld62u04rgeoef8olm4a@4ax.com>
References: <46431d23@forums-1-dub> <464363e7.3a17.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: 11 May 2007 02:21:58 -0700
X-Trace: forums-1-dub 1178875318 64.7.134.118 (11 May 2007 02:21:58 -0700)
X-Original-Trace: 11 May 2007 02:21:58 -0700, bcarter.sentex.ca
Lines: 28
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5996
Article PK: 2453

In addition to what Greg said about fixing the PATH, another approach
is to stop relying on the PATH for any SQL Anywhere executables.

Standard installations of V8 and V10 create environment variables
which make writing command files easier:

"%ASANY9%\win32\dbinit.exe" -p 4096 ddd.db

"%SQLANY10%\win32\dbinit.exe" -s ddd.db

Breck

On 10 May 2007 11:26:47 -0700, Geoffrey Chambers wrote:

>I tried setting it up as a service, but when I try to create
>the ODBC connection, I get the error message "request to
>start or stop database denied. I'll still think it's the
>trial version. I tried running the system commands but they
>kept executing the version 9 and it couldn't read my version
>10 database.

--
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


Greg Fenton Posted on 2007-05-11 02:44:35.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Version 10
References: <46431d23@forums-1-dub> <464363e7.3a17.1681692777@sybase.com>
In-Reply-To: <464363e7.3a17.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <4643d893$1@forums-1-dub>
Date: 10 May 2007 19:44:35 -0700
X-Trace: forums-1-dub 1178851475 74.122.201.248 (10 May 2007 19:44:35 -0700)
X-Original-Trace: 10 May 2007 19:44:35 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 28
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5995
Article PK: 2454


Geoffrey Chambers wrote:
> I'll still think it's the
> trial version.

Unless things have changed in v10 (and I doubt they have), the "trial
version" is the full version but with a default maximum of 3 concurrent
connections and the "nag screens". Everything else is binarily(?)
identical.

As Reg points out, you can change the licensing if for development purposes.

Have you use the "test connection" button on the ODBC manager to confirm
that the DSN actually works?

> I tried running the system commands but they
> kept executing the version 9 and it couldn't read my version
> 10 database.

Then this means that your PATH is not properly configured for running
v10. It is likely that v9 appears first in your PATH.

You can manually change the PATH in a single command-prompt session or
you can change it via the System properties.

g.f
--
Greg Fenton
Some Random Dude


Geoffrey Chambers Posted on 2007-05-12 15:41:47.0Z
Sender: 3dd7.463f657b.846930886@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: Version 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4645e03b.3af.1681692777@sybase.com>
References: <4641391a$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 May 2007 08:41:47 -0700
X-Trace: forums-1-dub 1178984507 10.22.241.41 (12 May 2007 08:41:47 -0700)
X-Original-Trace: 12 May 2007 08:41:47 -0700, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5999
Article PK: 2458

I changed the path and the version 10 now runs,
UID = dba
PWD = sql
DBF = c:\onsite\onsite.db
start = c:\program files\sql anywhere 10\win32\dbsrv10.exe
-c 8m
astop = yes
int = no
comp = no

I tried starting it as a service, but it never got past
pending start/ it never started and now I tried to delete
the service and it won't delete. I"ve rebooted and it stiil
hung up.

If I start the program as one remote user, I can access from
other users, setting the ODBC set up to look for server =
onsite and checking TCP/IP.


Greg Fenton Posted on 2007-05-13 15:12:05.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Version 10
References: <4641391a$1@forums-1-dub> <4645e03b.3af.1681692777@sybase.com>
In-Reply-To: <4645e03b.3af.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <46472ac5$1@forums-1-dub>
Date: 13 May 2007 08:12:05 -0700
X-Trace: forums-1-dub 1179069125 74.122.201.248 (13 May 2007 08:12:05 -0700)
X-Original-Trace: 13 May 2007 08:12:05 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 33
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6001
Article PK: 2460


Geoffrey Chambers wrote:
> I changed the path and the version 10 now runs,
> UID = dba
> PWD = sql
> DBF = c:\onsite\onsite.db
> start = c:\program files\sql anywhere 10\win32\dbsrv10.exe
> -c 8m
> astop = yes
> int = no
> comp = no

The above connection parameters cause the server to start if one is not
already running *locally*.

What are the parameters of your service that is failing to start?
Try adding a "-o" parameter to have the console output go to a file,
then you can see where the startup is "hanging" (also, please describe
what you mean by "hanging").

> If I start the program as one remote user, I can access from
> other users, setting the ODBC set up to look for server =
> onsite and checking TCP/IP.

I *strongly* suggest that you read the help documentation section about
connection strings. It should help you make heads and tails of what is
actually happening with your connections. This stuff isn't magic, but
it appears to be magic if you don't understand the default behaviours of
client communications.

g.f
--
Greg Fenton
Some Random Dude