Re: looking for tips: huge archive - many clients

Hi Stefano,

As Markus wrote :

Get a demoversion of ADS from extended systems.
Install it on a windows2K or 2003 Server (yes, I know, but he wrote that he
has to)
Get Blinker7.0 and clipper 5.2e or 5.3
Use the ads env_chk (dosversion, no installation) and/or adsmgt (winprog) to
make sure that you have access.

Put Blicpurel() in the startup program
Not sure : On 5.3 put rddsetdefault("DBFNTX") into the startup program
If you have to (and only IF YOU HAVE TO) use TCP/IP protocoll on server/WS,
than you need to put adsdosip in the autostart of every workstation and it
may be necessary to execute a .reg file once on any WS. If using IPX remove
tcp/ip from server.

Relink the application with blinker and the ads libs, pay attention to the
version for tcpip or IPX

As far as I know many of the WindowsNT networking patches for clipper
programs are NOT necessary if you use a client serversystem like Ads, I
never put this patches on customers systems and they are working fine (W2K
Servers, XP WS)

HTH
Tom

With Ads even dotnettis have something to play with (odbc, oledb,Ado,...)

The following is a little linkscript for our apps on ads w2k, we use cdx
libs or xdxax (ads version) from 5.3, so that differs but may be it helps
you.
There are other options with blinker/ads like Autouse() and "request
driver", we don not use them but it makes converting your prog a little bit
easier.

BLI EXE DUAL
BLI INCRE OFF
BLI EXE CLIPPER F80
BLI PROCEDURE DEPTH 70
BLI EXE COMPRESS 1

OUTPUT NETSPIDD.EXE

file NETSPID
... more files
#file cld.lib

.. Our libs

# delivered with ads clipper client
FI C:\clip53\AXS\CLIP53\DBFCDXAX.OBJ
SEARCH C:\clip53\AXS\clip53.ip\AXIPBCOM.LIB
LIB C:\clip53\AXS\CLIP53\AOF.LIB
LIB C:\clip53\AXS\CLIP53\DBFAXS.LIB

# in Ads link we dont need no education, aehh, no ntx / no cdx everything is
dbfcdxax :-)
#LIB DBFNTX
#LIB DBFCDX,_DBFCDX

SEARCH BLXCLP53
LIB CLIPPER





































"Stefano Lambertini" <stefano.lambertini@abouteb.com> schrieb im Newsbeitrag
news:KooPd.42052$2h5.15168@tornado.fastwebnet.it...
> hello all,
> i'm dealing with a Clipper (5.2c) program used to manage
> planning-accountability-production-[other...] on two industrial plant
(about
> 250 employees).
> About 140 clients open the same archives (300 dbf with 3-4 ntx index
each).
> The archives dimensions are out of control - some of them are over
500Mbyte,
> shared by and old Novell file server.
> And, in the best tradition, no documentation are available other than the
> source code (about  230.000 lines).
> Could you help me to find information related to
> -Clipper/DBF dimensional limits
> -Clipper concurrent DBF access
> -change from Novell (3.12) to Windows (2k3)
>
> Thank you in advance,
> Stefano
>
> grazie in anticipo per qualunque aiuto,
> Stefano
>
>