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.

ADS via internet

6 posts in Replication Last posting was on 2007-08-23 23:46:57.0Z
Kim Jensen Posted on 2007-08-22 06:56:57.0Z
Reply-To: "Kim Jensen" <kim@comcasystems.com>
From: "Kim Jensen" <kim@comcasystems.com>
Newsgroups: advantage.Replication
Subject: ADS via internet
Date: Wed, 22 Aug 2007 02:56:57 -0400
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 66.155.143.238
Message-ID: <46cbdd10@solutions.advantagedatabase.com>
X-Trace: 22 Aug 2007 00:52:00 -0700, 66.155.143.238
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!66.155.143.238
Xref: solutions.advantagedatabase.com Advantage.Replication:247
Article PK: 1134103

I have done this before, setting up ADS to be accessed over the internet but
i can't get this to work in replication.
I have ADS (8.1) installed on a Windows SB Server, the firewall is off, the
only firewall is in the router. The internet port in ADS is 2001 and the
port is forwarded in the router to the ip address of the WSBS.
I have a shared folder with the data and all local computers can access it
without any login.

In the Subscription General tab I set the taget path to: \\11.11.11.11\My
Shared folder\MyDD.add:2001
and User name adssys I have enabled Internet access for the user.

On the Advanced tab I have selected Advantage Internet Server and Ignore
Replication Failures.

It is not connecting, is it something in the SBS that is blocking or do I
have a wrong setting?

Any help, Thanks
Kim


Joachim Duerr (ADS) Posted on 2007-08-22 07:59:55.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: ADS via internet
Newsgroups: Advantage.Replication
References: <46cbdd10@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 10.56.66.108
Message-ID: <46cbdeeb@solutions.advantagedatabase.com>
Date: 22 Aug 2007 00:59:55 -0700
X-Trace: 22 Aug 2007 00:59:55 -0700, 10.56.66.108
Lines: 14
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.108
Xref: solutions.advantagedatabase.com Advantage.Replication:248
Article PK: 1134102


Kim Jensen wrote in <46cbdd10@solutions.advantagedatabase.com>:

> It is not connecting, is it something in the SBS that is blocking or
> do I have a wrong setting?

are you able to connect via ARC from the same server with the same
settings? It could be that either the dictionary or ADSSYS has disabled
AIS access.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com


Mark Wilkins Posted on 2007-08-22 13:56:07.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.Replication
References: <46cbdd10@solutions.advantagedatabase.com>
Subject: Re: ADS via internet
Date: Wed, 22 Aug 2007 07:56:07 -0600
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 10.24.38.228
Message-ID: <46cc3f4b@solutions.advantagedatabase.com>
X-Trace: 22 Aug 2007 07:51:07 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:249
Article PK: 1134104

Hi Kim,

It looks like the path has the port number in the wrong spot. I think it
should be:

\\11.11.11.11:2001\My Shared folder\MyDD.add

Mark Wilkins
Advantage R&D

"Kim Jensen" <kim@comcasystems.com> wrote in message
news:46cbdd10@solutions.advantagedatabase.com...
>
> In the Subscription General tab I set the taget path to: \\11.11.11.11\My
> Shared folder\MyDD.add:2001


Kim Jensen Posted on 2007-08-22 20:45:37.0Z
Reply-To: "Kim Jensen" <kim@comcasystems.com>
From: "Kim Jensen" <kim@comcasystems.com>
Newsgroups: advantage.Replication
References: <46cbdd10@solutions.advantagedatabase.com> <46cc3f4b@solutions.advantagedatabase.com>
Subject: Re: ADS via internet
Date: Wed, 22 Aug 2007 16:45:37 -0400
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 76.231.246.194
Message-ID: <46cc9f4a@solutions.advantagedatabase.com>
X-Trace: 22 Aug 2007 14:40:42 -0700, 76.231.246.194
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!76.231.246.194
Xref: solutions.advantagedatabase.com Advantage.Replication:250
Article PK: 1134105

You are right the port was in the wrong place but now I get a error 7083: An
Advantage Data Dictionary connection is required when I try to connect with
ARC.

Kim

"Mark Wilkins" <mark@no.email> wrote in message
news:46cc3f4b@solutions.advantagedatabase.com...
> Hi Kim,
>
> It looks like the path has the port number in the wrong spot. I think it
> should be:
>
> \\11.11.11.11:2001\My Shared folder\MyDD.add
>
> Mark Wilkins
> Advantage R&D
>
> "Kim Jensen" <kim@comcasystems.com> wrote in message
> news:46cbdd10@solutions.advantagedatabase.com...
>>
>> In the Subscription General tab I set the taget path to: \\11.11.11.11\My
>> Shared folder\MyDD.add:2001
>
>


Mark Wilkins Posted on 2007-08-23 23:46:57.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.Replication
References: <46cbdd10@solutions.advantagedatabase.com> <46cc3f4b@solutions.advantagedatabase.com> <46cc9f4a@solutions.advantagedatabase.com>
Subject: Re: ADS via internet
Date: Thu, 23 Aug 2007 17:46:57 -0600
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 10.24.38.228
Message-ID: <46ce1b43@solutions.advantagedatabase.com>
X-Trace: 23 Aug 2007 17:41:55 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:252
Article PK: 1134108

Hi Kim,

That makes it sound like the server does not recognize the existence of
mydd.add. I believe the 7083 error means that the connection request made
it to the server, but the dictionary was not actually found. Verify that
the path and dictionary name are correct. There are a couple of variations
on what cause the 7083; if you provide the entries from the error log
(ads_err.*) for that error, I might be able to determine more what the
problem is.

Mark Wilkins
Advantage R&D

"Kim Jensen" <kim@comcasystems.com> wrote in message
news:46cc9f4a@solutions.advantagedatabase.com...
> You are right the port was in the wrong place but now I get a error 7083:
> An Advantage Data Dictionary connection is required when I try to connect
> with ARC.
>
> Kim
>


Kim Jensen Posted on 2007-08-23 02:51:59.0Z
Reply-To: "Kim Jensen" <kim@comcasystems.com>
From: "Kim Jensen" <kim@comcasystems.com>
Newsgroups: advantage.Replication
References: <46cbdd10@solutions.advantagedatabase.com>
Subject: Re: ADS via internet
Date: Wed, 22 Aug 2007 22:51:59 -0400
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 76.230.152.201
Message-ID: <46ccf527@solutions.advantagedatabase.com>
X-Trace: 22 Aug 2007 20:47:03 -0700, 76.230.152.201
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!76.230.152.201
Xref: solutions.advantagedatabase.com Advantage.Replication:251
Article PK: 1134106

One thing I found today is that I get a 5004 error on the SBS when in ARC I
tried to export a free table to the same existing DD bound table.

I can do it with no problem on a computer with XP pro.

Is there any security in SBS I need to turn off?

I'm login as Administrator.

Thanks,
Kim