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.

Clarification needed please.

15 posts in Networking Last posting was on 2009-09-14 10:23:35.0Z
Ian Branch Posted on 2009-08-30 05:15:44.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Clarification needed please.
Newsgroups: Advantage.Networking
Date: Sun, 30 Aug 2009 15:15:44 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0geiupi14a5a000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:0000018F
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.161.80
X-Trace: 29 Aug 2009 23:14:29 -0700, 218.215.161.80
Lines: 37
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.161.80
Xref: solutions.advantagedatabase.com Advantage.Networking:889
Article PK: 1132301

Hi Guys,

I have a configuration on a customers machine that looks like the following...

[192.168.x.y]

LAN_IP= 192.168.x.y
LAN_PORT=6262
[databases]
DBFData=W:\DBFData.add;D
[DBFData_info]
Username=AdsSys
ServerType=remote
CommunicationType=default
TableType=adt
LockingMode=compatible
CharType=oem
SecurityMode=ignorerights
DBFTableType=cdx
BlankPassword=no
BackupDestination=
RestoreDestination=
ExpandedNodes=
SchemaTemplatesLocation=

My question is, if the IP & Port are set, and the ServerType is Remote, why is
the "DBFData=W:\DBFData.add;D" seemingly required?

I would have thought that if operating remote via IP, by default a drive is not
directly available.

What has been missed?

Regards,

Ian


Joachim Duerr (ADS) Posted on 2009-08-30 21:50:51.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com>
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.128.132
Message-ID: <4a9ae62b@solutions.advantagedatabase.com>
Date: 30 Aug 2009 14:50:51 -0700
X-Trace: 30 Aug 2009 14:50:51 -0700, 84.158.128.132
Lines: 16
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.158.128.132
Xref: solutions.advantagedatabase.com Advantage.Networking:890
Article PK: 1132300


Ian Branch wrote:

>My question is, if the IP & Port are set, and the ServerType is
>Remote, why is the "DBFData=W:\DBFData.add;D" seemingly required?
>
>I would have thought that if operating remote via IP, by default a
>drive is not directly available.

this is just an alias which was set up in ARC (DBFData_Info section
just defines the connection properties for the repository in arc). It
is not required...

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


Ian Branch Posted on 2009-08-31 06:38:34.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com>
Date: Mon, 31 Aug 2009 16:38:34 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0gekbf59exjn000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:00000190
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.181.73
X-Trace: 31 Aug 2009 00:37:18 -0700, 218.215.181.73
Lines: 33
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.181.73
Xref: solutions.advantagedatabase.com Advantage.Networking:891
Article PK: 1132302


Joachim Duerr (ADS) wrote:

> Ian Branch wrote:
>
> > My question is, if the IP & Port are set, and the ServerType is
> > Remote, why is the "DBFData=W:\DBFData.add;D" seemingly required?
> >
> > I would have thought that if operating remote via IP, by default a
> > drive is not directly available.
>
> this is just an alias which was set up in ARC (DBFData_Info section
> just defines the connection properties for the repository in arc). It
> is not required...

Hi Joachim,

So, if it is not required, then the W: drive doesn't/shouldn't need to be
visible/mapped to the client for ARC to work via ADS to the DD?

And if the above is correct, what should this "W:\DBFData.add;D" be? Just
"DBFData.add;D"?

I guess I'm trying to understand how this works.

Regards,

Ian







Joachim Duerr (ADS) Posted on 2009-08-31 08:42:34.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com>
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: <4a9b7eea@solutions.advantagedatabase.com>
Date: 31 Aug 2009 01:42:34 -0700
X-Trace: 31 Aug 2009 01:42:34 -0700, 10.56.66.155
Lines: 23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.Networking:892
Article PK: 1132303


Ian Branch wrote:

> So, if it is not required, then the W: drive doesn't/shouldn't need
>to be visible/mapped to the client for ARC to work via ADS to the DD?
>
> And if the above is correct, what should this "W:\DBFData.add;D" be?
>Just "DBFData.add;D"?
>
> I guess I'm trying to understand how this works.

