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.

"CONNECT TO" statement

3 posts in General Discussion Last posting was on 2004-05-04 16:06:27.0Z
Antonio Arena Posted on 2004-04-23 08:37:18.0Z
From: "Antonio Arena" <antonio.arena@bluserenahotels.it>
Newsgroups: ianywhere.public.general
Subject: "CONNECT TO" statement
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: host130-152.pool81117.interbusiness.it
Message-ID: <4088d5ba@forums-2-dub>
X-Original-Trace: 23 Apr 2004 01:37:14 -0700, host130-152.pool81117.interbusiness.it
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Apr 2004 01:37:15 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Apr 2004 01:37:18 -0700
X-Trace: forums-1-dub 1082709438 10.22.108.75 (23 Apr 2004 01:37:18 -0700)
X-Original-Trace: 23 Apr 2004 01:37:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3001
Article PK: 6469

Hi to all,

Up to version 7 of ASA, the "CONNECT TO" statement worked properly when used
in iSQL. In version 8, it doesn't work. The same statement that works in ASA
7, generates the error message "Specified database not found" in ASA 8. Is
it a real problem or am I missing something? Is there an EBF to fix this?

Thank you in advance

Antonio

ASA 8.0.2.4218
ASA 7.0.2.1402


Stephen Rice Posted on 2004-04-29 21:25:50.0Z
Newsgroups: ianywhere.public.general
Subject: Re: "CONNECT TO" statement
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <4088d5ba@forums-2-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns94DAB14D8A6F5sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: srice-pc1.sybase.com
X-Original-Trace: 29 Apr 2004 14:25:46 -0700, srice-pc1.sybase.com
Lines: 37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Apr 2004 14:25:49 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Apr 2004 14:25:50 -0700
X-Trace: forums-1-dub 1083273950 10.22.108.75 (29 Apr 2004 14:25:50 -0700)
X-Original-Trace: 29 Apr 2004 14:25:50 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3017
Article PK: 6485

"Antonio Arena" <antonio.arena@bluserenahotels.it> wrote in
news:4088d5ba@forums-2-dub:

> Hi to all,
>
> Up to version 7 of ASA, the "CONNECT TO" statement worked properly
> when used in iSQL. In version 8, it doesn't work. The same statement
> that works in ASA 7, generates the error message "Specified database
> not found" in ASA 8. Is it a real problem or am I missing something?
> Is there an EBF to fix this?
>
> Thank you in advance
>
> Antonio
>
> ASA 8.0.2.4218
> ASA 7.0.2.1402
>
>
>

It is supposed to work.

Can you post:
- your engine start line
- your exact CONNECT TO syntax

/steve
--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer


Antonio Arena Posted on 2004-05-04 16:06:27.0Z
From: "Antonio Arena" <antonio.arena@bluserenahotels.it>
Newsgroups: ianywhere.public.general
References: <4088d5ba@forums-2-dub> <Xns94DAB14D8A6F5sricenospamianywhere@10.22.241.106>
Subject: Re: "CONNECT TO" statement
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: host130-152.pool81117.interbusiness.it
Message-ID: <4097bf81@forums-2-dub>
X-Original-Trace: 4 May 2004 09:06:25 -0700, host130-152.pool81117.interbusiness.it
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 May 2004 09:06:26 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 May 2004 09:06:27 -0700
X-Trace: forums-1-dub 1083686787 10.22.108.75 (4 May 2004 09:06:27 -0700)
X-Original-Trace: 4 May 2004 09:06:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3026
Article PK: 6491

Hi Stephen,

the engine is started as a service in Sybase Central. The "Parameter" field
of the "Configuration" folder of the service properties, contains the
following (I leave all the other folders unchanged):

-n CVSERVERTEST
"f:\staging\shmssm\shmssm.db" -n SHMSSMStaging
-c1g
-xtcpip

The syntax that I use is the following:

CONNECT TO cvservertest DATABASE SHMSSMStaging USER dba IDENTIFIED BY sql

Howerver, I tried syntax 2 of the CONNECT statement (CONNECT USING
connect-string) and it works fine. For me, using Syntax 1 or 2 is exactly
the same. So, the problem is solved.
Thank you very much for you reply.

Antonio

"Stephen Rice" <srice_nospam@ianywhere.com> ha scritto nel messaggio
news:Xns94DAB14D8A6F5sricenospamianywhere@10.22.241.106...

> "Antonio Arena" <antonio.arena@bluserenahotels.it> wrote in
> news:4088d5ba@forums-2-dub:
>
> > Hi to all,
> >
> > Up to version 7 of ASA, the "CONNECT TO" statement worked properly
> > when used in iSQL. In version 8, it doesn't work. The same statement
> > that works in ASA 7, generates the error message "Specified database
> > not found" in ASA 8. Is it a real problem or am I missing something?
> > Is there an EBF to fix this?
> >
> > Thank you in advance
> >
> > Antonio
> >
> > ASA 8.0.2.4218
> > ASA 7.0.2.1402
> >
> >
> >
> It is supposed to work.
>
> Can you post:
> - your engine start line
> - your exact CONNECT TO syntax
>
> /steve
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> - Please Post-
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> Developer Community at www.ianywhere.com/developer
>