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
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
"HOST=G9UJZS-PC;OS=Windows 2000 Build 2195 Service Pack
Attempting to connect using:
Attempting to connect to a running server...
Trying to start TCPIP link ...
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
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.
From: deepak bajaj
Subject: Network Database Connection Issues
X-Mailer: WebNews to Mail Gateway v1.1t
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
Xref: forums-1-dub ianywhere.public.general:3255
Article PK: 6708
Subject: Re: Network Database Connection Issues
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Date: 11 Jul 2004 20:58:24 -0700
X-Trace: forums-1-dub 1089604704 126.96.36.199 (11 Jul 2004 20:58:24 -0700)
X-Original-Trace: 11 Jul 2004 20:58:24 -0700, vpn-concord-090.sybase.com
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).
> 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
> 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.