ARC uses the ALias to connect ... this gets resolved to your W drive.
If you don't want to use a drive, just replace the connection to

[databases]
DBFData=\\192.168.x.y:6262\anyshare\DBFData.add;D

For your application, you can either use the path directly or use the
alias defined in the ads.ini (only for Delphi apps!).

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


Ian Branch Posted on 2009-08-31 08:48:18.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com>
Date: Mon, 31 Aug 2009 18:48:18 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0geketlvmsj000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:00000191
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.181.73
X-Trace: 31 Aug 2009 02:47:02 -0700, 218.215.181.73
Lines: 36
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.181.73
Xref: solutions.advantagedatabase.com Advantage.Networking:893
Article PK: 1132304


Joachim Duerr (ADS) wrote:

> Ian Branch wrote:
>
> > So, if it is not required, then the W: drive doesn't/shouldn't need
> > to be visible/mapped to the client for ARC to work via ADS to the DD?
> >
> > And if the above is correct, what should this "W:\DBFData.add;D" be?
> > Just "DBFData.add;D"?
> >
> > I guess I'm trying to understand how this works.
>
> ARC uses the ALias to connect ... this gets resolved to your W drive.
> If you don't want to use a drive, just replace the connection to
>
> [databases]
> DBFData=\\192.168.x.y:6262\anyshare\DBFData.add;D
>
> For your application, you can either use the path directly or use the
> alias defined in the ads.ini (only for Delphi apps!).

Hi Joachim,

I'm guessing 'anyshare' is not a literal and in this case the string would be..

> [databases]
> DBFData=\\192.168.x.y:6262\w:\DBFData.add;D

Assuming w: was the actual W: on the Server machine.

Ahhh. And I'm guessing that w: has to be shared on the Server but doesn't have
to be mapped to the client?

Regards and thanks for your time and advice.

Ian


Joachim Duerr (ADS) Posted on 2009-08-31 21:20:50.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com>
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.164.254
Message-ID: <4a9c30a2@solutions.advantagedatabase.com>
Date: 31 Aug 2009 14:20:50 -0700
X-Trace: 31 Aug 2009 14:20:50 -0700, 84.158.164.254
Lines: 15
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.158.164.254
Xref: solutions.advantagedatabase.com Advantage.Networking:895
Article PK: 1132305


Ian Branch wrote:

>Assuming w: was the actual W: on the Server machine.

you can always use an administrative share (w$ in this case)

>Ahhh. And I'm guessing that w: has to be shared on the Server but
>doesn't have to be mapped to the client?

yes. Or you can remap it using serverside alias definitions;)

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


Ian Branch Posted on 2009-08-31 23:15:53.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com>
Date: Tue, 1 Sep 2009 09:15:53 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0gemsxm391ne000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:00000192
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.181.73
X-Trace: 31 Aug 2009 17:14:40 -0700, 218.215.181.73
Lines: 49
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.181.73
Xref: solutions.advantagedatabase.com Advantage.Networking:896
Article PK: 1132306


Joachim Duerr (ADS) wrote:

> Ian Branch wrote:
>
> > Assuming w: was the actual W: on the Server machine.
>
> you can always use an administrative share (w$ in this case)
>
> > Ahhh. And I'm guessing that w: has to be shared on the Server but
> > doesn't have to be mapped to the client?
>
> yes. Or you can remap it using serverside alias definitions;)

HI Joachim,

OK, If I understand you correctly, I now have the following in ads.ini..

[192.168.0.2]
LAN_IP= 192.168.0.2
LAN_PORT=6262
[databases]
DBFData=\\192.168.0.2:6262\W$\DBFData.add;D
[DBFData_info]
Username=AdsSys
ServerType=remote
CommunicationType=default
TableType=cdx
LockingMode=compatible
CharType=oem
SecurityMode=ignorerights
DBFTableType=cdx
BlankPassword=no
BackupDestination=
RestoreDestination=
ExpandedNodes=
SchemaTemplatesLocation=

When I open ARC and attempt to connect/Open DBFData It correctly asks me for
the password but when i enter the password, the same as when set up as
"DBFData=w:\DBFData.add;D" I get "Error 7078: The Advantage Database Server
cannot authenticate the user. Make sure the user name and password are
correct. axServerConnect

