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.

Password

6 posts in General Discussion Last posting was on 2007-06-02 03:45:09.0Z
Geoffrey Chambers Posted on 2007-05-30 23:19:42.0Z
Sender: 5571.465e0013.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Password
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <465e068e.5605.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 May 2007 16:19:42 -0700
X-Trace: forums-1-dub 1180567182 10.22.241.41 (30 May 2007 16:19:42 -0700)
X-Original-Trace: 30 May 2007 16:19:42 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6048
Article PK: 2508

Is there a way to add the password to the connection string.
I am using SQL Anywhere 10, the database was upgraded from
9. When I use it with Crystal Reports it prompts me for the
password even though it is stored in the ODBC connection.

I start the database as a service, then create the odbc
usinf the server name and the TCP/IP checked.


Chris Keating (Sybase iAnywhere) Posted on 2007-05-31 01:08:17.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Password
References: <465e068e.5605.1681692777@sybase.com>
In-Reply-To: <465e068e.5605.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <465e2001$1@forums-1-dub>
Date: 30 May 2007 18:08:17 -0700
X-Trace: forums-1-dub 1180573697 72.143.69.7 (30 May 2007 18:08:17 -0700)
X-Original-Trace: 30 May 2007 18:08:17 -0700, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6049
Article PK: 2509

The Connection Parameter is: UID=<userid>

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Greg Fenton Posted on 2007-05-31 01:59:53.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: Password
References: <465e068e.5605.1681692777@sybase.com> <465e2001$1@forums-1-dub>
In-Reply-To: <465e2001$1@forums-1-dub>
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: <465e2c19$1@forums-1-dub>
Date: 30 May 2007 18:59:53 -0700
X-Trace: forums-1-dub 1180576793 74.122.201.248 (30 May 2007 18:59:53 -0700)
X-Original-Trace: 30 May 2007 18:59:53 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6051
Article PK: 2511


Chris Keating (Sybase iAnywhere) wrote:
> The Connection Parameter is: UID=<userid>
>

And PWD=<password>

g.f
--
Greg Fenton
Some Random Dude


Chris Keating (Sybase iAnywhere) Posted on 2007-05-31 11:56:34.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Password
References: <465e068e.5605.1681692777@sybase.com> <465e2001$1@forums-1-dub> <465e2c19$1@forums-1-dub>
In-Reply-To: <465e2c19$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <465eb7f2$1@forums-1-dub>
Date: 31 May 2007 04:56:34 -0700
X-Trace: forums-1-dub 1180612594 10.25.99.119 (31 May 2007 04:56:34 -0700)
X-Original-Trace: 31 May 2007 04:56:34 -0700, keating-dm20.sybase.com
Lines: 25
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6052
Article PK: 2510

Thanks Greg for jumping in to answer the real question :-)
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Geoffrey Chambers Posted on 2007-06-01 15:12:26.0Z
Sender: 5571.465e0013.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: Password
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4660375a.d32.1681692777@sybase.com>
References: <465eb7f2$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Jun 2007 08:12:26 -0700
X-Trace: forums-1-dub 1180710746 10.22.241.41 (1 Jun 2007 08:12:26 -0700)
X-Original-Trace: 1 Jun 2007 08:12:26 -0700, 10.22.241.41
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6060
Article PK: 2518


> Thanks Greg for jumping in to answer the real question :-)
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> **********************************************************
> *******************
>
> Sign up today for your copy of the SQL Anywhere Studio 10
> Developer Edition =and try out the market-leading
> database for mobile, embedded and small to medium sized
> business environments for free!
>
>
http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html
>
> **********************************************************
> *******************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at
> http://www.iAnywhere.com/developer ** EBFs can be found at
> http://downloads.sybase.com/swx/sdmain.stm ** Use Case
> Express to report bugs http://case-express.sybase.com
>
> **********************************************************
> *******************

That didn't seem to work either, when I use Crystal with
version 10 of SQL Anywhere, it always ask me for the
password, case isn't the issue.


Chris Keating (Sybase iAnywhere) Posted on 2007-06-02 03:45:09.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Password
References: <465eb7f2$1@forums-1-dub> <4660375a.d32.1681692777@sybase.com>
In-Reply-To: <4660375a.d32.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpneast-client-079.sybase.com
X-Original-NNTP-Posting-Host: vpneast-client-079.sybase.com
Message-ID: <4660e7c5$1@forums-1-dub>
Date: 1 Jun 2007 20:45:09 -0700
X-Trace: forums-1-dub 1180755909 10.18.242.86 (1 Jun 2007 20:45:09 -0700)
X-Original-Trace: 1 Jun 2007 20:45:09 -0700, vpneast-client-079.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6061
Article PK: 2520

I think it is time to get a technical support case opened to work this
problem. This question has been in this forum for some time without a
solution.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************