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.

Unable to get ARC to talk to a Linux ADS Server - Help!

25 posts in Internet Server Last posting was on 2010-05-14 04:36:51.0Z
Ian Branch Posted on 2010-05-06 10:43:39.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
Date: Thu, 6 May 2010 20:43:39 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gttpwz1xul6000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001E8
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.233.151
X-Trace: 6 May 2010 04:41:10 -0700, 118.209.233.151
Lines: 37
Path: solutions.advantagedatabase.com!118.209.233.151
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:807
Article PK: 1121060

Hi Guys,

This is the first time I have tried an internet type connection, let alone a
Linux Server installation.

I have ADS installed on a Linux Server at a remote site. There is a Data
dictionary and associated files installed inthe apprppriate directory in
accordance with the server installation.

The DD has been set for internet connection type.

From my client here, Windows XP, I am running ARC Environment Check Utility
with the connection path set to..

\\xxx.xx.xxx.xxx:6262\DATA DICTIONARY.ADD

Obviously the ip is 'masked' here and its not the correct DD name..

I note the DD is in all capitals however the support files are not. I don't
know if that is an issue or not given Linux' case sensitivity.

Anyway, when I put the path into the Connection path I get a

Connection Failed. Error : 7083
DATE: 05/06/10 TIME: 20:33:29

reported.

According to my associate at the Server end there are error attempts to access
the DD being written to the error log.

I would appreciate any advice/hints as to what I may be doing or have set
wrong, or what to look for.

Regards & TIA,

Ian


Peter Funk (ADS) Posted on 2010-05-06 17:19:19.0Z
Date: Thu, 6 May 2010 17:19:19 +0000 (UTC)
Message-ID: <864d0bcb1bd4c8ccbb251ae545c2@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gttpwz1xul6000@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 6 May 2010 11:16:49 -0700, 10.24.38.185
Lines: 37
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:808
Article PK: 1121061

Hi Ian,

> From my client here, Windows XP, I am running ARC Environment Check
> Utility with the connection path set to..
>
> \\xxx.xx.xxx.xxx:6262\DATA DICTIONARY.ADD
>

6262 is the default LAN port, you need to connect to the INTERNET_PORT.
Make sure you set INTERNET_PORT to a valid (and unused) port in the ads.conf
file (restart ADS if you need to change this). Then use that port number
in your connection string.

> Connection Failed. Error : 7083
> DATE: 05/06/10 TIME: 20:33:29
> reported.
>
> According to my associate at the Server end there are error attempts
> to access the DD being written to the error log.

7083 indicates you tried to connect to a directory (not a data dictionary)
with an internet connection. I'm not sure if the evironment check utility
supports internet connections. I'd suggest using a regular connection (in
the connection repository) or the Remote Server Info (CTRL-R) utility to
test your connection. These will allow you to specifiy the data dictionary,
user name, and password you need to connect to the dictionary.

Finally, the error log on the server should shed some light on why the connection
is failing. If you're having a case sensitivity issue you'll see the path
and OS error code (most likely #2 - "file not found") in the error log.
You should be able to see then what is going wrong. Feel free to post the
error log here or email it to us/me if you're still unsure why it is failing.

Regards,
Peter Funk
Advantage R&D


Ian Branch Posted on 2010-05-07 08:50:40.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gttpwz1xul6000@devzone.advantagedatabase.com> <864d0bcb1bd4c8ccbb251ae545c2@devzone.advantagedatabase.com>
Date: Fri, 7 May 2010 18:50:40 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gtv1hw14tou000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001E9
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.233.151
X-Trace: 7 May 2010 02:48:10 -0700, 118.209.233.151
Lines: 51
Path: solutions.advantagedatabase.com!118.209.233.151
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:809
Article PK: 1121062

Hi Peter,

Thank you for the response.

Peter Funk (ADS) wrote:

> Hi Ian,
> > From my client here, Windows XP, I am running ARC Environment Check
> > Utility with the connection path set to..
> >
> > \\xxx.xx.xxx.xxx:6262\DATA DICTIONARY.ADD
> >
>
> 6262 is the default LAN port, you need to connect to the INTERNET_PORT. Make
> sure you set INTERNET_PORT to a valid (and unused) port in the ads.conf file
> (restart ADS if you need to change this). Then use that port number in your
> connection string.

IB - Done.

>
> > Connection Failed. Error : 7083
> > DATE: 05/06/10 TIME: 20:33:29
> > reported.
> >
> > According to my associate at the Server end there are error attempts
> > to access the DD being written to the error log.
>
> 7083 indicates you tried to connect to a directory (not a data dictionary)
> with an internet connection. I'm not sure if the evironment check utility
> supports internet connections. I'd suggest using a regular connection (in
> the connection repository) or the Remote Server Info (CTRL-R) utility to test
> your connection. These will allow you to specifiy the data dictionary, user
> name, and password you need to connect to the dictionary.

