Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Whip me. Beat me. Make me maintain AIX. -- Stephan Zielinski

devel / comp.lang.xharbour / ADS / DATABASE MANAGER WITH XHARBOUR

SubjectAuthor
* ADS / DATABASE MANAGER WITH XHARBOURAnderson Cardoso
`* ADS / DATABASE MANAGER WITH XHARBOURLailton Fernando Mariano
 `* ADS / DATABASE MANAGER WITH XHARBOURAnderson Cardoso
  +* ADS / DATABASE MANAGER WITH XHARBOUREnrico Maria Giordano
  |`- ADS / DATABASE MANAGER WITH XHARBOURLailton Fernando Mariano
  `- ADS / DATABASE MANAGER WITH XHARBOURdlzc

1
ADS / DATABASE MANAGER WITH XHARBOUR

<68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=10846&group=comp.lang.xharbour#10846

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:6214:a6a:b0:5ef:512f:ffe1 with SMTP id ef10-20020a0562140a6a00b005ef512fffe1mr1558210qvb.1.1683468534797;
Sun, 07 May 2023 07:08:54 -0700 (PDT)
X-Received: by 2002:aca:a891:0:b0:390:7373:386c with SMTP id
r139-20020acaa891000000b003907373386cmr1923063oie.8.1683468534373; Sun, 07
May 2023 07:08:54 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!2.eu.feeder.erje.net!feeder.erje.net!feeder1.feed.usenet.farm!feed.usenet.farm!peer03.ams4!peer.am4.highwinds-media.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Sun, 7 May 2023 07:08:54 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=206.42.32.40; posting-account=vXb10QoAAACtql4X4XBjGCZA6sGzs_sw
NNTP-Posting-Host: 206.42.32.40
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com>
Subject: ADS / DATABASE MANAGER WITH XHARBOUR
From: acardoso...@gmail.com (Anderson Cardoso)
Injection-Date: Sun, 07 May 2023 14:08:54 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2722
 by: Anderson Cardoso - Sun, 7 May 2023 14:08 UTC

Hi,

Once a time somebody told me ADS is much better than LetoDBF and it´s free up to 5 users...
xHarbour v123 is not showing ADS anymore but there´s a rddads.lib file at lib folder.

I put this code before function main()

********************************
*** CODEPAGE E CHARSET
********************************
REQUEST HB_LANG_PT
REQUEST HB_CODEPAGE_PT850
REQUEST HB_GT_WVT_DEFAULT
REQUEST HB_GT_WVT
*****************************************************
*** DEFINIR TIPO DE BANCO DE DADOS PADRÃO: DBFCDX ***
*****************************************************
// ANNOUNCE RDDSYS
REQUEST DBFCDX
REQUEST DBFFPT
Request ordfor
ANNOUNCE FPTCDX
#IFDEF __ADS
// servidor ADS
#include "ads.ch"
REQUEST ADS, ADSKEYCOUNT, ADSKEYNO, ADSGETRELKEYPOS
#ENDIF
And this after:

#IFDEF __ADS
** ADS
******
RDDSETDEFAULT( "ADS" )
RddRegister("ADS",1)
// TIPO DE ARQUIVOS DE ÍNDICES
AdsSetFileType(2) // 1- DBFNTX 2- DBFCDX 3- ADTADI
// TIPO DE SERVIDOR
AdsSetServerType(7) // 1-Local 2-Remote 3-Local+Remote 4-Internet 5-Internet+Local 6-Internet+Remote, 7-All of them
ADSRightsCheck(.F.) // ABERTURA DOS DBFs + RÁPIDA
// FAZ CONEXÃO
IF AdsConnect60( xPATH, 4, cDBFUSER, cDBFPASS)
WAIT "Servidor ADS conectado"
ELSE
WAIT "Não foi possível se conectar ao servidor ADS"
ENDIF
#ENDIF
It throw errors and I can´t find the app server. This link does not work anymore: https://devzone.advantagedatabase.com/dz/content.aspx?Key=20

What database manager do you recommend?

Re: ADS / DATABASE MANAGER WITH XHARBOUR