This suggests to me it seems to have found the DBFData.add DD but something
else is amiss. Yes/No?

Regards,

Ian


Joachim Duerr (ADS) Posted on 2009-09-01 08:10:22.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com> <xn0gemsxm391ne000@devzone.advantagedatabase.com>
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: <4a9cc8de@solutions.advantagedatabase.com>
Date: 1 Sep 2009 01:10:22 -0700
X-Trace: 1 Sep 2009 01:10:22 -0700, 10.56.66.155
Lines: 44
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.Networking:897
Article PK: 1132308

following is enough (ip and port are already defined in the connection
string):

> [databases]
> DBFData=\\192.168.0.2:6262\W$\DBFData.add;D

ARC (and only ARC) wants to define the other connection settings aswell:

> [DBFData_info]
> Username=AdsSys
> ServerType=remote
> CommunicationType=default
> TableType=cdx
> LockingMode=compatible
> CharType=oem
> SecurityMode=ignorerights
> DBFTableType=cdx
> BlankPassword=no
> BackupDestination=
> RestoreDestination=
> ExpandedNodes=
> SchemaTemplatesLocation=


> When I open ARC and attempt to connect/Open DBFData It correctly
>asks me for the password but when i enter the password, the same as
>when set up as "DBFData=w:\DBFData.add;D" I get "Error 7078: The
>Advantage Database Server cannot authenticate the user. Make sure
>the user name and password are correct. axServerConnect

It could also be a connection error.
1) open remote management utility (ctrl-R) in ARC and try to connect
with following:

\\192.168.0.2:6262
\\192.168.0.2:6262\w$
\\192.168.0.2:6262\w$\DBFData.add

which one fails and which error code do you get?

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


Ian Branch Posted on 2009-09-01 08:34:49.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com> <xn0gemsxm391ne000@devzone.advantagedatabase.com> <4a9cc8de@solutions.advantagedatabase.com>
Date: Tue, 1 Sep 2009 18:34:49 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0gen7mghll1000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:00000194
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.168.174
X-Trace: 1 Sep 2009 02:33:33 -0700, 218.215.168.174
Lines: 34
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.168.174
Xref: solutions.advantagedatabase.com Advantage.Networking:898
Article PK: 1132309


Joachim Duerr (ADS) wrote:

> > When I open ARC and attempt to connect/Open DBFData It correctly asks me

for the password but when i enter the password, the same as when set up as
DBFData=w:\DBFData.add;D" I get "Error 7078: The Advantage Database Server
cannot authenticate the user. Make sure the user name and password are
correct. axServerConnect
>
> It could also be a connection error.
> 1) open remote management utility (ctrl-R) in ARC and try to connect with
following:
>
> \\192.168.0.2:6262
> \\192.168.0.2:6262\w$
> \\192.168.0.2:6262\w$\DBFData.add
>
> which one fails and which error code do you get?

Hi Joachim,

The first two open c:\ads_err.adt only under Open Files Tab - Open Tables.

The third also asks me for a user name and password. When I add the User Name
and password for the DBFData.add and click OK, nothing else happens. Just
c:\ads_err.adt open as previous.

this wouldn't be anything to do with the fact that the tables are all
.dbf/.cdx rather than native .adt?

Regards,

Ian


Ian Branch Posted on 2009-09-01 08:38:45.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com> <xn0gemsxm391ne000@devzone.advantagedatabase.com> <4a9cc8de@solutions.advantagedatabase.com> <xn0gen7mghll1000@devzone.advantagedatabase.com>
Date: Tue, 1 Sep 2009 18:38:45 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0gen7pymnsh001@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:00000195
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.168.174
X-Trace: 1 Sep 2009 02:37:29 -0700, 218.215.168.174
Lines: 8
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.168.174
Xref: solutions.advantagedatabase.com Advantage.Networking:899
Article PK: 1132311

Additional observation:

Probably nothing but the dialog box that pops up for the User Name and Password
for the last case says the Database: is ManagementConn.

Ian


