For years I use ADS without problems.
I use it very simple:
There's a server (with the name Main-Server) containing the data.
The workstations just connect to ADS using the following ADS.INI:
//////
[MAIN-SERVER]
LAN_IP=192.168.0.2 // the address of the server
LAN_PORT=0 // Default, so it uses port 6262 according to
the documentation
[SETTINGS]
ADS_SERVER_TYPE=ADS_REMOTE_SERVER
//////
Nothing more is written in the ADS.INI and it works well (for years as I
mentioned earlier and it still does).
Now I want to use a VPN connection and I connect the correct drive letter to
the server (via VPN).
for instance:
NET USE H: \\Main-Server\Data
All files are listed, I can ping to MAIN-SERVER retrieving the address
192.168.0.2, thus everything seems to be ok.
When starting the application (for maximum speed of course the application
is installed localy but it uses the data on the connected drive).
Whithout ADS it can use the data on the server whithout any problem.
But I get the error 6420 (meaning that the ADS server cannot be started).
Can anyone tell me how to solve this problem so I can also connect via the
VPN connection?
kind regards,
Toni Klammer
Toni,
Change the ads.ini for the following line:
LAN_PORT=6262
The setting "0" is only applicable to the server to grab the default of
6262 (even this is not guaranteed if the port is in use). On the client
side you must specify the exact port.
Hope this helps. Once you have this you should have no more problems
connecting over the VPN (assuming there are no firewall blocking rules).
Edgar Sherman
I already found out that I had to do that, thanks.
But it does not solve the problem.
I Found an interseting discussion about it on the following link:
http://forums.novell.com/novell-product-support-forums/bordermanager/bm-vpn/44906-udp-multicast-advantage-database-client-not-working-vpn.html
I'll have to check some of the things mentioned there.
In the meantime: just wait :-)
Toni Klammer
"Edgar Sherman" <no@email.com> schreef in bericht
news:48109f6c@solutions.advantagedatabase.com...
What error are you getting when you set the correct port in the ads.ini
file?
By default "Discovery" is not possible across a VPN since the packets
are generally not routable.
Edgar Sherman
Error 6420.
The Advantage Database Server cannot be found.
"Edgar Sherman" <no@email.com> schreef in bericht
news:4810ab49@solutions.advantagedatabase.com...
getting 6420 means that the ads.ini setting is not being read. How does
your connection string looks like? If using a mapped drive, check the
mapping if it's mapped to an IP address instead of the server name. In
that case, put the IP address into the square brackets in ads.ini:
[192.168.0.2]
LAN_IP=192.168.0.2
LAN_PORT=6262
btw: leaving the port at the default value '0' on the server does not
guarantee the port 6262 being used!
--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com
The connection string is:
cConnect := "DBE=ADSDBE;SERVER=H:\WinPrj"
Befor starting the application the drive of the server is connected with the
command:
NET USE H: \\Main-Server\Data
The drive is connected properly.
When using the IP address instead, so 192.168.0.2 then an internal error
occurs:
------------------------------------------------------------------------------
ERROR LOG of "P:\HANENB~1\PROJEC~2\PROJECT.EXE" Date: 29/04/2008 14:23:00
Xbase++ version : Xbase++ (R) Version 1.82.306
Operating system : Windows XP 05.01 Build 02600 Service Pack 2
------------------------------------------------------------------------------
oError:args :
-> VALTYPE: C VALUE: DBE=ADSDBE;SERVER=H:\WinPrj
-> VALTYPE: N VALUE: 0
oError:canDefault : Y
oError:canRetry : N
oError:canSubstitute: N
oError:cargo : NIL
oError:description : Internal data structures corrupted
oError:filename :
oError:genCode : 41
oError:operation : dacConnect
oError:osCode : 0
oError:severity : 2
oError:subCode : 5
oError:subSystem : BASE
oError:thread : 1
oError:tries : 0
------------------------------------------------------------------------------
CALLSTACK:
------------------------------------------------------------------------------
Called from DACSESSION:NEW4CONNECTSTRING(247)
Called from DACSESSION:INIT(204)
Called from MAIN(97)
In this case my knowledge stops.
regards,
Toni Klammer
"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> schreef in bericht
news:4811b969@solutions.advantagedatabase.com...
since you use the mapping to H: and it seems to be connected properly,
I'm quite sure that the ads.ini file is not being read!
Can you connect using ARC->remote management?
--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com
The problem is solved!!!
It seems that I used an old version of <<<ace32.dll>>> and/or
<<<axcws32.dll>>>.
This only occured on my pc.
Now I have another problem, and that is the speed.
Problem has to do with the upload speed of the server.
Because this problem has to do with the manner I use to access files (DBF
wise),
I think I start another discussion on the newgroup
public.xbase++.data-access on
news.alaska-software.com.
Much thanks for your help
Kind regards,
Toni Klammer
"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> schreef in bericht
news:48177d70@solutions.advantagedatabase.com...
I didn't think of that option:(
reading the LAN_IP and LAN_PORT from the ads.ini file was added in ACE
6.1 ... ages ago;)
--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com