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.

6420 in application but not ARC

2 posts in Networking Last posting was on 2008-01-26 19:54:30.0Z
Chris Brown Posted on 2008-01-26 17:56:36.0Z
From: "Chris Brown" <cjb@ojwatch.com>
Newsgroups: Advantage.Networking
Subject: 6420 in application but not ARC
Date: Sat, 26 Jan 2008 17:56:36 -0000
Lines: 130
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: 217.169.16.177
Message-ID: <479b730b@solutions.advantagedatabase.com>
X-Trace: 26 Jan 2008 10:51:07 -0700, 217.169.16.177
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.169.16.177
Xref: solutions.advantagedatabase.com Advantage.Networking:738
Article PK: 1132157

I am testing a new application in Delphi2007 under XP fully updated in an
MSVirtual machine. At design time using the AdsConnection component and also
using ARC8.1 I can connect to the database without problem. I have been
using this environment for some time without any problems. (Remote DB is
8.1)

This evening, for some reason I cannot see, when I run the application, the
first Connection.Connect call fails with a 6420. (ARC still works at this
point) and back in design mode, the TAdsConnection component connects
without problem. I am appending an edited ADSCOM.TXT with multiple repeated
lines removed.

Here are relevant parts of ADS.INI
[SETTINGS]
COMMCALLTRACE=1
RETRY_ADS_CONNECTS=1
LAN_PORT=2001
LAN_IP=192.168.47.253
[K2OJEC_info]
COMMCALLTRACE=1
ServerType=remote
LockingMode=proprietary
CharType=ansi
SecurityMode=ignorerights
ShowDeleted=yes
DBFTableType=cdx
Username=AdsSys
BlankPassword=no
BackupDestination=
RestoreDestination=
ExpandedNodes=TABLES;VIEWS;LINKS;
CommunicationType=default
TableType=adt
SchemaTemplatesLocation=\\hatshepsut\database\K2OJEC\Temp\
[Databases]
K2OJEC=\\hatshepsut\database\k2OJEC\k2OJEC.add;D


I am a loss to know what to look for!!!