Ian Branch Posted on 2009-09-01 08:47:06.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com> <xn0gemsxm391ne000@devzone.advantagedatabase.com> <4a9cc8de@solutions.advantagedatabase.com> <xn0gen7mghll1000@devzone.advantagedatabase.com> <xn0gen7pymnsh001@devzone.advantagedatabase.com>
Date: Tue, 1 Sep 2009 18:47:06 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0gen7xfxeof002@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:00000196
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.168.174
X-Trace: 1 Sep 2009 02:45:51 -0700, 218.215.168.174
Lines: 5
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.168.174
Xref: solutions.advantagedatabase.com Advantage.Networking:900
Article PK: 1132310

And another.

If I change the connection string to w:\DBFData.add it asks for the user name
and password then opens w:\DBFData.add OK.


Joachim Duerr (ADS) Posted on 2009-09-01 12:03:04.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com> <xn0gemsxm391ne000@devzone.advantagedatabase.com> <4a9cc8de@solutions.advantagedatabase.com> <xn0gen7mghll1000@devzone.advantagedatabase.com> <xn0gen7pymnsh001@devzone.advantagedatabase.com> <xn0gen7xfxeof002@devzone.advantagedatabase.com>
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: 130.214.79.11
Message-ID: <4a9cff68@solutions.advantagedatabase.com>
Date: 1 Sep 2009 05:03:04 -0700
X-Trace: 1 Sep 2009 05:03:04 -0700, 130.214.79.11
Lines: 14
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Networking:901
Article PK: 1132312


Ian Branch wrote:

>If I change the connection string to w:\DBFData.add it asks for the
>user name and password then opens w:\DBFData.add OK.

so this is a mapped drive of the server, not the disk name of the
server itself. Open a dos box and type
"net use"
to display the path drive W: is mapped to.

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


Ian Branch Posted on 2009-09-12 04:36:00.0Z
From: "Ian Branch" <branch@celestial.com.au>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com> <xn0gemsxm391ne000@devzone.advantagedatabase.com> <4a9cc8de@solutions.advantagedatabase.com> <xn0gen7mghll1000@devzone.advantagedatabase.com> <xn0gen7pymnsh001@devzone.advantagedatabase.com> <xn0gen7xfxeof002@devzone.advantagedatabase.com> <4a9cff68@solutions.advantagedatabase.com>
Date: Sat, 12 Sep 2009 14:36:00 +1000
User-Agent: XanaNews/1.19.1.194
Message-ID: <xn0gf2hkwdvcgs000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000001A3
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 218.215.168.174
X-Trace: 11 Sep 2009 22:34:42 -0700, 218.215.168.174
Lines: 84
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!218.215.168.174
Xref: solutions.advantagedatabase.com Advantage.Networking:902
Article PK: 1132313


Joachim Duerr (ADS) wrote:

> Ian Branch wrote:
>
> > If I change the connection string to w:\DBFData.add it asks for the
> > user name and password then opens w:\DBFData.add OK.
>
> so this is a mapped drive of the server, not the disk name of the
> server itself. Open a dos box and type
> "net use"
> to display the path drive W: is mapped to.

HI Joachim,

Sorry, been busy. When the boss calls.....

No, I am trying to avoid a mapped drive. If I map the w: drive from the
server it all works fine but as I see it, correct me if I am wrong, I
shouldn't need to map a drive. And I am trying to avoid it.

OK. Cleaned things out a little.

Running ARC on the client and trying the first address options you gave, by
doing CTRL-R in ARC and entering it into the Server drive input and clicking
connect, I get an error 6097 - Bad IP address or port. The IP is OK, I can
ping the server.

On the Server, if i do an ipconfig I get the following..
======================================================
C:\WINDOWS\system32>ipconfig

Windows IP Configuration


Ethernet adapter Local Area Connection 3:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 192.168.0.2
Subnet Mask . . . . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . . . . : fe80::222:15ff:fef6:4d04%4
Default Gateway . . . . . . . . . : 192.168.0.1

