Connection with ADS by means of ADS DBE

[Auge_Ohr]

almost all SQL Server are available in 64bit and did use all CPU and Memory.
work is done "on Server" but the Client must send a "Query" and get back Result Set.

the Result Set does not have "Data" ... it just say "where" you find "Data"
so your Client must "get Data" from Server and it depend on your Hardware
and Software how fast you "get Data"

Xbase++ normal use only 1 CPU but if you call a activeX or DLL it might
run in it own Windows Thread so OS() will use "all" CPU.

when using PostgreSQL "native" with LibPG.DLL Xbase++ Client seem
to use "all" CPU when "get data" from Result Set.
when using pgDBE it seems to run under Xbase++ Rule - 1 CPU ( most No# 5 ? )
so i guess Alaska "limited" DBE to 1 CPU only ...

[rdonnay]

Where did you get that IP address that you entered in the Architect?

That is not a valid address.

[Eugene Lutsenko]

It is the address of my site: http://lc.kubagro.ru/ On it there is also a folder for the ADS databases. The IP address of this resource on which ADS is installed, I learned using a site: http://www.testip.ru/services/lookup.html. It yielded the result given on the picture: http://lc.kubagro.ru/Dima/ADS-4.GIF

[rdonnay]

That is the address of your webserver at port 80.

Remove the :80 from the address that you enter into the architect.

[Eugene Lutsenko]

Removed. Writes at once (without a pause) that connection with ADS can't be established.

[Cliff Wiernik]

What do you have configured as the internet port for ADS if you are accessing from the outside.

[Eugene Lutsenko]

It seems by means of TelNet () connection is established

http://lc.kubagro.ru/Dima/ADS-5.JPG

[Auge_Ohr]

hi,

have you setup AIS ? ( IP / Port / User )

[Eugene Lutsenko]

For connection user, only IP and port isn't required. I have no AIS, only ADS

[Eugene Lutsenko]

hi,

have you setup AIS ? ( IP / Port / User )

As adjusted ADS:

1. Setup of the server for work on public IP. For this purpose it is necessary to set Internet port:

in Advantage Configuration Utility to choose a laying of Configuration Utility, there to choose a laying of Communications and to enter Internet Port then to press Apply.

2. Firewall control on the server - he should allow to address from the Internet on ADS port (what set in settings in Advantage Configuration Utility).

3. To check from a home network possibility of establishment of communication with port of the remote ADS server:

telnet 94.25.18.126 <THE port Internet adjusted>where 94.25.18.126 - the ADS server address, the port is specified through a gap.


- if the answer is connection refused (it is refused connection), it is necessary to deal further with a home network and a firewall on the server.


- if any text is deduced or it will be simple to blink the cursor, connection with ADS on interenet-port works, and it is possible to start further control.


4. For distant work with Data Dictionary it is necessary to resolve in the DD work from the Internet: In Data Dictionary to open control, in the section Internet Access establish Enabled in it is authorized.

5. For work client ON: in a line of connection it is necessary to specify <THE address server>: <PORT number>

All utilities of ADS can work with the remote server if it is correct to specify connection control (a remote entrance through teamview isn't necessary).

6. In ARC there are connection options where it is necessary to put a tick: locally, on a network or on the Internet to establish connection.