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.

Client connection via VPN

2 posts in General Discussion Last posting was on 2003-07-12 01:25:04.0Z
Majid Ravari Posted on 2003-07-11 19:52:34.0Z
From: "Majid Ravari" <majid@lablogics.com>
Subject: Client connection via VPN
Date: Fri, 11 Jul 2003 12:52:34 -0700
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <eFcRWe#RDHA.346@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: adsl-67-127-109-33.dsl.irvnca.pacbell.net 67.127.109.33
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1322
Article PK: 3555

Greetings,

Our internal network is running a SQL Anywhere 7 and the server and all the
clients can connect with no problems.
The problem is with a remote site where a vpn client is setup. The VPN looks
good and the server and the database files are all reachable. However once
we run the program, it gives us an error: "Database server not running".

The TCP Port 2638 is also forwarded to the server.

Any help with this regards would be highly appreciated. Thank You.

Here is the code that we use for connection:


if (ClientServerOption) // Server
{
sprintf (StartupString,"%s\\DBSRV7 -x tcpip -c 12M",ServerPath) ;
sprintf (ConnectionString,"UID=%s;"
"PWD=%s;"
"ENG=%s;"
"Start=%s;"
"DBN=%s;"
"DBF=%s\\%s.db;"
"AutoStop=yes",
DBid[0],DBPwd[0],
ServerName,StartupString,DatabaseName,ServerPath,LABWORKSDB) ;
}
else // Client Server
{
sprintf (StartupString,"%s\\DBSRV7 -c 12M",ServerPath) ;
sprintf (ConnectionString,"UID=%s;"
"PWD=%s;"
"ENG=%s;"
"Start=%s;"
"DBN=%s;"
"DBF=%s\\%s.db;"
"COMMLINKS=tcpip;"
"AutoStop=yes",
DBid[0],DBPwd[0],
ServerName,StartupString,DatabaseName,ServerPath,LABWORKSDB) ;
}


result = db_string_connect (&sqlca,ConnectionString) ;


Chris Keating Posted on 2003-07-12 01:25:04.0Z
From: "Chris Keating" <Spam_Free_keating@iAnywhere.com>
References: <eFcRWe#RDHA.346@forums-2-dub>
Subject: Re: Client connection via VPN
Date: Fri, 11 Jul 2003 21:25:04 -0400
Lines: 58
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <OPEMVWBSDHA.349@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: CPE00045af8ce8c-CM012059936305.cpe.net.cable.rogers.com 24.102.85.196
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1324
Article PK: 3560

You need to include the HOST={machine name or ip address} in the LINKS
setting.

/ck

"Majid Ravari" <majid@lablogics.com> wrote in message
news:eFcRWe#RDHA.346@forums-2-dub...
> Greetings,
>
> Our internal network is running a SQL Anywhere 7 and the server and all
the
> clients can connect with no problems.
> The problem is with a remote site where a vpn client is setup. The VPN
looks
> good and the server and the database files are all reachable. However once
> we run the program, it gives us an error: "Database server not running".
>
> The TCP Port 2638 is also forwarded to the server.
>
> Any help with this regards would be highly appreciated. Thank You.
>
> Here is the code that we use for connection:
>
>
> if (ClientServerOption) // Server
> {
> sprintf (StartupString,"%s\\DBSRV7 -x tcpip -c 12M",ServerPath) ;
> sprintf (ConnectionString,"UID=%s;"
> "PWD=%s;"
> "ENG=%s;"
> "Start=%s;"
> "DBN=%s;"
> "DBF=%s\\%s.db;"
> "AutoStop=yes",
> DBid[0],DBPwd[0],
> ServerName,StartupString,DatabaseName,ServerPath,LABWORKSDB) ;
> }
> else // Client Server
> {
> sprintf (StartupString,"%s\\DBSRV7 -c 12M",ServerPath) ;
> sprintf (ConnectionString,"UID=%s;"
> "PWD=%s;"
> "ENG=%s;"
> "Start=%s;"
> "DBN=%s;"
> "DBF=%s\\%s.db;"
> "COMMLINKS=tcpip;"
> "AutoStop=yes",
> DBid[0],DBPwd[0],
> ServerName,StartupString,DatabaseName,ServerPath,LABWORKSDB) ;
> }
>
>
> result = db_string_connect (&sqlca,ConnectionString) ;
>
>