Ethernet adapter Local Area Connection 5:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 5.122.112.67
Subnet Mask . . . . . . . . . . . : 255.0.0.0
IP Address. . . . . . . . . . . . : fe80::7879:5ff:fe7a:7043%5
Default Gateway . . . . . . . . . :

Ethernet adapter Local Area Connection 7:

Media State . . . . . . . . . . . : Media disconnected

Tunnel adapter Teredo Tunneling Pseudo-Interface:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : fe80::ffff:ffff:fffd%6
Default Gateway . . . . . . . . . :

Tunnel adapter 6to4 Tunneling Pseudo-Interface:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 2002:57a:7043::57a:7043
Default Gateway . . . . . . . . . : 2002:c058:6301::c058:6301

Tunnel adapter Automatic Tunneling Pseudo-Interface:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : fe80::5efe:5.122.112.67%2
Default Gateway . . . . . . . . . :

Tunnel adapter Automatic Tunneling Pseudo-Interface:

Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : fe80::5efe:192.168.0.2%2
Default Gateway . . . . . . . . . :
================================================
Does this shed any light?

Regards,

Ian


Joachim Duerr (ADS) Posted on 2009-09-14 10:23:35.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com> <4a9c30a2@solutions.advantagedatabase.com> <xn0gemsxm391ne000@devzone.advantagedatabase.com> <4a9cc8de@solutions.advantagedatabase.com> <xn0gen7mghll1000@devzone.advantagedatabase.com> <xn0gen7pymnsh001@devzone.advantagedatabase.com> <xn0gen7xfxeof002@devzone.advantagedatabase.com> <4a9cff68@solutions.advantagedatabase.com> <xn0gf2hkwdvcgs000@devzone.advantagedatabase.com>
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: <4aae0b97@solutions.advantagedatabase.com>
Date: 14 Sep 2009 03:23:35 -0700
X-Trace: 14 Sep 2009 03:23:35 -0700, 10.56.66.155
Lines: 18
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.Networking:903
Article PK: 1132314


Ian Branch wrote:

> Running ARC on the client and trying the first address options you
>gave, by doing CTRL-R in ARC and entering it into the Server drive
>input and clicking connect, I get an error 6097 - Bad IP address or
>port. The IP is OK, I can ping the server.

Did you specify the port in the connection path? If so, then you never
worked with ADS and used ALS instead!
6097 means that the client (ARC) can't communicate to the ADS server
using that IP address and that port. Check for the ADS configuration
(IP PORT) and for the firewalls (UDP and TCP should be allowed on the
server for incoming packets on that port).

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


Peter Rosario Posted on 2009-08-31 15:02:47.0Z
From: Peter Rosario <PRosario@aibonline.org>
Subject: Re: Clarification needed please.
Newsgroups: Advantage.Networking
References: <xn0geiupi14a5a000@devzone.advantagedatabase.com> <4a9ae62b@solutions.advantagedatabase.com> <xn0gekbf59exjn000@devzone.advantagedatabase.com> <4a9b7eea@solutions.advantagedatabase.com> <xn0geketlvmsj000@devzone.advantagedatabase.com>
User-Agent: Pan/0.132 (Waxed in Black)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 64.6.140.2
Message-ID: <4a9bd807@solutions.advantagedatabase.com>
Date: 31 Aug 2009 08:02:47 -0700
X-Trace: 31 Aug 2009 08:02:47 -0700, 64.6.140.2
Lines: 31
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.6.140.2
Xref: solutions.advantagedatabase.com Advantage.Networking:894
Article PK: 1132307


>
> Ahhh. And I'm guessing that w: has to be shared on the Server but
> doesn't have to be mapped to the client?
>

w: does not have to be shared.

Advantage Database is schizophrenic:

* it's format is dBase or Advantage proprietary

* it is Windows or Linux

* it is single-user or multi-user

* a database is either a directory or a dictionary

* permissions are either file-sharing permissions or database permissions

* it is local or remote

* when it is local, it is either on a local hdd or a remote hdd

If file sharing is in use, you are not using a remote connection. You
are using a local connection to a remote hdd.

I find it confusing. I think Advantage should have created new products
when they added radically new features. A common core could be shared
among them.

Pete