FiveTech Software tech support forums

Hi Guys,

In my country, we have a LGPD(General Protection data Law) that is demanding us to encrypt data. When we were using ADSSERVER, we used to work with encryption just doing AdsEnableEncryption("PSW") in the main program. Is there any way to do the same with MySql ? Is it possible ?

... RDDADS.LIB|adsfunc
Error: Unresolved external 'AdsGetFilter' referenced from I:\HARBOUR\LIB\RDDADS.LIB|adsfunc
Error: Unresolved external 'AdsEnableEncryption' referenced from I:\HARBOUR\LIB\RDDADS.LIB|adsfunc
Error: Unresolved external 'AdsDisableEncryption' referenced from I:\HARBOUR\LIB\RDDADS ...

... TRUE','APPEND_FAIL',NULL); END WHILE; CLOSE EncryptTables;

Notice the script above uses an ADS Store Procedure. You could also use ADSEnableEncryption() + AdsEncryptTable() API functions, as in:
( cAlias )->( AdsEnableEncryption( "EncryptionPassword" ) )( cAlias ...

... 16 ];
UNSIGNED16 usLen = sizeof( pucFormat );

la que uso HB_BOOL hb_ads_bOEM = HB_FALSE;
la otra
BOOL hb_ads_bOEM = FALSE;

HB_FUNC( ADSENABLEENCRYPTION )
{
const char * pucPassword = hb_parcx( 1 );

if( strlen( pucPassword ) )

HB_FUNC( ADSENABLEENCRYPTION )
{
const char * pucPassword ...

This time, problem seems not to become solution though was.

https://groups.google.com/forum/#!searc ... HdRb20jK4J

... occurs.

REQUEST ADS
REQUEST DBFCDX
RDDSetDefault ("ADS")

SET SERVER LOCAL
SET FILETYPE TO CDX

Use abcd.dbf New Alias abcd Via "ADS"
AdsEnableEncryption("myPassword")
AdsEncryptTable()

If execute it, lower part error occurs.
*Error DBCMD/2001 Workarea not in use: ADSENABLEENCRYPTION
Called ...

Hi,

I'm converting a app to Advantage Database Server.
I' using free table connection with AdsEnableEncryption in each table.
Evertything works ok.
The problem is now with crystal reports 11 because I dont know the connection property in order to pass the encryption password to acess tables and ...

... a client application depends on the data access mechanism you are using. For example, if you are using the ACE API, you must make a call to AdsEnableEncryption (for Advantage tables) or AdsStmtSetTablePassword (for executing SQL statements against the table), passing the table name or handle and the ...

UWE thx for reply BUT it is not what I want....
I want ADS function list, that is contained in ACE32.DLL OR ACE32.LIB if already converted.

Sample: ADSEncryptTable(), ADSDecryptTable(), AdsEnableEncryption(), etc...

Gracias Ariel, voy a probar eso

lo qie si probe es abrir una base de datos sin encryptar usando AdsEnableEncryption("passw") y la abre perfectamente, es decir ads ya se da cuenta que no esta encriptada y no pasa nada

Manuel Calero Solís, mi email es postinelli@hotmail.com

Pablo

Hola,

podes chequear asi :

1) abres el archivo
2) if (cAlias)->( AdsIsTableEncrypted() )
? "Tabla encriptada"
else
? "Tabla sin encriptar"
endif

Espero te sirva.
Salu2, Ariel.

Estoy intentando como tu probar a migrar a ADS pero tengo algunos problemas.

Me gustaria comentar contigo por mail privado.

Mi mail es watchdog@telefonica.net

Gracias.

Manuel Calero Solís.

Hola, estoy pasando mis bases de datos DBF/CDX al RDD de ADS en forma local y la idea es utilizar la funcion AdsEnableEncryption y me surgio la siguiente duda, es posible determinar si una DBF ya está encriptada?
digamos quiero hacer algo asi

Use Database Shared New

if .not. DBFencryp ...

... adsfunc
Error: Unresolved external 'AdsGetFilter' referenced from C:\FIVETECH\XHARBOUR\LIB\RDDADS.LIB|adsfunc
Error: Unresolved external 'AdsEnableEncryption' referenced from C:\FIVETECH\XHARBOUR\LIB\RDDADS.LIB|adsfunc
Error: Unresolved external 'AdsDisableEncryption' referenced from C:\FIVETECH ...

Andres,

si usas ADS Local/Server/Internet ( es lo mismo pa´ todas ) debes hacer :

USE midbf ALIAS mialias SHARED NEW
AdsEnableEncryption( cTuClavedeEncriptado )
....
....
nada mas lo usas como siempre, ahora esto es para cuando ya tienes la tabla encryptada, para encryptar/desencryptar :

USE midbf ...