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.

connecting anywhere via JDBC

4 posts in General Discussion Last posting was on 2007-01-23 12:18:31.0Z
uschi Posted on 2007-01-18 10:28:10.0Z
Sender: a48.45af55cd.1804289383@sybase.com
From: uschi
Newsgroups: ianywhere.public.general
Subject: connecting anywhere via JDBC
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45af59ca.af0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jan 2007 03:28:10 -0700
X-Trace: forums-1-dub 1169119690 10.22.241.41 (18 Jan 2007 03:28:10 -0700)
X-Original-Trace: 18 Jan 2007 03:28:10 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5793
Article PK: 1786

hi,
we have 2 databases (sybase anywhere 8; namend arca and
zerca) installed. With a JAVA-tool we try to connect to one
of the databases. For the connect we are using the following
(correct) string: jdbc:sybase:Tds:servername:2640/zerca

The problem is, that we are connecting always to database
arca, not to zerca!

Any idea?

Thanks
uschi


Stephen Rice Posted on 2007-01-18 12:15:59.0Z
From: "Stephen Rice" <sriceATianywhereDOTcom>
Newsgroups: ianywhere.public.general
References: <45af59ca.af0.1681692777@sybase.com>
Subject: Re: connecting anywhere via JDBC
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: srice-xp2.sybase.com
X-Original-NNTP-Posting-Host: srice-xp2.sybase.com
Message-ID: <45af730f$1@forums-1-dub>
Date: 18 Jan 2007 05:15:59 -0700
X-Trace: forums-1-dub 1169126159 10.25.98.210 (18 Jan 2007 05:15:59 -0700)
X-Original-Trace: 18 Jan 2007 05:15:59 -0700, srice-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5794
Article PK: 1783

Can you show us the exact command line you are starting the database server
with. I suspect your url is slightly wrong.

--
/steve

Stephen Rice
iAnywhere (a Sybase Company)

<uschi> wrote in message news:45af59ca.af0.1681692777@sybase.com...
> hi,
> we have 2 databases (sybase anywhere 8; namend arca and
> zerca) installed. With a JAVA-tool we try to connect to one
> of the databases. For the connect we are using the following
> (correct) string: jdbc:sybase:Tds:servername:2640/zerca
>
> The problem is, that we are connecting always to database
> arca, not to zerca!
>
> Any idea?
>
> Thanks
> uschi


"Nick Elson" < Posted on 2007-01-18 14:30:16.0Z
From: "Nick Elson" <@n@o@.@s@p@a@m@.@n@i@c@k@.@e@l@s@o@n@s@y@b@a@s@e@.@c@o@m@>
Newsgroups: ianywhere.public.general
References: <45af59ca.af0.1681692777@sybase.com>
Subject: Re: connecting anywhere via JDBC
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: nicelson-m20.sybase.com
X-Original-NNTP-Posting-Host: nicelson-m20.sybase.com
Message-ID: <45af9288$1@forums-1-dub>
Date: 18 Jan 2007 07:30:16 -0700
X-Trace: forums-1-dub 1169134216 10.25.98.215 (18 Jan 2007 07:30:16 -0700)
X-Original-Trace: 18 Jan 2007 07:30:16 -0700, nicelson-m20.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5795
Article PK: 1785

the URL:port/zerca database name convention will not work
with SQL Anywhere. In ASE you connect to the server and
'USE' the database name; which only happens after the
connection is made and valid.

In contrast, with SQL Anywhere you connect to the database.
To do that you need to specify the

?SERVICENAME=zerca

at the end of that URL; instead of the '/zerca'.

<uschi> wrote in message news:45af59ca.af0.1681692777@sybase.com...
> hi,
> we have 2 databases (sybase anywhere 8; namend arca and
> zerca) installed. With a JAVA-tool we try to connect to one
> of the databases. For the connect we are using the following
> (correct) string: jdbc:sybase:Tds:servername:2640/zerca
>
> The problem is, that we are connecting always to database
> arca, not to zerca!
>
> Any idea?
>
> Thanks
> uschi


uschi Posted on 2007-01-23 12:18:31.0Z
Sender: 1c9.45b60493.1804289383@sybase.com
From: uschi
Newsgroups: ianywhere.public.general
Subject: Re: connecting anywhere via JDBC
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45b60b26.24f.1681692777@sybase.com>
References: <45af9288$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Jan 2007 05:18:31 -0700
X-Trace: forums-1-dub 1169558311 10.22.241.41 (23 Jan 2007 05:18:31 -0700)
X-Original-Trace: 23 Jan 2007 05:18:31 -0700, 10.22.241.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5796
Article PK: 1787

That's the solution. Thank you very much...

> the URL:port/zerca database name convention will not work
> with SQL Anywhere. In ASE you connect to the server and
> 'USE' the database name; which only happens after the
> connection is made and valid.
>
> In contrast, with SQL Anywhere you connect to the
> database. To do that you need to specify the
>
> ?SERVICENAME=zerca
>
> at the end of that URL; instead of the '/zerca'.
>
>
> <uschi> wrote in message
> > news:45af59ca.af0.1681692777@sybase.com... hi,
> > we have 2 databases (sybase anywhere 8; namend arca and
> > zerca) installed. With a JAVA-tool we try to connect to
> > one of the databases. For the connect we are using the
> > following (correct) string:
> jdbc:sybase:Tds:servername:2640/zerca >
> > The problem is, that we are connecting always to
> > database arca, not to zerca!
> >
> > Any idea?
> >
> > Thanks
> > uschi
>
>