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.

Network Database Connection Issues

2 posts in General Discussion Last posting was on 2004-07-12 03:58:24.0Z
deepak bajaj Posted on 2004-07-09 19:18:54.0Z
Sender: 4bdb.40eee9ab.1804289383@sybase.com
From: deepak bajaj
Newsgroups: ianywhere.public.general
Subject: Network Database Connection Issues
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40eeef9e.4c4d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jul 2004 12:18:54 -0700
X-Trace: forums-1-dub 1089400734 10.22.241.41 (9 Jul 2004 12:18:54 -0700)
X-Original-Trace: 9 Jul 2004 12:18:54 -0700, 10.22.241.41
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3255
Article PK: 6708

Hi there,
I am trying to connect to a sybase database ASE 12.5 from a
win2K machine with iAnywhere sybase central 9.0.1.

Strange thing is I am able to use the interactive SQL
without hiccups and am able to connect to sybase server, but
only the sybase central refuses to load up the server.

I use following to validate the connection.
d:\sybase\studio\win32\dbping -z -d -o c:\temp\junk.log
-c"uid=g9udab;pwd=abcd;eng=DSTRUCT01;dbn=bondAdmAcct;LINKS=tcpip(DOBROADCAST=DIRECT;
IP=DSTRUCT01:5001)"
Needless to say
Servername is : DSTRUCT01DS1
Host Name is : DSTRUCT01
PORT is: 5001
Windows desktop and sybase ASE are in different subnets,
and that is why I am using the DOBROADCAST=DIRECT (also
tried NONE with same results).
The conents of the log file are as below.
Adaptive Server Anywhere Server Ping Utility Version
9.0.1.1751
Application information:
"HOST=G9UJZS-PC;OS=Windows 2000 Build 2195 Service Pack
4;PID=0x8a0;THREAD=0x2f8;EXE=D:\sybase\studio\win32\dbping.exe;
VERSION=9.0.1.1751;API=DBLIB;TIMEZONEADJUSTMENT=-240"
Attempting to connect using:
UID=g9udab;PWD=********;ENG=DSTRUCT01DS1;DSN=devSybase;LINKS=TCPIP(DOBROADCAST=DIRECT;
IP=DSTRUCT01:5001)
Attempting to connect to a running server...
Trying to start TCPIP link ...

Loading wsock32.dll
Loading ws2_32.dll
TCP using Winsock version 2.0
My IP address is 172.21.99.115
My IP address is 127.0.0.1
TCPIP link started successfully

Attempting TCPIP connection (no asasrv.ini cached address)

Looking for server with name dstruct01ds1
Trying to find server at address DSTRUCT01:5001
Found server, verifying server name
TCP/IP link, function recv(), error code 0
Not performing a broadcast
Resending
Resending
Resending
Resending
Server not found (no reply received)
Failed to connect over TCPIP

Not attempting to autostart server
Cannot connect to server
Ping database failed -- Database server not found.


Nick Elson Posted on 2004-07-12 03:58:24.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <40eeef9e.4c4d.1681692777@sybase.com>
Subject: Re: Network Database Connection Issues
Lines: 84
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: vpn-concord-090.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-090.sybase.com
Message-ID: <40f20c60$1@forums-1-dub>
Date: 11 Jul 2004 20:58:24 -0700
X-Trace: forums-1-dub 1089604704 158.159.8.90 (11 Jul 2004 20:58:24 -0700)
X-Original-Trace: 11 Jul 2004 20:58:24 -0700, vpn-concord-090.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3257
Article PK: 6712

You need TDS connectivity to talk with an ASE server.
For Sybase Central, that means you MUST USE the
ASE plug-in. That may not be compatible with the
SCJView viewer that comes with ASA 9.0.x but that
is not a subject for this newsgroup.

Tools like dbping, dblocate, and the ASA plug-in (among
others) do not understand TDS at all. They use the ASA
'native' CMD/SEQ protocol that only the ASA servers
support. So do not expect the to be of much use to you
with ASE. They were never written with ASE in mind.

The only reason DBISQL[g] appears to work is because
your are using JConnect to do so. JConnect 'speaks'
TDS, but that does no may the DBISQL/ASE marriage
something that is going to be useful or of any great value.
Expect a bumpy honeymoon and an early divorce.

Switch over to the ASE plug-in and tools (including
Open Client ISQL, DSEDIT and OCSCFG) and
the JConnect utilities (including JISQL).

<deepak bajaj> wrote in message news:40eeef9e.4c4d.1681692777@sybase.com...
> Hi there,
> I am trying to connect to a sybase database ASE 12.5 from a
> win2K machine with iAnywhere sybase central 9.0.1.
>
> Strange thing is I am able to use the interactive SQL
> without hiccups and am able to connect to sybase server, but
> only the sybase central refuses to load up the server.
>
> I use following to validate the connection.
> d:\sybase\studio\win32\dbping -z -d -o c:\temp\junk.log
> -c"uid=g9udab;pwd=abcd;eng=DSTRUCT01;dbn=bondAdmAcct;LINKS=tcpip(DOBROADCA
ST=DIRECT;
> IP=DSTRUCT01:5001)"
> Needless to say
> Servername is : DSTRUCT01DS1
> Host Name is : DSTRUCT01
> PORT is: 5001
> Windows desktop and sybase ASE are in different subnets,
> and that is why I am using the DOBROADCAST=DIRECT (also
> tried NONE with same results).
> The conents of the log file are as below.
> Adaptive Server Anywhere Server Ping Utility Version
> 9.0.1.1751
> Application information:
> "HOST=G9UJZS-PC;OS=Windows 2000 Build 2195 Service Pack
> 4;PID=0x8a0;THREAD=0x2f8;EXE=D:\sybase\studio\win32\dbping.exe;
> VERSION=9.0.1.1751;API=DBLIB;TIMEZONEADJUSTMENT=-240"
> Attempting to connect using:
>

UID=g9udab;PWD=********;ENG=DSTRUCT01DS1;DSN=devSybase;LINKS=TCPIP(DOBROADCA
ST=DIRECT;
> IP=DSTRUCT01:5001)
> Attempting to connect to a running server...
> Trying to start TCPIP link ...
>
> Loading wsock32.dll
> Loading ws2_32.dll
> TCP using Winsock version 2.0
> My IP address is 172.21.99.115
> My IP address is 127.0.0.1
> TCPIP link started successfully
>
> Attempting TCPIP connection (no asasrv.ini cached address)
>
> Looking for server with name dstruct01ds1
> Trying to find server at address DSTRUCT01:5001
> Found server, verifying server name
> TCP/IP link, function recv(), error code 0
> Not performing a broadcast
> Resending
> Resending
> Resending
> Resending
> Server not found (no reply received)
> Failed to connect over TCPIP
>
> Not attempting to autostart server
> Cannot connect to server
> Ping database failed -- Database server not found.