IB Done - I am using the Connection repository. - Now I am getting a "Error
6414: Connection forcefully refused. axServerConnect" Message.


>
> Finally, the error log on the server should shed some light on why the
> connection is failing. If you're having a case sensitivity issue you'll see
> the path and OS error code (most likely #2 - "file not found") in the error
> log. You should be able to see then what is going wrong. Feel free to post
> the error log here or email it to us/me if you're still unsure why it is
> failing.

IB - Waiting for my assocaite to send it to me. He hasn't got home yet....:-)

Regards,

Ian


Ian Branch Posted on 2010-05-07 10:36:29.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gttpwz1xul6000@devzone.advantagedatabase.com> <864d0bcb1bd4c8ccbb251ae545c2@devzone.advantagedatabase.com>
Date: Fri, 7 May 2010 20:36:29 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gtv4b24wydr000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001EA
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.233.151
X-Trace: 7 May 2010 04:34:02 -0700, 118.209.233.151
Lines: 2
Path: solutions.advantagedatabase.com!118.209.233.151
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:810
Article PK: 1121063

email address to send error log to?


Peter Funk (ADS) Posted on 2010-05-07 14:09:53.0Z
Date: Fri, 7 May 2010 14:09:53 +0000 (UTC)
Message-ID: <864d0bcb1bd708ccbbd3cf1db434@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gtv4b24wydr000@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 7 May 2010 08:07:23 -0700, 10.24.38.185
Lines: 9
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:811
Article PK: 1121064

> email address to send error log to?

advantage@ianywhere.com, "ATTN: Peter" in the subject line.

Regards,
Peter Funk
Advantage R&D


Ian Branch Posted on 2010-05-08 06:56:42.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gtv4b24wydr000@devzone.advantagedatabase.com> <864d0bcb1bd708ccbbd3cf1db434@devzone.advantagedatabase.com>
Date: Sat, 8 May 2010 16:56:42 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gtwd1xg9h3l000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001EC
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.233.151
X-Trace: 8 May 2010 00:54:13 -0700, 118.209.233.151
Lines: 2
Path: solutions.advantagedatabase.com!118.209.233.151
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:812
Article PK: 1121065

File sent.


Ian Branch Posted on 2010-05-08 08:22:14.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gtv4b24wydr000@devzone.advantagedatabase.com> <864d0bcb1bd708ccbbd3cf1db434@devzone.advantagedatabase.com>
Date: Sat, 8 May 2010 18:22:14 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gtwfd3jbhcm000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001ED
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.233.151
X-Trace: 8 May 2010 02:19:46 -0700, 118.209.233.151
Lines: 2
Path: solutions.advantagedatabase.com!118.209.233.151
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:813
Article PK: 1121066

Update - Resent and includes ads.conf file from Server.


Peter Funk (ADS) Posted on 2010-05-10 16:45:19.0Z
Date: Mon, 10 May 2010 16:45:19 +0000 (UTC)
Message-ID: <864d0bcb1bdab8ccbe4505018f0c@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gtwfd3jbhcm000@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 10 May 2010 10:42:48 -0700, 10.24.38.185
Lines: 23
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:814
Article PK: 1121067

Got it. The error log contains many failed connection attempts indicative
of bad paths. The 7083 errors are in groups of three with the connection
path, the standardized server-side path, and the client's IP address in the
FileName field of the error log. The server-side path (the second error
in each group) shows the path ADS tried to use to open the data dictionary.
The data dictionary doesn't necessarily need to be in a shared directory.
ADS just needs to have permissions to read/write the files.

Your connection path should contain the server name (or IP), the internet
port, and the path to the dictionary. With Linux the path & dictionary name
must have the correct case too. For example:

\\server:6262\datapath\dictionary.add
\\10.0.0.1:6262\datapath\dictionary.add

With these connection paths, ADS would try to open /datapath/dictionary.add
on the server.

Regards,
Peter Funk
Advantage R&D


Ian Branch Posted on 2010-05-11 08:42:03.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gtwfd3jbhcm000@devzone.advantagedatabase.com> <864d0bcb1bdab8ccbe4505018f0c@devzone.advantagedatabase.com>
Date: Tue, 11 May 2010 18:42:03 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu0nk1sg4x000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001EE
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.233.151
X-Trace: 11 May 2010 02:39:33 -0700, 118.209.233.151
Lines: 26
Path: solutions.advantagedatabase.com!118.209.233.151
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:815
Article PK: 1121068


Peter Funk (ADS) wrote:
>
> Your connection path should contain the server name (or IP), the internet
> port, and the path to the dictionary. With Linux the path & dictionary name
> must have the correct case too. For example:
>
> \\server:6262\datapath\dictionary.add
> \\10.0.0.1:6262\datapath\dictionary.add
>
> With these connection paths, ADS would try to open /datapath/dictionary.add
> on the server.

Hi Peter,

Ah Ha! I think. OK, apparently when my associate installed the ads server on
the linux machine it asked for a/the data path. We interpreted this to mean
that the server knew where the data was and therefore only had to call the dd.

I will advise my associate and getthe data path off him, add it to the
'address' and see how we go.

Will advise.

Regards,

Ian


Ian Branch Posted on 2010-05-11 09:50:26.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gtwfd3jbhcm000@devzone.advantagedatabase.com> <864d0bcb1bdab8ccbe4505018f0c@devzone.advantagedatabase.com>
Date: Tue, 11 May 2010 19:50:26 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu0pcd38dhm001@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001EF
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.233.151
X-Trace: 11 May 2010 03:47:55 -0700, 118.209.233.151
Lines: 13
Path: solutions.advantagedatabase.com!118.209.233.151
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:816
Article PK: 1121070

Hi Peter,

Still no joy. I have checked everything I can think of from case to IP but
cant seem to crack it.

getting a different erro message now though.


I have sent you directly the current error log files.

Regards,

Ian


Ian Branch Posted on 2010-05-11 20:36:46.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gu0pcd38dhm001@devzone.advantagedatabase.com> <864d0bcb1bdd38ccbefed639e5c3@devzone.advantagedatabase.com>
Date: Wed, 12 May 2010 06:36:46 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu1j13vilh000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F0
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 11 May 2010 14:34:16 -0700, 118.209.144.137
Lines: 15
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:818
Article PK: 1121071

Hi Peter,

Thank you very much - Victory!!

When I transferred the files from the Windows drive/directory to the Linux
world they transferred across just as ARC had greated the files. A mixture of
case for the file names, Inconsistant at that. Maybe it should be addressed.

I changed them all to lower case and bingo. We have lift-off!

Thank you very much for your time and support. Appreciated.

Regards,

Ian


Peter Funk (ADS) Posted on 2010-05-11 21:20:26.0Z
Date: Tue, 11 May 2010 21:20:26 +0000 (UTC)
Message-ID: <864d0bcb1bde08ccbf349e2de76d@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gu1j13vilh000@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 11 May 2010 15:17:54 -0700, 10.24.38.185
Lines: 13
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:819
Article PK: 1121072

You're welcome Ian, I'm glad to hear you got it working! As the person who
does most of our Linux testing I can sympathize with you about how much case
sensitivity is a pain. I recently fixed an issue where we appended mixed
case extensions to tables in SQL. The code we use to match the case is only
compiled in our Linux server so if you create a file on Windows the case
may end up mixed. I'll see if I can apply the same fixes to the Windows
server.

Regards,
Peter Funk
Advantage R&D


Ian Branch Posted on 2010-05-12 08:39:40.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gu1j13vilh000@devzone.advantagedatabase.com> <864d0bcb1bde08ccbf349e2de76d@devzone.advantagedatabase.com>
Date: Wed, 12 May 2010 18:39:40 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu222czlfy000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F1
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 12 May 2010 02:37:09 -0700, 118.209.144.137
Lines: 17
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:820
Article PK: 1121073


Peter Funk (ADS) wrote:

> I'll see if I can apply the same fixes to the Windows server.

Hi Peter,

I think the key is consistancy when creating a DD in ARC. Well in my case
anyway. Can't help what people do programaticaly, and perhaps that is where
the server solution may be of more value, but, if ARC was consistant, ie. if
all the DD files created by ARC were upper case, or lower case, perhaps even
selectable as a option, then this issue may not have occured.

Just my 2c.

Regards and thanks again,

Ian


Joachim Duerr (ADS) Posted on 2010-05-12 09:00:26.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gu1j13vilh000@devzone.advantagedatabase.com> <864d0bcb1bde08ccbf349e2de76d@devzone.advantagedatabase.com> <xn0gu222czlfy000@devzone.advantagedatabase.com>
Date: Wed, 12 May 2010 11:00:26 +0200
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 10.56.66.155
Message-ID: <4bea6d94@solutions.advantagedatabase.com>
X-Trace: 12 May 2010 02:57:56 -0700, 10.56.66.155
Lines: 16
Path: solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:821
Article PK: 1121074


Ian Branch wrote:

> I think the key is consistancy when creating a DD in ARC. Well in
>my case anyway. Can't help what people do programaticaly, and
>perhaps that is where the server solution may be of more value, but,
>if ARC was consistant, ie. if all the DD files created by ARC were
>upper case, or lower case, perhaps even selectable as a option, then
>this issue may not have occured.

that's why we introduced LOWERCASE_ALL_PATHS as configuration parameter
for adslinux.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Ian Branch Posted on 2010-05-12 09:26:58.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gu1j13vilh000@devzone.advantagedatabase.com> <864d0bcb1bde08ccbf349e2de76d@devzone.advantagedatabase.com> <xn0gu222czlfy000@devzone.advantagedatabase.com> <4bea6d94@solutions.advantagedatabase.com>
Date: Wed, 12 May 2010 19:26:58 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu23bxwglv000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F3
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 12 May 2010 03:24:36 -0700, 118.209.144.137
Lines: 11
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:822
Article PK: 1121076


Joachim Duerr (ADS) wrote:

>
> that's why we introduced LOWERCASE_ALL_PATHS as configuration parameter
> for adslinux.

Hi Joachim,

Does that include the DD files?

Ian


Joachim Duerr (ADS) Posted on 2010-05-12 09:35:19.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Unable to get ARC to talk to a Linux ADS Server - Help!
Newsgroups: Advantage.Internet_Server
References: <xn0gu1j13vilh000@devzone.advantagedatabase.com> <864d0bcb1bde08ccbf349e2de76d@devzone.advantagedatabase.com> <xn0gu222czlfy000@devzone.advantagedatabase.com> <4bea6d94@solutions.advantagedatabase.com> <xn0gu23bxwglv000@devzone.advantagedatabase.com>
Date: Wed, 12 May 2010 11:35:19 +0200
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 10.56.66.155
Message-ID: <4bea75c0@solutions.advantagedatabase.com>
X-Trace: 12 May 2010 03:32:48 -0700, 10.56.66.155
Lines: 10
Path: solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:823
Article PK: 1121075


Ian Branch wrote:

> Does that include the DD files?

yes.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Ian Branch Posted on 2010-05-12 10:16:29.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu1j13vilh000@devzone.advantagedatabase.com> <864d0bcb1bde08ccbf349e2de76d@devzone.advantagedatabase.com>
Date: Wed, 12 May 2010 20:16:29 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu24ni2o4ik001@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F4
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 12 May 2010 04:13:57 -0700, 118.209.144.137
Lines: 35
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:824
Article PK: 1121077

Sorry Peter. Me again...I thought we had it cracked.

Set up a TAdsConnection as follows..
AdsServerTyoes to stADS_AIS. Tried stADS_REMOTE with the same result.
CommunicationType = ctAdsTCPIP.
ConnectPath = Copied the ConnectPath directly from ARC.
LoginPrompt = False.
Password is blank.

All other Properties for TAdsConnection are default.

When I try to set IsConnected to True there is a very brief pause and I get a
6414 error dialog.

I see no apparent internet activity on my router and nothing appears in the
Log from the remote end.

Delphi 2010, ADS 9.10.

I tried a clean project with just a TAdsConnection on it with the same result.

Have I missed or incorrectly set something? Is it possible the ADS server
installed on my machine is getting in the road? I thought it might have been
the router but ARC is working so i reason the app should.

Any thoughts/suggestions greatfully accepted.

Regards,

Ian


Peter Funk (ADS) Posted on 2010-05-12 15:09:14.0Z
Date: Wed, 12 May 2010 15:09:14 +0000 (UTC)
Message-ID: <864d0bcb1be028ccbfc9ed2606cc@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu24ni2o4ik001@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 12 May 2010 09:06:42 -0700, 10.24.38.185
Lines: 24
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:825
Article PK: 1121079

Hmm, that's a strange one. I've never seen that error and I don't think
it is very common. It most likely translates to a WSAECONNREFUSED (10061)
winsock error described as "No connection could be made because the target
machine actively refused it. This usually results from trying to connect
to a service that is inactive on the foreign host-that is, one with no server
application running."

Using ADS 10.0 and Delphi 7 I successfully made an internet connection to
our linux server using the settings you described. The one thing I changed
was setting the Username property of the TAdsConnection object. You'll need
to do that too if you're setting LoginPrompt to false. I suspect you've
already set that otherwise you'd get a different error.

My first suggestion is to use a different communication type. Try using
ctAdsUDPIP or ctAdsDefault and see if anything changes. Some other things
to check are your local firewall (maybe it has an exception for arc32.exe
but not Delphi?) and also your ads.ini file (maybe arc32.exe has an ads.ini
file with some settings but Delphi isn't finding it?). I'll ask around and
see if anyone else knows about 6414 errors.

Regards,
Peter


Ian Branch Posted on 2010-05-12 20:31:48.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu24ni2o4ik001@devzone.advantagedatabase.com> <864d0bcb1be028ccbfc9ed2606cc@devzone.advantagedatabase.com>
Date: Thu, 13 May 2010 06:31:48 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu2xh4yi6b001@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F6
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 12 May 2010 14:29:18 -0700, 118.209.144.137
Lines: 42
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:826
Article PK: 1121078


Peter Funk (ADS) wrote:

> Hmm, that's a strange one. I've never seen that error and I don't think it
> is very common.

Did see it a couple of times when I was first trying with ARC.
> It most likely translates to a WSAECONNREFUSED (10061)
> winsock error described as "No connection could be made because the target
> machine actively refused it. This usually results from trying to connect to a
> service that is inactive on the foreign host-that is, one with no server
> application running."

Hmmm. Perhaps. The fact that I see absolutely no apparent activity on the
router leads me to believe it may be something internal with my PC.
>
> Using ADS 10.0 and Delphi 7 I successfully made an internet connection to our
> linux server using the settings you described. The one thing I changed was
> setting the Username property of the TAdsConnection object. You'll need to
> do that too if you're setting LoginPrompt to false. I suspect you've already
> set that otherwise you'd get a different error.

Yep.
>
> My first suggestion is to use a different communication type. Try using
> ctAdsUDPIP or ctAdsDefault and see if anything changes.
> Some other things to check are your local firewall (maybe it has an exception
for arc32.exe but
> not Delphi?)
> and also your ads.ini file (maybe arc32.exe has an ads.ini file
> with some settings but Delphi isn't finding it?).

I will try/test each of these and advise.
> I'll ask around and see if anyone else knows about 6414 errors.

Thanks Peter.

So close.....:-)

Regards,

Ian


Peter Funk (ADS) Posted on 2010-05-12 21:40:47.0Z
Date: Wed, 12 May 2010 21:40:47 +0000 (UTC)
Message-ID: <864d0bcb1be1a8ccc000a089fec4@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu2xh4yi6b001@devzone.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 12 May 2010 15:38:15 -0700, 10.24.38.185
Lines: 9
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:827
Article PK: 1121080

I asked around our group and the only situation we've (at least recently)
seen that error is when the port number was incorrect. The connection path
w/ the port number is the most likely place for a problem, so I'd recommend
double checking it. You might also try using the server's IP address instead
of its name - although I thought you were already using the IP address...

Peter


Ian Branch Posted on 2010-05-13 08:15:33.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu2xh4yi6b001@devzone.advantagedatabase.com> <864d0bcb1be1a8ccc000a089fec4@devzone.advantagedatabase.com>
Date: Thu, 13 May 2010 18:15:33 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu3g1c1clqg000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F7
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 13 May 2010 02:13:02 -0700, 118.209.144.137
Lines: 28
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:828
Article PK: 1121081


Peter Funk (ADS) wrote:

> You might also try using the server's IP address instead of its name -
lthough I thought you were already using the IP address...
>

Hi Peter,

I am. Some success. Per your suggestion I changed the CommunicationType to
ctAdsDefault.

Your not going to believe this...Now it gives me a "Error 6316: The Advantage
server version is older than the Advantage client version. The Advantage server
must be the same version or newer than the Advantage client. The server is
older than the client.". And its correct.

The client components are 9.10.0.15 and via ARC the Linux version of the
server is 9.10.0.9. Can't take a trick here. 9.10.0.9 is the same version as
the Windows server I am running on my PC and it works fine.

Do I try to find 9.10.0.9 versions of the components or a 9.10.0.15 linux
version of the server??

Sigh.

Regards,

Ian


Joachim Duerr (ADS) Posted on 2010-05-13 10:54:28.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu2xh4yi6b001@devzone.advantagedatabase.com> <864d0bcb1be1a8ccc000a089fec4@devzone.advantagedatabase.com> <xn0gu3g1c1clqg000@devzone.advantagedatabase.com>
Date: Thu, 13 May 2010 12:54:28 +0200
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 84.158.179.39
Message-ID: <4bebd9cd@solutions.advantagedatabase.com>
X-Trace: 13 May 2010 04:51:57 -0700, 84.158.179.39
Lines: 24
Path: solutions.advantagedatabase.com!84.158.179.39
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:829
Article PK: 1121082


Ian Branch wrote:

> Your not going to believe this...Now it gives me a "Error 6316: The
>Advantage server version is older than the Advantage client version.
>The Advantage server must be the same version or newer than the
>Advantage client. The server is older than the client.". And its
>correct.
>
> The client components are 9.10.0.15 and via ARC the Linux version of
>the server is 9.10.0.9. Can't take a trick here. 9.10.0.9 is the
>same version as the Windows server I am running on my PC and it works
>fine.
>
> Do I try to find 9.10.0.9 versions of the components or a 9.10.0.15
>linux version of the server??

if your server is 9.1.x.x and your client engine DLLs are 9.1.x.x then
you won't get that error. Either your server is older (9.0, 8.1, ...)
or your application loades ADS 10 beta DLLs.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Ian Branch Posted on 2010-05-13 11:36:06.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu2xh4yi6b001@devzone.advantagedatabase.com> <864d0bcb1be1a8ccc000a089fec4@devzone.advantagedatabase.com> <xn0gu3g1c1clqg000@devzone.advantagedatabase.com> <4bebd9cd@solutions.advantagedatabase.com>
Date: Thu, 13 May 2010 21:36:06 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu3lab8iijx000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F8
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 13 May 2010 05:33:35 -0700, 118.209.144.137
Lines: 16
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:830
Article PK: 1121083


Joachim Duerr (ADS) wrote:

>
> if your server is 9.1.x.x and your client engine DLLs are 9.1.x.x then
> you won't get that error. Either your server is older (9.0, 8.1, ...)
> or your application loades ADS 10 beta DLLs.

Hi Joachim,

Hmmm. Confident in the Linux end, it has only ever had the one installation.

I will do a scan for a*32.dll on my PC and see what I can find.

Regards,

Ian


Ian Branch Posted on 2010-05-14 04:36:51.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Arrgghh!! So close I can taste it...
Newsgroups: Advantage.Internet_Server
References: <xn0gu2xh4yi6b001@devzone.advantagedatabase.com> <864d0bcb1be1a8ccc000a089fec4@devzone.advantagedatabase.com> <xn0gu3g1c1clqg000@devzone.advantagedatabase.com> <4bebd9cd@solutions.advantagedatabase.com>
Date: Fri, 14 May 2010 14:36:51 +1000
User-Agent: XanaNews/1.19.1.269
Message-ID: <xn0gu4ot5fvbxq000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001F9
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 118.209.144.137
X-Trace: 13 May 2010 22:34:20 -0700, 118.209.144.137
Lines: 12
Path: solutions.advantagedatabase.com!118.209.144.137
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:831
Article PK: 1121084

Peter & Joachim,

All sorted. v 10 Beta files were causing havoc. Took some time to weed them
out and restore 'connection' to v 9.

All fine now.

Thanks again for your timely and inciteful assistance.

Regards,

Ian