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.

ASA Remote access

4 posts in General Discussion Last posting was on 2009-03-11 13:01:00.0Z
magotici Posted on 2009-03-10 18:55:50.0Z
From: "magotici" <magotici@labstat.com>
Newsgroups: ianywhere.public.general
Subject: ASA Remote access
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49b6b7b6$1@forums-1-dub>
Date: 10 Mar 2009 10:55:50 -0800
X-Trace: forums-1-dub 1236711350 10.22.241.152 (10 Mar 2009 10:55:50 -0800)
X-Original-Trace: 10 Mar 2009 10:55:50 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7400
Article PK: 5815

Hi,
How could we access our DB from an off site location (through the Internet).
Our applications are created in PowerBuilder11 and the DB is ASA 9.0.2. We
are looking for a soulution to access the DB not to synchronize it with
another one.

Thank you.


Dietrich [Sybase iAnywhere] Posted on 2009-03-11 11:05:50.0Z
Subject: Re: ASA Remote access
From: "Dietrich [Sybase iAnywhere]" <Dietrich@ianywhere.sybase.germany>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <49b6b7b6$1@forums-1-dub>
Content-Transfer-Encoding: 7bit
Message-ID: <op.uqmjr3gb2z78md@dlauterxp>
User-Agent: Opera Mail/9.64 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 11 Mar 2009 03:05:50 -0800
X-Trace: forums-1-dub 1236769550 10.22.241.152 (11 Mar 2009 03:05:50 -0800)
X-Original-Trace: 11 Mar 2009 03:05:50 -0800, vip152.sybase.com
Lines: 63
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7402
Article PK: 5818

Hi,

in case you are going to consider connecting the client application
directly to the database engine (via tcpip), you might want to encrypt the
communication (TLS).

Information abouth encrypted communication between client-server is
described in the manual. Under e.g.

SQL Anywhere Studio Security Guide > Adaptive Server Anywhere
Transport-Layer Security > Starting the database server with
transport-layer security

SQL Anywhere Studio Security Guide > Adaptive Server Anywhere
Transport-Layer Security > Configuring client applications to use
transport-layer security

You will find out that you have to create some certificates/keys/...
At the end you have to start the database server with specifc parameters
to turn on encryption e.g. using "-ec
rsa_tls(certificate=<certificate>;certificate_password=<password>)" .
And the client application has also to use specific encryption parameters
e.g. "Encryption=RSA_TLS(trusted_certificates=<certificate>)"



And of course when using the internet, UDP cannot usually be used. In
result, you would need to start the database engine on a specific port
using parameter "-x tcpip(PORT=<port>)". And on the other side, the client
application needs to use the connections parameter "-c (...;ENG=<server
name>;LINKS=tcpip(HOST=<server name/ip>;PORT=<port>)".



In regards to licensing, check if the scenarion is covered by the licences
you had already acquired or are planning to acquire.
1. Important might be the number of connecting clients as well as the
number of clients on which the ODBC driver is installed on.
2. In version 9, you must have a license for the "SQL Anywhere Studio
security option". In version 10 and higher, the basic encryption is
covered by the normal licenses and extra license is only needed for FIPS
and ECC conform encryption.



Kind regards,

dietrich

On Tue, 10 Mar 2009 19:55:50 +0100, magotici <magotici@labstat.com> wrote:

> Hi,
> How could we access our DB from an off site location (through the
> Internet).
> Our applications are created in PowerBuilder11 and the DB is ASA 9.0.2.
> We
> are looking for a soulution to access the DB not to synchronize it with
> another one.
>
> Thank you.
>
>


Dietrich [Sybase iAnywhere] Posted on 2009-03-11 12:46:13.0Z
Subject: Re: ASA Remote access
From: "Dietrich [Sybase iAnywhere]" <Dietrich@ianywhere.sybase.germany>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <49b6b7b6$1@forums-1-dub>
Content-Transfer-Encoding: 7bit
Message-ID: <op.uqmoe9i52z78md@dlauterxp>
User-Agent: Opera Mail/9.64 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 11 Mar 2009 04:46:13 -0800
X-Trace: forums-1-dub 1236775573 10.22.241.152 (11 Mar 2009 04:46:13 -0800)
X-Original-Trace: 11 Mar 2009 04:46:13 -0800, vip152.sybase.com
Lines: 54
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7403
Article PK: 5825