<380599b9-e851-4923-b68c-f5fd9946a1b4n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=10849&group=comp.lang.xharbour#10849

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:6214:1774:b0:61b:5912:b46a with SMTP id et20-20020a056214177400b0061b5912b46amr2027928qvb.1.1683554916480;
Mon, 08 May 2023 07:08:36 -0700 (PDT)
X-Received: by 2002:a05:6870:6707:b0:17f:d30c:6e62 with SMTP id
gb7-20020a056870670700b0017fd30c6e62mr3634540oab.0.1683554916131; Mon, 08 May
2023 07:08:36 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Mon, 8 May 2023 07:08:35 -0700 (PDT)
In-Reply-To: <68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2804:1b2:6042:46f:2ca0:d1f4:ce38:2ae;
posting-account=GGC3sAoAAADFtzZRelQzYctflUXFDIpz
NNTP-Posting-Host: 2804:1b2:6042:46f:2ca0:d1f4:ce38:2ae
References: <68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <380599b9-e851-4923-b68c-f5fd9946a1b4n@googlegroups.com>
Subject: Re: ADS / DATABASE MANAGER WITH XHARBOUR
From: lail...@paysoft.com.br (Lailton Fernando Mariano)
Injection-Date: Mon, 08 May 2023 14:08:36 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 3206
 by: Lailton Fernando Mar - Mon, 8 May 2023 14:08 UTC

Em domingo, 7 de maio de 2023 às 11:08:55 UTC-3, Anderson Cardoso escreveu:
> Hi,
>
> Once a time somebody told me ADS is much better than LetoDBF and it´s free up to 5 users...
> xHarbour v123 is not showing ADS anymore but there´s a rddads.lib file at lib folder.
>
> I put this code before function main()
>
> ********************************
> *** CODEPAGE E CHARSET
> ********************************
> REQUEST HB_LANG_PT
> REQUEST HB_CODEPAGE_PT850
> REQUEST HB_GT_WVT_DEFAULT
> REQUEST HB_GT_WVT
> *****************************************************
> *** DEFINIR TIPO DE BANCO DE DADOS PADRÃO: DBFCDX ***
> *****************************************************
> // ANNOUNCE RDDSYS
> REQUEST DBFCDX
> REQUEST DBFFPT
> Request ordfor
> ANNOUNCE FPTCDX
> #IFDEF __ADS
> // servidor ADS
> #include "ads.ch"
> REQUEST ADS, ADSKEYCOUNT, ADSKEYNO, ADSGETRELKEYPOS
> #ENDIF
> And this after:
>
> #IFDEF __ADS
> ** ADS
> ******
> RDDSETDEFAULT( "ADS" )
> RddRegister("ADS",1)
> // TIPO DE ARQUIVOS DE ÍNDICES
> AdsSetFileType(2) // 1- DBFNTX 2- DBFCDX 3- ADTADI
> // TIPO DE SERVIDOR
> AdsSetServerType(7) // 1-Local 2-Remote 3-Local+Remote 4-Internet 5-Internet+Local 6-Internet+Remote, 7-All of them
> ADSRightsCheck(.F.) // ABERTURA DOS DBFs + RÁPIDA
> // FAZ CONEXÃO
> IF AdsConnect60( xPATH, 4, cDBFUSER, cDBFPASS)
> WAIT "Servidor ADS conectado"
> ELSE
> WAIT "Não foi possível se conectar ao servidor ADS"
> ENDIF
> #ENDIF
> It throw errors and I can´t find the app server. This link does not work anymore: https://devzone.advantagedatabase.com/dz/content.aspx?Key=20
>
> What database manager do you recommend?

IMHO you should not spend your time with ADS anymore, it was discontinued.

Re: ADS / DATABASE MANAGER WITH XHARBOUR

<a7788a53-f42a-4c2e-8077-7d7f03eaa75cn@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=10850&group=comp.lang.xharbour#10850

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:ac8:7f0d:0:b0:3f1:fc00:6354 with SMTP id f13-20020ac87f0d000000b003f1fc006354mr4710754qtk.1.1683562111145;
Mon, 08 May 2023 09:08:31 -0700 (PDT)
X-Received: by 2002:a05:6870:727:b0:192:a793:9d4a with SMTP id
ea39-20020a056870072700b00192a7939d4amr4035182oab.5.1683562110846; Mon, 08
May 2023 09:08:30 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Mon, 8 May 2023 09:08:30 -0700 (PDT)
In-Reply-To: <380599b9-e851-4923-b68c-f5fd9946a1b4n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=206.42.32.40; posting-account=vXb10QoAAACtql4X4XBjGCZA6sGzs_sw
NNTP-Posting-Host: 206.42.32.40
References: <68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com> <380599b9-e851-4923-b68c-f5fd9946a1b4n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a7788a53-f42a-4c2e-8077-7d7f03eaa75cn@googlegroups.com>
Subject: Re: ADS / DATABASE MANAGER WITH XHARBOUR
From: acardoso...@gmail.com (Anderson Cardoso)
Injection-Date: Mon, 08 May 2023 16:08:31 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 3459
 by: Anderson Cardoso - Mon, 8 May 2023 16:08 UTC