>>>Edited ADSCOM.TXT
1.857 1504 WIN32 32-bit Windows comm dll version : 8.10.0.18
2.453 1504 Special Build : BD0733a
2.837 1504 WSCOMM32 Winsock 32-bit dll
3.128 1504 Start ____axCommInit____
12.910 1504 End ____axCommInit____SUCCESS
14.874 1504 Start ____axConnect81____
15.245 1504 axConnect81 - pucServerName : hatshepsut
15.549 1504 axConnect81 - Connection Type : 2 Hex: 0x00000002
15.913 1504 axConnect81 - !usFoundViaWS
16.203 1504 Start ____AdsIsLocal____ Server Name: : hatshepsut
16.513 1504 Start ____GetAddressFromSharedMemory____
16.912 1504 Start ____OpenIPCSharedMem____
17.256 1504 End ____OpenIPCSharedMem____ - OpenFileMapping returned:
: 2 Hex: 0x00000002
17.932 1504 End ____GetAddressFromSharedMemory____ - failed to find
shared memory
18.188 1504 End ____AdsIsLocal____ Result: : 0 Hex: 0x00000000
18.469 1504 Start ____WSFindAdvantage81____
18.735 1504 Start ____GetRemoteAddress____
23.093 1504 Start ____QuickDiscovery____
23.385 1504 Start ____ServerNameHasAddr____ : hatshepsut
23.640 1504 End ____ServerNameHasAddr____ Server name does not have a
port value
24.010 1504 Start ____GetAddressFromSharedMemory____
24.283 1504 Start ____OpenIPCSharedMem____
24.567 1504 End ____OpenIPCSharedMem____ - OpenFileMapping returned:
: 2 Hex: 0x00000002
24.899 1504 End ____GetAddressFromSharedMemory____ - failed to find
shared memory
25.871 1504 QuickDiscovery - pstSin->sin_port == 0
97.496 1476 Start ____MailSlotDiscoveryThread____
98.826 1476 MailSlotDiscoveryThread - CreateMailslot SUCCEEDED : 203
Hex: 0x000000CB
130.694 336 Start ____MulticastDiscoveryThread____
286.923 1972 Start ____SAPDiscoveryThread____
342.861 336 MulticastDiscoveryThread - sendto SUCCEEDED
344.001 336 MulticastDiscoveryThread - recvfrom FAILED
345.695 336 MulticastDiscoveryThread - recvfrom FAILED
... repeats until
681.577 336 MulticastDiscoveryThread - recvfrom FAILED
684.656 336 MulticastDiscoveryThread - sendto SUCCEEDED
685.361 336 MulticastDiscoveryThread - recvfrom FAILED
...repeats until
793.964 336 MulticastDiscoveryThread - recvfrom FAILED
794.948 1972 ____Start OpenAndBindSocket IPX Socket____
795.268 1972 socket creation FAILED
795.521 1972 ____MapWinsockRetCode____
795.896 1972 WSAGetLastError : 10047 Hex: 0x0000273F
796.152 1972 ____SAPDiscoveryThread____ - IPX OpenAndBindSocket
FAILED -- NO SAPPING will occur : 6409 Hex: 0x00001909
796.444 1972 SAPDiscoveryThread____FAILED (no IPX socket available)
831.322 336 MulticastDiscoveryThread - recvfrom FAILED
...repeats until
1020.212 336 MulticastDiscoveryThread - recvfrom FAILED
1036.981 336 MulticastDiscoveryThread - sendto SUCCEEDED
1038.182 336 MulticastDiscoveryThread - recvfrom FAILED
1039.224 336 MulticastDiscoveryThread - recvfrom FAILED
... repeats until
1370.184 336 MulticastDiscoveryThread - recvfrom FAILED
1379.808 336 MulticastDiscoveryThread - sendto SUCCEEDED
1380.499 336 MulticastDiscoveryThread - recvfrom FAILED
... repeats until
1718.451 336 MulticastDiscoveryThread - recvfrom FAILED
1734.223 336 MulticastDiscoveryThread - sendto SUCCEEDED
1735.580 336 MulticastDiscoveryThread - recvfrom FAILED
...repeats until
2069.711 336 MulticastDiscoveryThread - recvfrom FAILED
2073.198 336 MulticastDiscoveryThread - sendto SUCCEEDED
2074.106 336 MulticastDiscoveryThread - recvfrom FAILED
... repeats until
2414.030 336 MulticastDiscoveryThread - recvfrom FAILED
2416.843 336 MulticastDiscoveryThread____FAILED
4935.459 1476 MailSlotDiscoveryThread - WriteFile FAILED : 53 Hex:
0x00000035
4936.622 1476 MailSlotDiscoveryThread____FAILED
4959.228 1504 GetRemoteAddress____FAILED
4959.567 1504 WSFindAdvantage81 - GetRemoteAddress FAILED or
ucFoundAdsAddr(0 means mailslot or multicast found ADS address) : 6420 Hex:
0x00001914
4959.892 1504 axConnect81 - WSFindAdvantage FAILED : 6420 Hex:
0x00001914
4960.418 1504 Start ____axSystemReq____ : 120 Hex: 0x00000078
4960.695 1504 axSystemReq - Send packet from axSystemReq
4961.032 1504 ____MapWinsockRetCode____
4961.307 1504 WSAGetLastError : 10038 Hex: 0x00002736

Chris Brown


Chris Brown Posted on 2008-01-26 19:54:30.0Z
From: "Chris Brown" <cjb@ojwatch.com>
Newsgroups: Advantage.Networking
References: <479b730b@solutions.advantagedatabase.com>
Subject: Re: 6420 in application but not ARC
Date: Sat, 26 Jan 2008 19:54:30 -0000
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: 217.169.16.177
Message-ID: <479b8eb0@solutions.advantagedatabase.com>
X-Trace: 26 Jan 2008 12:49:04 -0700, 217.169.16.177
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!217.169.16.177
Xref: solutions.advantagedatabase.com Advantage.Networking:739
Article PK: 1132158


"Chris Brown" <cjb@ojwatch.com> wrote in message
news:479b730b@solutions.advantagedatabase.com...
> I am testing a new application in Delphi2007 under XP fully updated in an
> MSVirtual machine. At design time using the AdsConnection component and
also
> using ARC8.1 I can connect to the database without problem. I have been
> using this environment for some time without any problems. (Remote DB is
> 8.1)
>
> This evening, for some reason I cannot see, when I run the application,
the
> first Connection.Connect call fails with a 6420. (ARC still works at this
> point) and back in design mode, the TAdsConnection component connects
> without problem. >

Progress!!!

I had also installed AltovaXML since the last succesful execution. This
appears to have silently modified the firewall settings. CodeGear RADSTUDIO
had originally been permitted all access which could explain the difference
between design and debug behaviour, but in any case all access via subnet
192.168.47 was permitted. However, having opened up the firewall settings to
look at them under administrator, it is all working again back under the
more restricted user, although I have not introduced any changes.

Chris Brown