take also a look into the white papers:

"Optimizing Adaptive Server Anywhere Performance Over a WAN"
http://www.sybase.com/detail?id=1035348

"Understanding Encryption and Transport-Layer Security - SQL Anywhere
Studio 9.0.2"
http://www.sybase.com/content/1035475/encryption_transport_layer_security.pdf

"Securing SQL Anywhere - Server 10"
http://www.sybase.com/files/White_Papers/SecuringSA10.pdf

and of course
"Secure Mobile Computing"
http://www.sybase.com/files/White_Papers/mobile_data_security_wp.pdf

from the last one
"
In Adaptive Server Anywhere, transport-layer security protects
client/server
communications over a public or private network where transmissions could
be
intercepted by an attacker.
...
For Adaptive Server Anywhere client/server communications, you specify the
server certificate when you start the Adaptive Server Anywhere database
server.
Once you create a certificate, you can use the certificate for Adaptive
Server
Anywhere client/server communications or for MobiLink synchronization.
"


These were only a few to mention, additional documents can be found on
sybase.com


dietrich

On Tue, 10 Mar 2009 19:55:50 +0100, magotici <magotici@labstat.com> wrote:

> Hi,
> How could we access our DB from an off site location (through the
> Internet).
> Our applications are created in PowerBuilder11 and the DB is ASA 9.0.2.
> We
> are looking for a soulution to access the DB not to synchronize it with
> another one.
>
> Thank you.
>
>


magotici Posted on 2009-03-11 13:01:00.0Z
From: "magotici" <magotici@labstat.com>
Newsgroups: ianywhere.public.general
References: <49b6b7b6$1@forums-1-dub> <op.uqmoe9i52z78md@dlauterxp>
Subject: Re: ASA Remote access
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49b7b60c$1@forums-1-dub>
Date: 11 Mar 2009 05:01:00 -0800
X-Trace: forums-1-dub 1236776460 10.22.241.152 (11 Mar 2009 05:01:00 -0800)
X-Original-Trace: 11 Mar 2009 05:01:00 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7404
Article PK: 5817

Thank you, I will try to do what you are suggesting.
Manuel Agotici

"Dietrich [Sybase iAnywhere]" <Dietrich@ianywhere.sybase.germany> wrote in
message news:op.uqmoe9i52z78md@dlauterxp...
> take also a look into the white papers:
>
> "Optimizing Adaptive Server Anywhere Performance Over a WAN"
> http://www.sybase.com/detail?id=1035348
>
> "Understanding Encryption and Transport-Layer Security - SQL Anywhere
> Studio 9.0.2"
> http://www.sybase.com/content/1035475/encryption_transport_layer_security.pdf
>
> "Securing SQL Anywhere - Server 10"
> http://www.sybase.com/files/White_Papers/SecuringSA10.pdf
>
> and of course
> "Secure Mobile Computing"
> http://www.sybase.com/files/White_Papers/mobile_data_security_wp.pdf
>
> from the last one
> "
> In Adaptive Server Anywhere, transport-layer security protects
> client/server
> communications over a public or private network where transmissions could
> be
> intercepted by an attacker.
> ...
> For Adaptive Server Anywhere client/server communications, you specify the
> server certificate when you start the Adaptive Server Anywhere database
> server.
> Once you create a certificate, you can use the certificate for Adaptive
> Server
> Anywhere client/server communications or for MobiLink synchronization.
> "
>
>
> These were only a few to mention, additional documents can be found on
> sybase.com
>
>
> dietrich
>
>
> On Tue, 10 Mar 2009 19:55:50 +0100, magotici <magotici@labstat.com> wrote:
>
>> Hi,
>> How could we access our DB from an off site location (through the
>> Internet).
>> Our applications are created in PowerBuilder11 and the DB is ASA 9.0.2.
>> We
>> are looking for a soulution to access the DB not to synchronize it with
>> another one.
>>
>> Thank you.
>>
>>
>