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.

Very new and need help connecting to server

5 posts in General Discussion Last posting was on 2004-08-31 22:12:52.0Z
Philippe Clérié Posted on 2004-08-25 10:12:19.0Z
Message-ID: <412c6603@forums-1-dub>
From: Philippe Clérié <nospam@hotmail.com>
Subject: Very new and need help connecting to server
Newsgroups: ianywhere.public.general
Reply-To: nospam@hotmail.com
Lines: 40
Organization: Logisys
User-Agent: KNode/0.7.7
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8Bit
NNTP-Posting-Host: adsl-10-194-35.mia.bellsouth.net
X-Original-NNTP-Posting-Host: adsl-10-194-35.mia.bellsouth.net
Date: 25 Aug 2004 03:12:19 -0700
X-Trace: forums-1-dub 1093428739 65.10.194.35 (25 Aug 2004 03:12:19 -0700)
X-Original-Trace: 25 Aug 2004 03:12:19 -0700, adsl-10-194-35.mia.bellsouth.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3423
Article PK: 7327

Hello there,

Until this week-end I had never seen SQL Anywhere. But here I am at
a training session for software requiring it. I have a server
installed and two days into the session I can't get the clients to
connect to the server. (The network is otherwise operational.)

Below is a short description of what I did:

1 - Server side, I started the server with the following commands:

source /opt/sybase/bin/asa_config.sh
/opt/sybase/bin/dbsrv9 -ud /pub/patricia/patricia.db

There are no error messages either on the console or
in /var/log/syslog. netstat output show that the server is
listening on TCP 0.0.0.0:2638 and UDP:0.0.0.0:2638. Presumably the
server is listening on these ports.

/opt/sybase/bin/dblocate outputs:

patricia      localhost.localdomain:2638

There are no firewalls.
I don't have a DNS server working on this network. I'm thinking I
should try putting one.


2 - Client side, both Linux and Windows don't seem to be able to
connect to the server at all.

None of the command line utilities connect to the server. In
particular, I would _expect_ dblocate to locate _all_ the servers
on the network, which of course it does not.

Hope you can help!!!!

Regards
Philippe


Greg Fenton Posted on 2004-08-25 23:29:00.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Very new and need help connecting to server
References: <412c6603@forums-1-dub>
In-Reply-To: <412c6603@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Original-NNTP-Posting-Host: mailext.informatica.com
Message-ID: <412d222c$1@forums-2-dub>
X-Original-Trace: 25 Aug 2004 16:35:08 -0700, mailext.informatica.com
Lines: 37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Aug 2004 16:18:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Aug 2004 16:29:00 -0700
X-Trace: forums-1-dub 1093476540 10.22.108.75 (25 Aug 2004 16:29:00 -0700)
X-Original-Trace: 25 Aug 2004 16:29:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3427
Article PK: 7331


Philippe Clérié wrote:
>
> source /opt/sybase/bin/asa_config.sh
> /opt/sybase/bin/dbsrv9 -ud /pub/patricia/patricia.db

Try outputting the engine's console to some location with the -o flag
(and optionally the -os flag to limit its size):

dbsrv9 -ud -o /var/log/patricia_console.log /pub/patricia/patricia.db

Also, what version of OS/kernel/distro are you using?

>
> 2 - Client side, both Linux and Windows don't seem to be able to
> connect to the server at all.
>
> None of the command line utilities connect to the server. In
> particular, I would _expect_ dblocate to locate _all_ the servers
> on the network, which of course it does not.
>

Can you show us the commands you are trying to use when connecting?
Describe you connection parameters?

BTW: you might want to try posting the the ASA/Linux newsgroup as that's
where us Linux/Unix-heads hang out:

sybase.public.sqlanywhere.linux

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Philippe Clérié Posted on 2004-08-26 23:44:43.0Z
Message-ID: <412e775f@forums-2-dub>
From: Philippe Clérié <nospam@hotmail.com>
Subject: Re: Very new and need help connecting to server
Newsgroups: ianywhere.public.general
Reply-To: nospam@hotmail.com
References: <412c6603@forums-1-dub> <412d222c$1@forums-2-dub>
Lines: 61
Organization: Logisys
User-Agent: KNode/0.7.7
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8Bit
X-Original-NNTP-Posting-Host: adsl-10-194-35.mia.bellsouth.net
X-Original-Trace: 26 Aug 2004 16:50:55 -0700, adsl-10-194-35.mia.bellsouth.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Aug 2004 16:34:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Aug 2004 16:44:43 -0700
X-Trace: forums-1-dub 1093563883 10.22.108.75 (26 Aug 2004 16:44:43 -0700)
X-Original-Trace: 26 Aug 2004 16:44:43 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3442
Article PK: 7350

Thanks for the reply!

But in the meantime I found my answers. Not using a name server on
my test network was the real problem. I started one and that solved
that. (Using the hosts file would have worked too... Probably!)

A Linux client worked using just default entries and the very
minimum data I could get away with. (Remember that before last
week-end I had never seen ASA).

With Windows, I got nowhere. The _Find_ button from the ODBC dialog
would not locate the server. I eventually found the right
combination of parameters to get me going, by specifying the host
address/name to get a connection.