Em segunda-feira, 8 de maio de 2023 às 11:08:37 UTC-3, Lailton Fernando Mariano escreveu:
> Em domingo, 7 de maio de 2023 às 11:08:55 UTC-3, Anderson Cardoso escreveu:
> > Hi,
> >
> > Once a time somebody told me ADS is much better than LetoDBF and it´s free up to 5 users...
> > xHarbour v123 is not showing ADS anymore but there´s a rddads.lib file at lib folder.
> >
> > I put this code before function main()
> >
> > ********************************
> > *** CODEPAGE E CHARSET
> > ********************************
> > REQUEST HB_LANG_PT
> > REQUEST HB_CODEPAGE_PT850
> > REQUEST HB_GT_WVT_DEFAULT
> > REQUEST HB_GT_WVT
> > *****************************************************
> > *** DEFINIR TIPO DE BANCO DE DADOS PADRÃO: DBFCDX ***
> > *****************************************************
> > // ANNOUNCE RDDSYS
> > REQUEST DBFCDX
> > REQUEST DBFFPT
> > Request ordfor
> > ANNOUNCE FPTCDX
> > #IFDEF __ADS
> > // servidor ADS
> > #include "ads.ch"
> > REQUEST ADS, ADSKEYCOUNT, ADSKEYNO, ADSGETRELKEYPOS
> > #ENDIF
> > And this after:
> >
> > #IFDEF __ADS
> > ** ADS
> > ******
> > RDDSETDEFAULT( "ADS" )
> > RddRegister("ADS",1)
> > // TIPO DE ARQUIVOS DE ÍNDICES
> > AdsSetFileType(2) // 1- DBFNTX 2- DBFCDX 3- ADTADI
> > // TIPO DE SERVIDOR
> > AdsSetServerType(7) // 1-Local 2-Remote 3-Local+Remote 4-Internet 5-Internet+Local 6-Internet+Remote, 7-All of them
> > ADSRightsCheck(.F.) // ABERTURA DOS DBFs + RÁPIDA
> > // FAZ CONEXÃO
> > IF AdsConnect60( xPATH, 4, cDBFUSER, cDBFPASS)
> > WAIT "Servidor ADS conectado"
> > ELSE
> > WAIT "Não foi possível se conectar ao servidor ADS"
> > ENDIF
> > #ENDIF
> > It throw errors and I can´t find the app server. This link does not work anymore: https://devzone.advantagedatabase.com/dz/content.aspx?Key=20
> >
> > What database manager do you recommend?
> IMHO you should not spend your time with ADS anymore, it was discontinued..

Which database manager to use instead nowadays?

Re: ADS / DATABASE MANAGER WITH XHARBOUR

<u3b6ug$3tvdn$1@dont-email.me>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=10851&group=comp.lang.xharbour#10851

  copy link   Newsgroups: comp.lang.xharbour
Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: e.m.gior...@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: ADS / DATABASE MANAGER WITH XHARBOUR
Date: Mon, 8 May 2023 18:10:58 +0200
Organization: A noiseless patient Spider
Lines: 16
Message-ID: <u3b6ug$3tvdn$1@dont-email.me>
References: <68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com>
<380599b9-e851-4923-b68c-f5fd9946a1b4n@googlegroups.com>
<a7788a53-f42a-4c2e-8077-7d7f03eaa75cn@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Mon, 8 May 2023 16:10:56 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="39413a091bd407d53e0ff03c252c0606";
logging-data="4128183"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+zQcL2+dTsZFEcmi5JYp5E"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.10.1
Cancel-Lock: sha1:5Tv8fh/C+i5lUeeVhHR8ejFmOUY=
In-Reply-To: <a7788a53-f42a-4c2e-8077-7d7f03eaa75cn@googlegroups.com>
 by: Enrico Maria Giordan - Mon, 8 May 2023 16:10 UTC

Il 08/05/2023 18:08, Anderson Cardoso ha scritto:

> Which database manager to use instead nowadays?

What is wrong with DBF? Otherwise, any SQL engine.

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Re: ADS / DATABASE MANAGER WITH XHARBOUR