Having said that, Sybase may have a bug in the network code for the
Windows platform. I am using a 172.16.10.0/24 network. But, anytime
I clicked on that _Find_ button, ASA would start firing packets at
172.16.255.255, which of course did not work.

Anyway, tomorrow I'll be 'operational'. Thanks

Philippe Clérié

Greg Fenton wrote:

> Philippe Clérié wrote:
>>
>> source /opt/sybase/bin/asa_config.sh
>> /opt/sybase/bin/dbsrv9 -ud /pub/patricia/patricia.db
>
> Try outputting the engine's console to some location with the -o
> flag (and optionally the -os flag to limit its size):
>
> dbsrv9 -ud -o /var/log/patricia_console.log
> /pub/patricia/patricia.db
>
> Also, what version of OS/kernel/distro are you using?
>
>>
>> 2 - Client side, both Linux and Windows don't seem to be able to
>> connect to the server at all.
>>
>> None of the command line utilities connect to the server. In
>> particular, I would _expect_ dblocate to locate _all_ the servers
>> on the network, which of course it does not.
>>
>
> Can you show us the commands you are trying to use when
> connecting? Describe you connection parameters?
>
> BTW: you might want to try posting the the ASA/Linux newsgroup as
> that's where us Linux/Unix-heads hang out:
>
> sybase.public.sqlanywhere.linux
>
> greg.fenton


Graeme Perrow Posted on 2004-08-27 14:30:28.0Z
From: Graeme Perrow <gperrowNO@SPAMianywhere.PLEASEcom>
Reply-To: gperrowNO@SPAMianywhere.PLEASEcom
Organization: iAnywhere Solutions, Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Very new and need help connecting to server
References: <412c6603@forums-1-dub> <412d222c$1@forums-2-dub> <412e775f@forums-2-dub>
In-Reply-To: <412e775f@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Original-NNTP-Posting-Host: vpn-concord-076.sybase.com
Message-ID: <412f46fb$1@forums-2-dub>
X-Original-Trace: 27 Aug 2004 07:36:43 -0700, vpn-concord-076.sybase.com
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Aug 2004 07:20:13 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Aug 2004 07:30:28 -0700
X-Trace: forums-1-dub 1093617028 10.22.108.75 (27 Aug 2004 07:30:28 -0700)
X-Original-Trace: 27 Aug 2004 07:30:28 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3445
Article PK: 7349


Philippe Clérié wrote:
> Having said that, Sybase may have a bug in the network code for the
> Windows platform. I am using a 172.16.10.0/24 network. But, anytime
> I clicked on that _Find_ button, ASA would start firing packets at
> 172.16.255.255, which of course did not work.

You are absolutely right - there was a bug in the 9.0.0 and 9.0.1
releases where the subnet mask would be ignored when determining the
broadcast address. This was fixed in 9.0.0 build 1289 and 9.0.1 build
1837. You can download the latest EBF (Express Bug Fix) from our
website, which will contain the fix.

Courtesy of Reg's footer:
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL


Graeme Perrow
Senior Software Developer
gperrow@ianywhere.com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/


Philippe Clérié Posted on 2004-08-31 22:12:52.0Z
Message-ID: <4134f7e4@forums-1-dub>
From: Philippe Clérié <nospam@hotmail.com>
Subject: Re: Very new and need help connecting to server
Newsgroups: ianywhere.public.general
Reply-To: nospam@hotmail.com
References: <412c6603@forums-1-dub> <412d222c$1@forums-2-dub> <412e775f@forums-2-dub> <412f46fb$1@forums-2-dub>
Lines: 40
Organization: Logisys
User-Agent: KNode/0.8.0
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8Bit
NNTP-Posting-Host: adsl-10-194-186.mia.bellsouth.net
X-Original-NNTP-Posting-Host: adsl-10-194-186.mia.bellsouth.net
Date: 31 Aug 2004 15:12:52 -0700
X-Trace: forums-1-dub 1093990372 65.10.194.186 (31 Aug 2004 15:12:52 -0700)
X-Original-Trace: 31 Aug 2004 15:12:52 -0700, adsl-10-194-186.mia.bellsouth.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3469
Article PK: 7370

Thanks for the confirmation and the fix. I imagine the fix is
already included in the version I am getting. We just ordered it
and we expect it sometime this week.

Thanks again!
Philippe

Graeme Perrow wrote:

>
> Philippe Clérié wrote:
>> Having said that, Sybase may have a bug in the network code for
>> the Windows platform. I am using a 172.16.10.0/24 network. But,
>> anytime I clicked on that _Find_ button, ASA would start firing
>> packets at 172.16.255.255, which of course did not work.
>
> You are absolutely right - there was a bug in the 9.0.0 and 9.0.1
> releases where the subnet mask would be ignored when determining
> the broadcast address. This was fixed in 9.0.0 build 1289 and
> 9.0.1 build 1837. You can download the latest EBF (Express Bug
> Fix) from our website, which will contain the fix.
>
> Courtesy of Reg's footer:
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
>
> Graeme Perrow
> Senior Software Developer
> gperrow@ianywhere.com
> iAnywhere Solutions Inc.
> A Sybase company
>
> Whitepapers, TechDocs, bug fixes are all available through the
> iAnywhere Developer Community at
> http://www.ianywhere.com/developer/