<8cfc3ab0-b0e4-4202-a8d7-deb9fa035860n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=10852&group=comp.lang.xharbour#10852

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:622a:1899:b0:3f0:ad19:fa11 with SMTP id v25-20020a05622a189900b003f0ad19fa11mr4184246qtc.11.1683568909948;
Mon, 08 May 2023 11:01:49 -0700 (PDT)
X-Received: by 2002:a05:6870:1391:b0:193:6231:1c62 with SMTP id
17-20020a056870139100b0019362311c62mr4429992oas.6.1683568909499; Mon, 08 May
2023 11:01:49 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!1.us.feeder.erje.net!3.us.feeder.erje.net!feeder.erje.net!border-1.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Mon, 8 May 2023 11:01:49 -0700 (PDT)
In-Reply-To: <u3b6ug$3tvdn$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=2804:1b2:6042:46f:2ca0:d1f4:ce38:2ae;
posting-account=GGC3sAoAAADFtzZRelQzYctflUXFDIpz
NNTP-Posting-Host: 2804:1b2:6042:46f:2ca0:d1f4:ce38:2ae
References: <68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com>
<380599b9-e851-4923-b68c-f5fd9946a1b4n@googlegroups.com> <a7788a53-f42a-4c2e-8077-7d7f03eaa75cn@googlegroups.com>
<u3b6ug$3tvdn$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <8cfc3ab0-b0e4-4202-a8d7-deb9fa035860n@googlegroups.com>
Subject: Re: ADS / DATABASE MANAGER WITH XHARBOUR
From: lail...@paysoft.com.br (Lailton Fernando Mariano)
Injection-Date: Mon, 08 May 2023 18:01:49 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 16
 by: Lailton Fernando Mar - Mon, 8 May 2023 18:01 UTC

Em segunda-feira, 8 de maio de 2023 às 13:13:12 UTC-3, Enrico Maria Giordano escreveu:
> Il 08/05/2023 18:08, Anderson Cardoso ha scritto:
>
> > Which database manager to use instead nowadays?
> What is wrong with DBF? Otherwise, any SQL engine.
>
> --
> Enrico Maria Giordano
>
> http://www.emagsoftware.it
> http://www.emagsoftware.it/emgmusic
> http://www.emagsoftware.it/spectrum
> http://www.emagsoftware.it/tbosg

my suggestion is go with MySQL/Mariadb/PostgreSQL etc.

Re: ADS / DATABASE MANAGER WITH XHARBOUR

<c01bace6-1b41-4896-a7cf-347f44f69808n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=10853&group=comp.lang.xharbour#10853

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:622a:1786:b0:3d5:49eb:4d1e with SMTP id s6-20020a05622a178600b003d549eb4d1emr5434899qtk.1.1683644027511;
Tue, 09 May 2023 07:53:47 -0700 (PDT)
X-Received: by 2002:a05:6870:e998:b0:196:4b9:369 with SMTP id
r24-20020a056870e99800b0019604b90369mr3332372oao.5.1683644027240; Tue, 09 May
2023 07:53:47 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!weretis.net!feeder8.news.weretis.net!feeder1.feed.usenet.farm!feed.usenet.farm!peer03.ams4!peer.am4.highwinds-media.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Tue, 9 May 2023 07:53:46 -0700 (PDT)
In-Reply-To: <a7788a53-f42a-4c2e-8077-7d7f03eaa75cn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=68.107.209.13; posting-account=7bF0GwoAAABMFHX6V4fON4-1F6LFJ834
NNTP-Posting-Host: 68.107.209.13
References: <68b0c6b4-dd5f-438c-81a7-7d5be13e4a55n@googlegroups.com>
<380599b9-e851-4923-b68c-f5fd9946a1b4n@googlegroups.com> <a7788a53-f42a-4c2e-8077-7d7f03eaa75cn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c01bace6-1b41-4896-a7cf-347f44f69808n@googlegroups.com>
Subject: Re: ADS / DATABASE MANAGER WITH XHARBOUR
From: dlz...@cox.net (dlzc)
Injection-Date: Tue, 09 May 2023 14:53:47 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1918
 by: dlzc - Tue, 9 May 2023 14:53 UTC

Dear Anderson Cardoso:

On Monday, May 8, 2023 at 9:08:31 AM UTC-7, Anderson Cardoso wrote:
....
> Which database manager to use instead nowadays?

Our friends on Visual Objects had a similar discussion.

https://groups.google.com/g/comp.lang.clipper.visual-objects/c/BuRzPloYr-Q/m/vAKgk0mMAQAJ

The issue with ANYTHING is the amount of data sent over the network. Server-side solutions always outperform, and have better security. But if you don't like SQL, and must stay xBase, there are alternatives.

David A. Smith

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor